locked
Can't remove IP?!?!? What the .. RRS feed

  • Question

  • 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:

    [quote]
    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'[/quote]

    Ad hoc updates to system catalogs are not allowed.

    I attached an image.

    How can I remove the invalid IP?

    qeqw

    Wednesday, October 14, 2015 7:58 PM

Answers

  • Try this... once you remove then its free and you can use it again or use different IP and release this IP...

    https://msdn.microsoft.com/en-us/library/hh231526.aspx#TsqlProcedure


    Raju Rasagounder Sr MSSQL DBA

    • Proposed as answer by Martin.CairneyMVP Wednesday, October 14, 2015 11:42 PM
    • Marked as answer by rqwew Thursday, October 15, 2015 1:29 PM
    Wednesday, October 14, 2015 10:55 PM

All replies

  • Try this... once you remove then its free and you can use it again or use different IP and release this IP...

    https://msdn.microsoft.com/en-us/library/hh231526.aspx#TsqlProcedure


    Raju Rasagounder Sr MSSQL DBA

    • Proposed as answer by Martin.CairneyMVP Wednesday, October 14, 2015 11:42 PM
    • Marked as answer by rqwew Thursday, October 15, 2015 1:29 PM
    Wednesday, October 14, 2015 10:55 PM
  • I don't  think you understood the question.

    The above user want to remove the IP <only> not the entire Listener, I have the same issue.

    Why is the 'Remove' button there, if you cannot use it. 

    Also 'Alter Availability Group Modify Listener' has a 'Add IP' option but no corresponding 'Remove IP'.

    <modify_listener_option>::=
        {
           ADD IP ( <ip_address_option> ) 
         | PORT = listener_port
        }

    Tuesday, February 2, 2016 8:51 PM