none
Change An IP Availability Group Listener (SQL Server)

    Question

  • Dear All,

    Please Help Me,

    I want to change IP Availability Group Listener (SQL Server) to Different IP

    Is't possible to change  IP Availability Group Listener (SQL Server) ?

    Tuesday, July 16, 2013 3:37 AM

Answers

  • Hello,

    Availability Group Listener can uses one or more Static IP addresses. To add new Adds the specified IP address to the availability group listener, please refer to the following statement:
    ALTER AVAILABILITY GROUP group_name 
    MODIFY LISTENER ‘dns_name’
    ADD IP { (‘four_part_ipv4_address’,  ‘four_part_ipv4_mask’) | (‘dns_nameipv6_address’) }

    Reference:http://msdn.microsoft.com/en-us/library/ff878601.aspx

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    Thursday, July 18, 2013 7:02 AM
    Moderator

All replies

  • Hello,

    Availability Group Listener can uses one or more Static IP addresses. To add new Adds the specified IP address to the availability group listener, please refer to the following statement:
    ALTER AVAILABILITY GROUP group_name 
    MODIFY LISTENER ‘dns_name’
    ADD IP { (‘four_part_ipv4_address’,  ‘four_part_ipv4_mask’) | (‘dns_nameipv6_address’) }

    Reference:http://msdn.microsoft.com/en-us/library/ff878601.aspx

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    Thursday, July 18, 2013 7:02 AM
    Moderator
  • Hello,

    Availability Group Listener can uses one or more Static IP addresses. To add new Adds the specified IP address to the availability group listener, please refer to the following statement:
    ALTER AVAILABILITY GROUP group_name 
    MODIFY LISTENER ‘dns_name’
    ADD IP { (‘four_part_ipv4_address’,  ‘four_part_ipv4_mask’) | (‘dns_nameipv6_address’) }

    Reference:http://msdn.microsoft.com/en-us/library/ff878601.aspx

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    Will you be able to add an additional IP for the same subnet? Guess you will be using CluAdmin here.


    yup


    • Edited by yup. _ Thursday, October 31, 2013 5:08 AM
    Thursday, October 31, 2013 5:07 AM