Client Application not honoring the Failover Partner and connecting to the Mirror DB Server after a fail-over RRS feed

  • Question


    We have successfully setup mirroring in a test environment which includes primary, mirror, and witness.  If I force a failover or stop the primary SQL service, the DBs all fail over correctly to the Mirror, but our .Net application which uses System.Data.SQLClient (ADO.Net) does not fail-over to the mirror server by honoring the "Failover Partner" in the connection string.  This is the string we are using:


    <add name="PicassoConnectionString" connectionString="Data Source=dbprimary.picasso.local;Failover Partner=dbmirror.picasso.local;Initial Catalog=Picasso_Sites;Integrated Security=False;User ID=sa;Password=********" providerName="System.Data.SqlClient" />


    Anyone else experiencing this issue?

    Sunday, June 22, 2008 5:42 PM

All replies