Unable to Connect w/NT authentication

  • 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.

  • 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

  • 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