September 10, 2001 at 10:58 am
I have set up an access client database to run as the front end for a sql server 7 database. I am using a DSN with NT authentication. I am noticing that sometimes the users are unable to connect if they leave their computers over the weekend without restarting and logging back in. Is there a cause for this? If so could you let me know how to remedy this problem. Thanks.
September 10, 2001 at 12:24 pm
The session expires and doesn't re-auth properly. they will have to log out of the application and possibly their machine. The client program should detect for an open state and if it doesn't exist then try to reconnect with the proper user/pass.
Wes
September 27, 2001 at 12:05 am
Also check your errorlog to see if the TCP port is bound when SQL last started.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply