Connection string should include FailOver parameter
Server = myServerAddress;database=My Database;Integrated Security=SSPI;Failover Partner=Failover Server
Note: The Failover Partner keyword is not supported by .NET Framework version 1.0 or 1.1 , so if you application is built in VisualStudio 2003 database Mirroring will not work.
No comments:
Post a Comment