Altering avaibilty group listener IP

• luce

  SSC Enthusiast

  Points: 193

  More actions

  September 16, 2020 at 4:18 pm

  #3788902

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

  More actions

  September 17, 2020 at 5:10 pm

  #3789217

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

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