Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 fix Time Out

Author  Topic 

Grifter
Constraint Violating Yak Guru

274 Posts

Posted - 2012-01-19 : 10:53:21
Hi

Simple Question, how can i fix my time out so that this doesn't happen after a long time idle:


quote:
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.)


So after this i need to reconnect and copy my queries over into a new query instance.

Thanks

G

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-01-19 : 12:20:56
It seems you lost your network connection or the SQL service restarted. Check the error log to see if it was due to SQL.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -