Friday, May 17, 2013

Error when opening New AlwaysOn Availability Group Wizard in SSMS 2012


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)


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



3 comments: