AG - High Avail - can't remove IP

• krypto69

  SSChampion

  Points: 13604

  More actions

  October 14, 2015 at 1:54 pm

  #312320

  Hi,

  I am using SQL2014 with HA/AG groups and was adding an extra listener when I used the incorrect IP address.

  I had thought the 'remove' button would work, but it does not. Also I tried deleting it manually:

  delete from sys.availability_group_listener_ip_addresses where listener_id = '26d37cdb-5a6f-43a0-ab0c-f4343eeac0f2'

  delete from sys.availability_group_listeners where group_id = '6B060505-CDDC-44B6-A9AD-38FC6AD4A7AA'

  Ad hoc updates to system catalogs are not allowed.

  I attached an image.

  How can I remove the invalid IP?

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  October 15, 2015 at 8:17 am

  #1833512

  Can't you just delete the listener through the GUI and re-create it?