0

I cannot find the right method/way/syntax to change my IP listener address on an Always On availability group under SQL Server 2016.

I have a listener, myldag on port 1433 IP 150.1.2.3 and I want to change this IP to 150.2.4.5

Using SSMS I can add an existing one using the following SQL

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

Is there a way to add a listener via SSMS?
Can someone please help me 🙂 ?

  • 1
    You can add & remove IPs, but you cannot alter in a single step. – AMtwo Sep 17 at 12:08
  • ok, many thanks – Luce Sep 18 at 13:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.