- You have installed two Microsoft SQL Server 2012 instances on a server that is running Windows Server 2008 R2 that is in a failover cluster.
- Both of the SQL Server instances have AlwaysOn availability groups configured.
- You have added a file share witness in order to achieve quorum.
Issue 1When you view Cluster Quorum Information in SQL Server Management Studio, the value in the Vote Count column for both of the instances is Not Available.
Note You cannot achieve quorum if the voting nodes are not available. We do not recommend this situation in a production environment.
Issue 2When you try to run the New Availability Group wizard in order to create a new AlwaysOn availability group, you may receive a warning message that resembles the following:
Issue 3When you try to query the following sys.dm_hadr_cluster_members dynamic management view, the value that is contained in the number_of_quorum_votes column may be NULL:
Select member_name, number_of_quorum_votes from sys.dm_hadr_cluster_memberselect member_name, number_of_quorum_votes from sys.dm_hadr_cluster_members
File Share Witness 1
Article ID: 2761129 - Last Review: Nov 19, 2012 - Revision: 1