Monday, February 8, 2016

SQL Server connection string for mirror ( automatic failover ) database...




Connection string on application side

Server=192.168.4.14\mssqlserver1,41076; Failover Partner=192.168.4.14\mssqlserver2,49250; Network=dbmssocn; Connection Timeout=60; database=testdb1; User ID=sa; password=1qaz2wsx@; Pooling=True;

Below are the mandatory attributes
Server
Failover Partner
Network=dbmssocn;
Database



No comments:

Post a Comment