what's the idle timeout of SQL login connection?
Hi.. I have application which is connected to my SQL 2000 database. Normally our users use Terminal service to the SQL 2000 and application (same box) remotely and connect to the database. But some time the connection break and I have idle login stuck there.
For example, if I use sp_who, I can see many logins still login to DB even they are out. And sometimes I see duplicate logins too even there is only one person using that login to logon to DB. Is there a way to find out what is the idle timeout of the user login session??
Is that under SQL server properties -->remote server connections-->Query time-out--> >> sec ?
Is there a way to limit only 1 session can be allow for each login ??
remote conn timeout has been removed from SQL Server, and I haven't been able to find anything close to it. I think that is what you were looking for.
you can poll and kill their spid though if you want....
Using Enterprise Manager select your SQLServer, right click on it and choose Properties-> Connections
Then you should be able to set the maximum number of concurrent connections for users, see also this for reference:
Aforsythe suggestion is also good, poll the system for idle connections and kill them.
June 28th, 2005, 05:49 AM
>>poll the system for idle connections and kill them
what is the command to poll idle connection ?
I used sp_who but almost the all SPID status show as "sleeping" and cmd status "awaiting command" but I am sure that they are still active
June 28th, 2005, 05:54 AM