IP change on WSFC with SQL Server Availibility Groups

• Imke Cronje

  SSCarpal Tunnel

  Points: 4826

  More actions

  November 21, 2017 at 1:31 am

  #409782

  Hi Guys,

  One of our infrastructure architects changed the IP Address where our SQL Server Availability Groups setup is hosted. We have a 2 Node synchronous setup. Once the changed was made to the IP, the AG did not sync. The secondary replica could not be accessed and the databases were not synchronized.

  The only workaround for this was to drop the AGs, and recreate them again.

  Does anyone know what the recommended solution is for changing an IP address for the WSFC and bringing the databases in sync again. Is dropping the AG groups the only workaround?

  Regards

• Jo Pattyn

  SSC-Dedicated

  Points: 32439

  More actions

  December 16, 2017 at 9:30 am

  #1972382

  The documentation mentions the windows failover cluster manager
  with screenshots