I have two SQL Server instances in an availability group. They are not mirrored.
I'm trying to connect to the AG using the MS JDBC drivers (4.0) with a connection string including
multiSubnetFailover=true (MSDN) and getting the following error:
com.microsoft.sqlserver.jdbc.SQLServerException: Connecting to a mirrored SQL Server instance using the multiSubnetFailover connection property is not supported. ClientConnectionId:<hex-id-string> errorCode sqlState[08S01]
It seems to think that mirroring is still enabled. Yet
- if I try
alter database d set partner off, for example, it complains that the database is not configured for database mirroring.
select * from sys.database_mirroringyields a row full of
NULLs for every database.
Is there anywhere else that SQL Server might store some mirroring configuration, or some other way that it's getting confused?
Edit: Worth noting that without the
multiSubnetFailover setting, this just works.