question

SaiVijaya avatar image
SaiVijaya asked

Multi subnet issue while joining databases from DR Replicas to Production Always on

Hi All,

We are add SQL DR nodes to production cluster. Presently production cluster has 2 nodes and trying to add two mode nodes from DR. We have added new nodes to WFSC and enabled always on in new nodes. Restored databases with no recovery in new nodes and tried to join it in the AG but got the below error. If I add one more IP will it resolve the issue.

Error: None of the IP addresses configured for the AG can be hosted by the node3.

Please suggest

availability-groups
10 |1200 characters needed characters left characters exceeded

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

anthony.green avatar image
anthony.green answered

Have you completely and correctly assigned IP addresses to the cluster and the listener from both subnets, via both failover cluster manager and SSMS?

10 |1200 characters needed characters left characters exceeded

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

SmithSean avatar image
SmithSean answered

In my case,

I looked at the IP addresses under the network name in the “Failover Cluster Manager” and found that there were two IPs: one in 10.150.xx.xx and one 10.160.xx.xx range. We saw that the replica that we were attempting to add was in 10.140.xx.xx. So, we then added an IP address in the appropriate subnet as a dependency of the network name.

In short, this error can be resolved by adding the right IP to the listener. The IP address for all subnets cannot be an IP address already in use, i.e. The IP address of one of the nodes. After adding the above, we again attempted to join the replica. And as expected, the operation succeeded.

1 comment
10 |1200 characters needed characters left characters exceeded

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

Hi,

I have added multi subnet IP's in the listener and and added replica. but I can see only one network subnet in failover manager. next week we are going to test DR failover test. Will it failover successfully.

Please suggest

Note: 4 nodes added in failover manager. all are showing online. but instead of seeing two subnets I am able to see only one subnet in failover manager.

0 Likes 0 ·

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.