Can I auto-disconnect usersgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
I have a problem where my users connect to my SQL 6.5 databases via a front end screens (MS Access for example). Once they connect and do their business, they fail to close the front end app. or they minimize the front end and it sits open on the users end all day. Is there a way I can set the server to automatically disconnect the users if they are idle on the server for for "X" minutes?
-- Anonymous, February 15, 2000
Change the registry settings for: HKEY_LOCAL_MACHINE.SYSTEM.CurrentControlSet.Services.Tcpip.Parameters
If you do not have one, create the Key (DWORD) named KeepAliveTime, and enter the value in milliseconds (3600000 for an hour). The second key is:
HKEY_LOCAL_MACHINE.SYSTEM.CurrentControlSet.Services.Netbt.Parameters and the key is SessionKeepAlive (the values are the same). This one is for NetBios connected users.
Hope this helps,
-- Anonymous, February 23, 2000