Error:

While trying to setup 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”

Fix:

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.

Sources:

Last modified: March 15, 2021

Author

Comments

Write a Reply or Comment