I am setting up a lab for testing automatic failover for SQL Server
I have a 2 node WSFC (SQL-CLUSTER-TEST-01) with the nodes
A listener SQL-HA-GRP-01
My initial testing is to just power off either of the nodes (virtual machines). It it failing correctly in one direction - SQL-TEST-01 to SQL-TEST-02. But when SQL-TEST-02 is the primary and I pull the power on it, the availability group goes into a permanent "resolving" state which I can only resolve by powering on SQL-TEST-02.
When I check the logs or try to view the properties of the availability group it says the quorum was lost.
What am I missing?