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

Question

question

rehaan asked May 25, '18

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.png listener.png please

always-on ip-address ag

ag.png (4.7 KiB)

listener.png (22.4 KiB)

2

10 |1200

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

Magnus Ahlkvist commented · May 28, 2018 at 08:21 AM

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 ·

rehaan Magnus Ahlkvist commented · May 29, 2018 at 11:32 AM

Hi Magnus ,

I am trying to achieve this

https://docs.aws.amazon.com/quickstart/latest/sql/step3.html

We want to build 2 SQL instances in same zone A, to avoid latency issues. As it is same zone I assume we will have only 1 subnet (I am not a sysadmin), but as per the attachments in my question, you can see we have a dedicated IP to listener in each zone. Now we are creating a new instance in the existing zone and I believe I need a IP for that. When i try to add IP using TSQL , it throw me this

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

0 ·

listener1.png (113.0 KiB)

question