FailoverPartner not connecting with primary is down

I am having issues getting failover working with mirrored databases. Below is my information on driver I am using and connection string info. Any help would be greatly appreciated!

Database (Name/Version) : Microsoft SQL Server 10.00.6000
Driver (Name/Version) : Microsoft JDBC Driver 4.0 for SQL Server 4.0.2206.100 (JDBC 4.0)

Connection String:

jdbc:sqlserver://10.1.0.28;SelectMethod=direct;sendStringParametersAsUnicode=true;MaxPooledStatements=1000;failoverPartner=(10.1.0.27);databaseName=DBNAME;portNumber=1511

NOTE: If I reverse the IP's, so make the failover .28 it works just fine. This is because the current active server is 27, therefore failover is not working properly.

0 answers