Forum Discussion

Taktech's avatar
Taktech
Copper Contributor
May 09, 2022

server 2019 DNS clients not updating when a listener in a SQLavailability group switches

Hi Everyone,

 

We are running a 2012 DC with 2012 and 2016 clients connecting. I recently done a POC whereby I had  4 server configured with server 2016 connecting to a 2012 DC. 2 of the server was configured with sql 2019 running availability groups/Listener. The other two was client machine writing to the SQl 2019 DB. When the server running the primary DB in the listener gets rebooted the listener auto detects this and immediately switches the inactive to active. This is observed successfully from the windows clients side running window server 2016 and there is no break in service when writing to the DB. There is a second or two drop and when pinging the listener name and then it responds with the new IP (New active listener IP) - this scenario works perfect.

 

The exactly same setup above using windows 2019 server on the 4 servers and still connecting to a 2012 DC results in connectivity lost when the server running the active node in the availability group is rebooted.  Some test performed is that when the listener IP is pinged at this point it responds with the inactive node IP.  Only once a ipconfig /flushdns is performed it responds with the active IP.

 

Like I said further up this is not observed with the POC running windows 2016 server.

 

Any ideas will be great. Taariq

 

1 Reply

  • MikiPatel's avatar
    MikiPatel
    Copper Contributor

    Taktech 

    I am seeing the exact same issue. Would you mind sharing the solution, if you have found one?

     

    Thanks

     

Resources