Problem: If
you are setting up availability group using New AlwaysOn Availability Group
Wizard and if you get following error message.
TITLE: Microsoft SQL Server Management Studio
------------------------------
The local node is not part of quorum and is therefore unable to process this operation. This may be due to one of the following reasons:
• The local node is not able to communicate with the WSFC cluster.
• No quorum set across the WSFC cluster.
For more information on recovering from quorum loss, refer to SQL Server Books Online.
(Microsoft.SqlServer.Management.HadrTasks)
------------------------------
The local node is not part of quorum and is therefore unable to process this operation. This may be due to one of the following reasons:
• The local node is not able to communicate with the WSFC cluster.
• No quorum set across the WSFC cluster.
For more information on recovering from quorum loss, refer to SQL Server Books Online.
(Microsoft.SqlServer.Management.HadrTasks)
Solution 1:
Go to SQL Server Configuration Wizard and disable AlwaysOn High Availability
Restart SQL.
After restart enable AlwaysOn High Availability again thru SQL Configuration Manager.
Restart SQL Services
and try again to open the wizard
Solution 2: make
sure all pre-requisites are setup properly. Refer to following link
thanks.. works on 2016 as well
ReplyDeletegood
ReplyDeleteAwesomme.. Thank you. Solution worked like charm.. Agreed with Greg works on 2016 as well.
ReplyDelete