SQL Availability Group Setup – The local node is not part of quorum

Problem

While trying to set up a couple of SQL Enterprise servers in an Availability Group I kept getting the message “The local node is not part of quorum and is therefore unable to process this operation”

I had already set up Windows Failover Clustering with a cloud witness for the quorum. and ticked “Enable AlwaysoOn Availability Groups” in SQL Server Configuration Manager

The local node is not part of quorum and is therefore unable to process this operation

Solution

I had done things in the wrong order. I had ticked “Enable AlwaysoOn Availability Groups” in SQL Server Configuration Manager before setting up my Windows Cluster and my cloud witness.

I went back into SQL Server Configuration Manager un-ticked “Enable AlwaysoOn Availability Groups” on both servers, rebooted, and then re-ticked the “Enable AlwaysoOn Availability Groups” followed by another reboot of both servers.

The local node is not part of quorum and is therefore unable to process this operation

7 thoughts on “SQL Availability Group Setup – The local node is not part of quorum”

  1. Great article! This caught me out too.

    I am building out a SQL AlwaysOn cluster using DSC, and when i enable AlwaysOn before i create the cluster then all fails.

    Creating the cluster and then enabling AlwaysOn works a treat!

    Reply

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.