Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooting Skills

  • Blog Stats

    • 1,327,519 hits
  • Select GETDATE()

    September 2011
    M T W T F S S
    « Jul   Nov »
  • Advertisements

Help: AlwaysOn Setup Failing with Error! What should I do?

Posted by blakhani on September 26, 2011

While preparing for the Virtual TechDays Session, I received an email where AlwaysOn Setup was failing on Windows Server 2008 with below error message while attempting to use the create new availability group wizard in SQL Server Management Studio.


Here is the text for message for better search.

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.


My research of pre-requisites revealed that we need below patch to be available on the operating to make it work.
1. KB 976097 ( Hotfix to add support for asymmetric storages to the Failover Cluster Management MMC snap-in for a failover cluster that is running Windows Server 2008 or Windows Server 2008 R2)

– Supports SQL Server Failover Cluster Instances with AlwaysOn Availability Groups

2. KB 2494036 (A hotfix is available to let you configure a cluster node that does not have quorum votes in Windows Server 2008 and in Windows Server 2008 R2)

– Supports configuring optimal quorum with non-automatic failover targets

This is already documented in

See you at Virtual TechDays!

Balmukund Lakhani
Twitter @blakhani


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: