Altering avaibilty group listener IP

  • luce

    SSC Rookie

    Points: 45

    Hi !

    I don't find the right way/syntax to change my ip listener adress on a always on avaibility group under sql 2016

    I mean , i have my listener myldag on my dag mydag, port 1433 ip 150.1.2.3 and i want to change this ip to 150.2.4.5

    I dont find the way to do it under SSMS and with transact sql, i don't find option to change an existing ip, only to add one like

    ALTER AVAILABILITY GROUP [mydag] MODIFY LISTENER N'myldag ' (ADD IP (N'150.2.4.5', N'255.255.255.0')

    but not something like .. ALTER IP  ...

    Does someone could help me 🙂 ?

    Thx

     

  • Site Owners

    SSC Guru

    Points: 80373

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply