SQL Server Performance

Application Server to Point to Mirror Server

Discussion in 'SQL Server 2005 Database Mirroring' started by garylou, Dec 4, 2006.

  1. garylou New Member

    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.

  2. satya Moderator


    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.
  3. MohammedU New Member


    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.

Share This Page