vhabalnortol
asked on
Connection string to mirrored SQL2008 R2 server not working
I have 3 servers, principal, mirrored, and witness. Once I add the failover partner line to my connection string, and shutdown the principle sql server newly created records fail to locate the mirrored server. I have tried all 3 ways of editing the Failover Partner syntax to include an underline (Failover_Partner), a space (Failover Partner), and as one word (FailoverPartner). None of these work. Here is my connection string which works until I add Failover Partner. Any Ideas.
Set objConnection = CreateObject("ADODB.Connec
objConnection.ConnectionSt
ID=logon;PASSWORD=password
objConnection.ConnectionTi
objConnection.Open
Set objConnection = CreateObject("ADODB.Connec
objConnection.ConnectionSt
ID=logon;PASSWORD=password
objConnection.ConnectionTi
objConnection.Open
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The error had to do with login permissions on the mirror database
ASKER
The error had to do with login permissions on the mirror database
ASKER
I have the Data Source = PrincipalServer\instance1 & the failover partner as MirrorServer\instance2.
When I failover the principal server, the mirror server becomes the principal server. When both servers are on-line I can access the principle server, but the mirror server which is in a state of (Mirror, synchronzied/restoring ) will not let me access its database until the principal fails over and makes the mirror the principle. I think that if I were to make the datasource the mirror server, that my connection string probably would not be able to pass data to the mirror. Are you suggesting that I need to make the Data source the mirror server, and the failover partner the principle server? I have a different instance name for the mirror, and principle; does that matter? The mirror server that I have set up seems to be working fine it's just when I try to send data externally through my connection string that it will not add records to the mirror server after it takes the role of principle, after the original principle fails over. Hope I ddn't confuse you.