"Validating WSFC quorum vote configuration" warning when you create an AlwaysOn availability group in SQL Server 2012

Article translations Article translations
Article ID: 2833122 - View products that this article applies to.
Expand all | Collapse all

On This Page

Symptoms

When you create an AlwaysOn availability group by using the New Availability Group Wizard in Microsoft SQL Server 2012, you receive a warning message that resembles the following:

The current WSFC cluster quorum vote configuration is not recommended for this availability group.

Collapse this imageExpand this image
Image 1


More information

This issue occurs because of any of the following causes in your Windows cluster environment or availability group configuration.

Cause 1

You did not install KB2494036 to all Windows cluster nodes that were designated as hosting replicas. To work around this issue in this situation, install KB2494036, and then rerun the New Availability Group Wizard.

For more information about the prerequisites for AlwaysOn availability groups, go to the following Microsoft Developer Network (MSDN) website:


Cause 2

You create an availability group without automatic failover in SQL Server 2012 (version 11.0.2100.60). Specifically, you configure the availability group by using one of the following methods:
  • When you set up the availability group in the wizard, you configured a replica for asynchronous availability mode.
  • When you set up the availability group in the wizard, you configured a replica for manual failover mode.

To work around this issue in this situation, upgrade SQL Server 2012 to SQL Server 2012 Service Pack 1 (SP1), and then rerun the New Availability Group Wizard.

Note This issue is resolved in SQL Server 2012 SP1.

Cause 3

A secondary replica is hosted by your Windows cluster node. This replica is configured for automatic failover without a vote. This configuration may be by design for your particular deployment. In this situation, you can safely ignore the warning message. 

To check whether a particular cluster node has a vote, see the NodeWeight value on the nodes. To obtain the NodeWeight value, run the following Windows PowerShell cmdlets:

Get-ClusterNode | <cluster name>, Nodeweight

Collapse this imageExpand this image
Image 2


Cause 4

A primary replica is hosted by your Windows cluster node without a vote. This configuration may be by design for your particular deployment. In this situation, you can safely ignore this warning message.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 2833122 - Last Review: April 3, 2013 - Revision: 2.0
Applies to
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • SQL Server 2012 Enterprise Core
Keywords: 
kbsurveynew kbtshoot kbexpertiseadvanced KB2833122

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com