Saturday 19 May 2012


SQL 2008 R2 'Cluster Name' registration failure .. event ID 1196 and Event ID 1119

this is important for setting up SQL 2008 fail-over cluster.
Check evenlog for the event id 1196 or 1119. 

cause : 
while creating static record the option "allow any authenticated user to update DNS records with the same owner" was not selected. So, cluster nodes (active node) who will own the cluster name resource won't be able to register this resource record to the DNS database.  

Solution:
Go to DNS, find the record ( A & Pointer record) for the cluster name resource.





-right click
-go to properties
-select security make sure the "Authenticated users" are included
-make sure it has "Write: rights and Special permissions
-click Advance, locate authenticated users, and click edit
-make sure, Write all properties, Read permissions, All Validated Writes are selected
-click okay three times to exit



0 comments: