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
Have you completely and correctly assigned IP addresses to the cluster and the listener from both subnets, via both failover cluster manager and SSMS?
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.
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.
16 People are following this question.
