The other day i was building a SQL AlwaysOn environment in Microsoft Azure. As any of you who are familiar with SQL AlwaysOn you must first create the Windows Server Failover Clustering (WSFC)
WSFC creates a Cluster network name resource for use in identifying your cluster via DNS.
Typically this looks something like clustername.yourdomain.com. clustername is added to your Active Directory as a Computer Object together with an associated DNS (A)host record that will exist in DNS.
The issue is simple, if there are DNS servers that exist in your list of DNS entries associated with your SQL Nodes that cannot resolve your Clustername then you will receive the Error 1196 ”
“Cluster network name resource ‘Cluster Name’ failed registration of one or more associated DNS name(s) for the following reason:
DNS server failure. ”
Check your DNS entries for your cluster nodes. Ensure they ALL can resolve the clustername. Entries such as google DNS (126.96.36.199 and 188.8.131.52) should be removed!!!!
Take the cluster offline then Bring Online should resolve the issue. You may have to reboot the server once you update your DNS entry list.