Skill ошибка 41105

December 21, 2014 at 4:52 am

#296243

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??

Perry Whittle

SSC Guru

Points: 233821

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??

sej2008

SSCarpal Tunnel

Points: 4495

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…

Perry Whittle

SSC Guru

Points: 233821

if you’re having issues with networking have your network admin help you

sej2008

SSCarpal Tunnel

Points: 4495

I wish they were experts in this so that they could help me….anyways I am trying…

• Remove From My Forums

• Question

• Hi I am upgrading to Sql 2012 and tried to work with High availability group concept of Sql 2012.

  I need to know 2-3 things.When I configure AO for sql 2012

   I do not need any shared storage I believe, so went on configuring WSFC on windows server 2008 R2.

  The problem I encounter that when I validated My report for clustering there were no errors…but
  
  the moment I create Cluster it gives warning of Quorum setting saying»Node Majority is not recommended»
  there is also red icon on my FCM console.My machines have not failover…so no problem

  I have one vmmachine as DC and two Nodes on vmware for clustering..

  Second thing is if I try to still create AOGroup it throws 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
  ——————————

  what should i do????

  ---

  srm_2010

• Remove From My Forums

• Question

• Hi I am upgrading to Sql 2012 and tried to work with High availability group concept of Sql 2012.

  I need to know 2-3 things.When I configure AO for sql 2012

   I do not need any shared storage I believe, so went on configuring WSFC on windows server 2008 R2.

  The problem I encounter that when I validated My report for clustering there were no errors…but
  
  the moment I create Cluster it gives warning of Quorum setting saying»Node Majority is not recommended»
  there is also red icon on my FCM console.My machines have not failover…so no problem

  I have one vmmachine as DC and two Nodes on vmware for clustering..

  Second thing is if I try to still create AOGroup it throws 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
  ——————————

  what should i do????

  ---

  srm_2010