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)
SQL Server’da bir Availability Group silinip, cluster tarafında değişiklik yapıldıktan sonra tekrar Availability Group oluşturulmak istediğinizde aşağıdaki hatayı alabilirsiniz.
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)
Bu hatanın çözümü için aşağıdaki adımları uygulayabilirsiniz.
- SQL Server Configration Manager’dan SQL Server Services sekmesi açılır.
- Burada SQL Server servisinin üstüne sağ tık yapılıp, Properties kısmı açılır.
- Always On Availability Groups sekmesinde “Enable Always On Availability Groups” taki tik kaldırılıp, servis restart edilir.
- Daha sonra tekrardan “Enable Always On Availability Groups” aktif edilip, servis restart edilir.
- Servis restartı sonrasında Availability Group oluşturulabilir.
