Share via

Not able to join new nodes into the present AG

Sai 126 Reputation points
2021-07-28T13:37:32.57+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,843 questions
0 comments
Accepted answer
  1. AmeliaGu-MSFT 13,976 Reputation points Microsoft Vendor
    2021-07-29T02:59:00.85+00:00

    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.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,731 Reputation points
    2021-07-28T18:46:58.373+00:00
    0 comments
  2. Sai 126 Reputation points
    2021-08-02T08:35:03.543+00:00

    Thank you All:)

    The above solution is worked.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.