• DBA

    SQL server the timeout period elapsed prior to completion of the operation

    SQL server clustering the timeout period elapsed prior to completion of the operation Recently I faced one of our application could not connect. It throws an error ” Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2) ” I found the problem. It’s because of firewall. SQL Cluster error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)   We are using SQL server failover clustering on our application, after a failover occurred the application could not connect it. It’s used a…