DB connection lost during database failover when shutting down principle SQL Server

book

Article ID: CTX205092

calendar_today

Updated On:

Description

If you have two CDC with SQL 2008 Mirror enabled, during the HA test you may notice that once the principle SQL server is shut down, database would immediately complete the failover, however Desktop Studio would fail to launch. If the failover is conducted without performing a shutdown of the principle host, Desktop Studio works fine.

Resolution

After adding Connection Timeout=150 in connection string of DDC, issue disappeared

Problem Cause

Seems we hit the SQL problem that described on
http://blogs.msdn.com/b/sqlblog/archive/2011/06/14/net-application-doesn-t-connect-to-the-sql-server-after-a-database-mirroring-failover.aspx

Was this article helpful?

thumb_up Yes

thumb_down No