About Me

My photo
I am an MCSE in Data Management and Analytics, specializing in MS SQL Server, and an MCP in Azure. With over 19+ years of experience in the IT industry, I bring expertise in data management, Azure Cloud, Data Center Migration, Infrastructure Architecture planning, as well as Virtualization and automation. I have a deep passion for driving innovation through infrastructure automation, particularly using Terraform for efficient provisioning. If you're looking for guidance on automating your infrastructure or have questions about Azure, SQL Server, or cloud migration, feel free to reach out. I often write to capture my own experiences and insights for future reference, but I hope that sharing these experiences through my blog will help others on their journey as well. Thank you for reading!

Cluster resource 'SQL Network Name (XXXSQL01)' failed to go online because its associated computer account (XXXSQL01) exists in Active Directory and the Kerberos authentication is not enabled for the resource. Client applications that are using Kerberos based authentication (either directly or through the Negotiate security package) will fail to authenticate when contacting a service by this network name. To bring the resource online, either enable Kerberos authentication or delete the computer account.

Issue:-

Sometimes in Windows Server 2003 Windows Cluster you get error

Issue:-

Cluster resource 'SQL Network Name (XXXSQL01)' failed to go online because its associated computer account (XXXSQL01) exists in Active Directory and the Kerberos authentication is not enabled for the resource. Client applications that are using Kerberos-based authentication (either directly or through the Negotiate security package) will fail to authenticate when contacting a service by this network name.
 To bring the resource online, either enable Kerberos authentication or delete the computer account.


Problem:-

The reason for this could be that the changes in Active Directory isn't
replicated around to all Domain Controllers. You could initiate Force
Replication but if you are in an enterprise environment this could cost in
terms of bandwidth. Hence when you delete the computer account and it's not
replicated you would get this message.

Resolution:-
Start-->run-->cluadmin.exe-->right click on the resource group and on right pane click on SQL Network Name --> Right click on the SQL Network Name--> Click on Parameters Tab and select the check box      DNS Registration Must Succeed 
Enable Kerberos Authetication.
Then try to bring the resource on line. it will come up.