Problem description: You have got odd number of nodes. To prevent possible ties in the quorum vote you added a witness disk to the cluster and adjusted the quorum mode in the cluster manager.
However, when you perform a failover from SSMS on our SQL Server 2012 Availability group, we got a validation WSFC quorum vote configuration warning with action required
Error message: The current WSFC cluster quorum vote configuration is not recommended for this availability group.
Cause: This issue occurs because of a known issue in Windows Server Failover Clustering.
Resolution: To resolve this issue, you have to apply the hotfix below on all computers node of your cluster:
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 R2http://support.microsoft.com/kb/2494036
Current status: After applied the fix, you should see that the warning is vanished.
Michel Degremont | Xbox Live Music - DBA Team - SQL Server & PDW |
Problem description: When you try to connect to your SQL Server by using powershell, .Net, sqlcmd... you got this error message:
System.ArgumentException: Keyword not supported: 'applicationintent'. at System.Data.SqlClient.SqlConnectionStringBuilder.set_Item(String keyword, Object value) at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
Cause: The message occurs when you include ApplicationIntent=ReadOnly (AlwaysOn Availability Groups properties) in your connection string. And the server does not recognize the property.
KB Extract number 2544514: "When the ApplicationIntent property is set to ReadOnly, the client requests a read access operation when it connects to an AlwaysOn-enabled database. The server will enforce the read-only access operation both at connection time, and during a USE database statement, but only to an AlwaysOn-enabled database. When the ApplicationIntent property is set to ReadWrite, the client requests a regular (read-write) access operation when it connects to an AlwaysOn-enabled database. The default setting for the ApplicationIntent property is ReadWrite."
Resolution: You have to install the update that introduces support for the AlwaysOn features from SQL Server 2012
- Update 4.0.2 for Microsoft .NET Framework 4 – Runtime Update
- An update introduces support for the AlwaysOn features from SQL Server 2012 to the .NET Framework 3.5 SP1