December 21, 2014 at 4:52 am
While working with AO
I got following 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
------------------------------
Can anyone tell me what clould hjave gone wrong??
December 21, 2014 at 10:15 am
as i said, you're trying to run before you can walk.
break this down and fully understand each of the technologies before you go any further.
Why are you blindly posting in multiple forums, are you using sql 2012 or 2014??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 21, 2014 at 12:39 pm
I am on Sql 2012 enterprise edition....but since I never got any satisfactory answer to my problem I put up post in sql 2014...
what to do I am trying hard since last 1 month and still not getting break through.......:w00t::w00t:
try to understand my difficulty...I am not a network person but I still have to show demo in my company so I am learning...
December 21, 2014 at 2:38 pm
if you're having issues with networking have your network admin help you
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 22, 2014 at 11:36 am
I wish they were experts in this so that they could help me....anyways I am trying...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply