Not able to join new nodes into the present AG

Question

Hi All,
We have add SQL DR nodes to production cluster(On premises). 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

Answer 1

Hi Sai-0641,

Welcome to Microsoft Q&A.
Please try to add the secondary replica’s static subnet IP address to the alwayson listener in the listener properties.
Please refer to this article and this similar thread which might help.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Please see:
https://blog.sqlauthority.com/2017/02/13/sql-server-fix-error-19456-none-ip-addresses-configured-availability-group-listener-can-hosted-server/

Answer 3

Thank you All:)

The above solution is worked.