This was not an issue with Windows 2008 Clustering but was instead an oversight when windows clustering was configured. For clustering, the Cluster resource name must have full access to the Virtual Cluster Names, so when failover takes place, DNS entries can be updated.
Following errors were recorded in event logs when it registrations fail:
Cluster network name resource ‘SQL Network Name (VirutalClusterName)’ failed registration of one or more associated DNS name(s) for the following reason:
DNS signature failed to verify.
Ensure that the network adapters associated with dependent IP address resources are configured with at least one accessible DNS server.
To fix this, you’ll need permissions to update the DNS entire permissions for the VirtualClusterName resource name:
- In DNS Management (dnsmgmt.msc):
- Find the VirtualClusterName that is failing to register.
- Right-Click Properties.
- Select the Security Tab.
- Click Add.
- Click Object Types.
- Check off “Computers“; uncheck other options selected.
- Enter in the name of the cluster (a.k.a Cluster Name Object (CNO)).
- Click Check Names; Verify that the entry has been found.
- Click OK.
- Give the CNO FULL Control over this record.
- Click OK.