Practical SQL Server

Management Studio Timeout Issues

Timeouts are a real pain, and I was helping someone debug their problems and found this useful info, its from Andy on the SQL Server newsgroups:

A couple of other possibilities worth checking.
 
In Object Explorer right click on the SQL Server 2005 instance select Properties. I am assuming that you may be attempting to connect remotely.
 
On the Connections tab check the value of Remote_query timeout.
 
On the Advanced tab check the value of Remote Login Timeout.
 
Hope this helps!
Reed
Published Friday, January 12, 2007 8:24 PM by Reed

Comments

No Comments
Anonymous comments are disabled

© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Microsoft
Page view tracker