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 and I want to change this IP to

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

MODIFY LISTENER N'myldag ' (ADD IP (N'', N'')

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.