Tuesday, November 4, 2008

Management Studio connection to SQL 2005 64 bit Server throws error "Timeout expired. The timeout period elapsed"

Today one development server gave below error message

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)

Solution:
The Reason for this is mainly Firewall Block. Refer this post on how to use PortQry.exe to check the firewall block.

So when firwall blocks TCP and then if named pipe is enabled it may work when you increase connection timeout. Also you can try using IP Address of the server instead of hostname if it is default instance!

No comments:

Post a Comment

Please do not spam!