June 25, 2006 at 8:26 pm
Hello!
My connection from SQL Server Management Studio gets disconnected after some idle time. This is somewhat annoying. I got following message:
Msg 10054, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
I was wondering if there is a way to configure Management Studio so that it is always connected similar to QA.
Thanks,
Igor
June 28, 2006 at 8:00 am
This was removed by the editor as SPAM
July 5, 2006 at 4:29 pm
-View registered servers in SQL server management studio
-Make sure your server is registered, if not, register it
-Right-click on your server in the registered servers list and select 'Properties'
-Connections tab
-Set the connection timeout to 0 seconds
I believe this will cause your management studio to stay connected when it is idle, while allowing other connections to timeout as configued elsewhere
July 6, 2006 at 2:31 pm
According to BOL: '
Connection timeout
Enter the number of seconds to wait for a connection to be established before timing out. The default value is 15 seconds.'
I do not think this setting defines how long idle connection stays open. I will give it a try though.
Thanks,
Igor
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply