Application Server to Point to Mirror Server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Application Server to Point to Mirror Server

Hi All, I have tested mirroring for a few days. The app server is using a connection string in the registry to point to SQL server. When failover happens, how can I tell the app server to failover and run against the mirrored server and mirrored database? Please advice. Thanks. -Gary Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. There are many ways to write the connection string, but here is one example, specifying server A as the principal, server B as the mirror, and AdventureWorks as the database name: "Data Source=A;Failover Partner=B;Initial Catalog=AdventureWorks;Integrated Security=True;" Mohammed U.