I have 3 servers on VMware workstation:
- Win 2012 R2 as ADDC -Cluster service.
- Win 2012 R2 as SQL server primary replica .
Win 2012 R2 as SQL server secondary replica (auto fail-over).
My Availability group fail in this scenario:
When I disconnect primary replica from the network the cluster fail to announce a fail-over to secondary replica when I try to manual fail-over from secondary replica instance I get this error:
however this not the case when I stop primary replica from cluster manager because it will do auto fail-over.
Ok I found what I was missed and it was the cluster because there is only two nodes in the cluster so I add third node and it is working now.