About Me

My photo
I am MCSE in Data Management and Analytics with specialization in MS SQL Server and MCP in Azure. I have over 13+ years of experience in IT industry with expertise in data management, Azure Cloud, Data-Canter Migration, Infrastructure Architecture planning and Virtualization and automation. Contact me if you are looking for any sort of guidance in getting your Infrastructure provisioning automated through Terraform. I sometime write for a place to store my own experiences for future search and read by own blog but can hopefully help others along the way. Thanks.

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.