SQL Always On automatic failover incase of multiple secondary
Disable automatic failover for Node 3. This way it will always automatically failover between Nodes 1 &amp; 2 only. If you encounter a scenario where one of these nodes dies and you need Node 3 to become an automatic failover node, simply change the setting.