Error:
Failed to obtain cluster information. Either the specificed instance of SQL Server is not running on a Windows Server Failover Cluster (WSFC) node, or the user lacks sysadmin permissions on the SQL Server instance to obtain the cluster information.
Resolution:
Make sure you restart SQL Server services after setting the AlwaysOn setting.
Error:
SQL SERVER – FIX: Msg 41105: Failed to Create the Windows Server Failover Clustering (WSFC) Resource With Name and Type ‘SQL Server Availability Group’
Resolution:
Disable and Enable the feature using SQL Server Configuration Manager and restart SQL Server service.
Note: Make sure to Disable the feature and hit Apply. Then Re-enable the feature and hit Apply.
Comments