This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 52%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Hi All,
We have a failover cluster in place for our SQL environment. I have noticed that when it fails over it creates a new DNS record for the new IP of the SQL listener.
I have removed all the DNS records, created one and then I have set up the DNS record to have the CNO and Nodes have full control of that DNS record.
When I do a failover I see that a new DNS record is created for the new IP, but the old one is still there. It does not seem to just change the DNS record. So now we have an issue of DNS round Robin in play.
Is there a way to fix this issue?
Thanks
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
To clarify, you have a Failover Clustered instance (not an AG) and you have 2 nodes and a multi-subnet configuration?
Apologies for that reply.
We have an AG, and, correct, there are 2 nodes in a multi-subnet config.
I found the solution.
I had to look through the registry under HKEY_LOCAL_MACHINE\Cluster\Resources
Find the listener cluster resource GUID. Expand and look in Parameters
Change RegisterAllProvidersIP to 0
Did this on both nodes. Failed over to other node and now it updates only one DNS entry (as long as it has the CNO in there with Full Control)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @Jason P,
Thank you for your reaching out and welcome to Microsoft Q&A!
It sounds like there are still a few records in there. You can check for SRV records using NS lookup:
How to verify that SRV DNS records have been created for a domain controller
Also under the zone properties, make sure it is removed from the Name Servers tab.
I hope this helps! If you have any more issues or need further assistance, feel free to share with us!
Best regards,
Lucy Chen
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
https://docs.microsoft.com/en-us/answers/support/email-notifications
You have not understood the problem at all and this is not the first time you have responded to problems I have raised in this forum with completely irrelevant information. Where do SRV records come in to play with MS Clusters ? Please in future, if you are unsure or do not fully understand the question please refrain from posting comments. Better yet, please remove this answer completely and your follow up comment which only looks like you are trying to get kudos where none should be given
