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!