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.
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 notreplicated you would get this message.
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 notreplicated 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.