asked
SSMS query windows automatically disconnecting
I've recently rebuilt my dev machine with 2008 R2 Developer Edition and it's doing a strange thing. If I leave a SSMS query window open and inactive it gets disconnected. I'm connecting to (local) so I guess it's using the Shared Memory protocol. I've been using SQL Server since 2000 and I've never seen this behaviour before. Any ideas, please?
I have not seen that behavior. Is it possible that your local service is stopping and starting as the system goes into sleep mode (assuming Win 7)? Mine does.
Doh! I should have known it would be something stupid. Yep, Win 7 was set to sleep after 30 minutes. Thanks, Grant.
I get this problem occasionally (SSMS 2005), but only when I connect to remote server which might have a poor quality network connection at that time. The good news is that after I attempt to execute a statement and receive a
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.)greeting, all I need to do is to just hit F5 again, and it runs just fine. For sanity check I sometimes RDC to the host and run **netstat -s -p tcp**, and usually I do see a rather high ratio of **Segments Retransmitted / (Segments Sent + Segments Received)**, as high as 1% sometimes. When the quality is this bad, I guess the occasional drop of idle connection is justified.
I havent seen your issue but I have had may strange problems with SSMS of 2008 R2; it is very buggy and if you havent applied recent cumulative update I suggest you do since it contains many fixes for the SSMS.
