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

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, re-start SQL Server services, and then re-ticked the “Enable AlwaysoOn Availability Groups” followed by another re-start SQL Server services of both servers.

Reference:

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

Last modified: September 26, 2023

Author

Comments

Write a Reply or Comment