VMware Cloud Community
JoJoGabor
Expert
Expert

VCenter 6 with a mirrored database

I know Vmware don't explicitly support SQL mirroring but it should work. I have a mirrored database but when the DB fails over, VCenter slowly dies and attempting to restart the services results in failures. I know the DB is ok because if I change the DNS alias to point to the recovered DB instance, everything works.

What needs to be setup? All I have done is use a SQL NAtive Driver 64-bit ODBC connection and entered the details for the mirrored instance. Does something else need to be configured?

0 Kudos
1 Reply
Redbridge
Enthusiast
Enthusiast

I know with vCenter Server Heartbeat when you fail over to the passive SQL Server you have to delete the SPN Record for the Primary and then add the SPN for the Passive(Now Active) Server, not sure if it would work the same way with Mirroring

0 Kudos