SQL Mirroring issue where the WC sees the mirrored database not the principal

  • I have a 2 node windows cluster with SQL 2012 ENT installed. There are 4 databases, 3 are using Availability Groups and 1 used SQL Mirroring for HA. After doing some failover test I have an issue when I connect with the Windows Cluster name. It sees the 3 databases (with AG) on node 1, but even though the Principal server is node 1, it is seeing the mirroring database on node 2. That means my users cannot connect to that 4th database. Any thoughts?

  • what I am really asking is "How do I add a SQL mirrored database into a Windows cluster"?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply