question

rehaan avatar image
rehaan asked

Can we add multiple IP's to a Listener in same subnet

Hi,

I am trying to add a new node to existing AG

My 2 nodes are in same zone AWS. Hence there subnets are same but different IP'S.

Once I add the new node I am trying to add new IP for the new node to the listener but it is throwing me an error

I am running the below sql to achieve this

ALTER AVAILABILITY GROUP AAGTest MODIFY LISTENER N'prod-ag-test' (ADD IP (N'10.16.16.158','10.16.16.0'))

Msg 19451, Level 16, State 0, Line 4
'10.16.16.158' and '10.16.16.25' belong to the same subnet. Only one IPv4 and/or one IPv6 address from each subnet is allowed. For an advanced configuration, see the Windows Server Failover Clustering (WSFC) administrator to create a customized configuration through the Cluster Manage

How can I achieve/fix this please.

Please refer to the attached screens hots. any help would be much appreciatedag.pnglistener.png please

always-onip-addressag
ag.png (4.7 KiB)
listener.png (22.4 KiB)
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image Magnus Ahlkvist commented ·

I don't get what you are trying to do really. Why do you need to add multiple IP-addresses for the same subnet to the listener? The idea with the listener is that you connect to the listener's IP-address, and your connection gets directed to the active node. Adding a new node within the same subnet as an existing node doesn't require a new listener-IP to be added. Adding a new listener-IP just makes things unnecessarily complex.

0 Likes 0 ·
Show more comments

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.