Hello.
We are running SQL Server 2019 CU11 on Windows Server 2019.
We have recently run into an issue where availability group failovers are failing to update DNS for the listener.
We have some servers that will update without issue when a failover occurs.
However on our more recently builds we have added the following update - June 8, 2021—KB5003646 (OS Build 17763.1999). This appear to be when the issue started occurring.
We have gone back to our previous image and the failovers do work and as soon as we add KB5003646 and reboot the issue starts occurring.
In the properties of the listener (within the AG Role) in the Failover Cluster Manager we see DNS Status: DNS Operation Refused.
Any assistance would be appreciated.
Thank you.
Andy.