December 21, 2014 at 4:55 am
While doing windows Clustering on windows server 2008 R2 sp1 f
AO HAG for sql 2012 I get NODE Majority Warning.
I tried to configure WFC without any storage so quoram is set to Node majority and when I try to do AO Group I get folowing error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Creating availability group resulted in an error. (Microsoft.SqlServer.Management.HadrTasks)
------------------------------
ADDITIONAL INFORMATION:
Create failed for Availability Group 'Aogrp1'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.3000.0+((SQL11_PCU_Main).121019-1325+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+AvailabilityGroup&LinkId=20476
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Failed to create the Windows Server Failover Clustering (WSFC) resource with name 'Aogrp1' and type 'SQL Server Availability Group'. The resource type is not registered in the WSFC cluster. The WSFC cluster many have been destroyed and created again. To register the resource type in the WSFC cluster, disable and then enable AlwaysOn in the SQL Server Configuration Manager.
Failed to create availability group 'Aogrp1'. The operation encountered SQL Server error 41105 and has been rolled back. Check the SQL Server error log for more details. When the cause of the error has been resolved, retry CREATE AVAILABILITY GROUP command. (Microsoft SQL Server, Error: 41105)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.3000&EvtSrc=MSSQLServer&EvtID=41105&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
where things have gone?????:w00t:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply