none
Change An IP Availability Group Listener (SQL Server)

    Frage

  • 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) ?

    Dienstag, 16. Juli 2013 03:37

Antworten

  • 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

    Donnerstag, 18. Juli 2013 07:02
    Moderator

Alle Antworten

  • 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

    Donnerstag, 18. Juli 2013 07:02
    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


    Donnerstag, 31. Oktober 2013 05:07