Friday , June 21 2024

Microsoft SQL Server Error: 41105

In today’s article, we will explain how to solve the “Microsoft SQL Server, Error: 41105” error we receive when creating an Availability Group.

When you want to create an Availability Group again after deleting an Availability Group in SQL Server and making changes on the cluster side, you may receive the following error.

Failed to create the Windows Server Failover Clustering (WSFC) resource with name ‘TESTAG’ 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 Always On in the SQL Server Configuration Manager.
Failed to create availability group ‘TESTAG’. 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)

You can follow the steps below to solve this error.

1. The SQL Server Services tab opens from SQL Server Configuration Manager.

2. Here, right-click on the SQL Server service and open the Properties section.

3. In the Always On Availability Groups tab, uncheck “Enable Always On Availability Groups” and restart the service.

4. Then, “Enable Always On Availability Groups” is activated again and the service is restarted.

5. After the service restart, an Availability Group can be created.

Loading

About Melek Durdu

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories