slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Administration Forums - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General Administration | New Thread

View: Search:

Author

Thread: Remote User's DBs constantly detach

Konstantin Vishnevsky
Posts: 97

Remote User's DBs constantly detach Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 May 07 2:57 PM

Recently I have many of my Remotes complaining that they cannot login to SLX, and when I RDP into their computers, all I have to do is reattach the DB and everything works.
All I got from SAGE tech support is: "Well, maybe some other program that uses MDSE detaches it. Monitor the user's PC"
I wish it was that simple. I am a one man band and I have enough things to do except monitoring my 160+ Remotes.

Any ideas?

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Remote User's DBs constantly detach Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 May 07 3:03 AM

Check the SQL Logs and Application Logs - there *must* be a reason for this - it's highly unusual and never heard of this before.

[Reply][Quote]

David Henry
Posts: 207

Re: Remote User's DBs constantly detach Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 May 07 8:06 AM

When you detach the remote DB make sure you delete the LDF file that was created when you last attached the remote DB. This way when you reattach the remote DB a new LDF will be created.

[Reply][Quote]

Konstantin Vishnevsky
Posts: 97

Re: Remote User's DBs constantly detach Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 May 07 9:03 AM

Quote:

Originally posted by Mike Spragg

Check the SQL Logs and Application Logs - there *must* be a reason for this - it's highly unusual and never heard of this before.

Does MSDE keep a separate log somewhere?

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Remote User's DBs constantly detach Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 May 07 9:07 AM

yes, the same as the server:

c:\pf\microsoft sql server\mssql\log - check errorlog (the most current log)

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/9/2025 8:32:41 AM