We run two SQL server at primary site in AlwaysOn High Availability Group on subnet A third SQL server is running on secondary site in a different subnet We have had third server as part of a cluster for some time until faced issue from this question. It was then decided to remove the third server from the cluster and all of the resources that it presented.

Right off the bat DNS registration for subnet had to be removed, but it is now being registered every 24 hours. Whenever it is registered, all clients start to use and fail to connect. This occurred even when all three servers were running and syncing properly, and some clients would just drop live connection just to connect to ip on a different subnet which would fail.

Where can I find this subet IP address that is still being registered with DNS server? SQL Management studio group listener lists only one IP in correct subnet. Fail-over cluster lists single network IP address too. The third server has since been powered off, but it is irrelevant

Get-ClusterGroup SQLHA | Get-ClusterResource | Where-Object {$_
.ResourceType -match "Network Name*"} | Update-ClusterNetworkNameResource -Verbose

After running this command DNS server is updated, but yet again two records are created.

  • I have seen that post and thought about applying those changes to avoid having multiple dns records to different IPs, but the whole idea of having third server at different site has been scraped and third server was removed from availability group and cluster. None of its resources show up in cluster manager, yet somehow every 24 hours a second DNS record for availability group is registered with DNS server. What role is responsible for making this registration? Sep 18, 2015 at 17:30
  • blogs.msdn.com/b/clustering/archive/2009/07/17/9836756.aspx If the network name group is not moved or there are no new dependencies or there are no changes to the name, then the registration is refreshed only once in 24 hours. Have you tried flushing DNS? The purpose of the RegisterAllProvidersIP parameter is to make sure the DNS entry is already written to the DNS server on the other network subnet. social.msdn.microsoft.com/Forums/en-US/…
    – stacylaray
    Sep 19, 2015 at 7:00


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.