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 18.104.22.168 and I want to change this IP to 22.214.171.124
Using SSMS I can add an existing one using the following SQL
ALTER AVAILABILITY GROUP [mydag] MODIFY LISTENER N'myldag ' (ADD IP (N'126.96.36.199', N'255.255.255.0')
Is there a way to add a listener via SSMS?
Can someone please help me 🙂 ?