Add a node to availability alwayson group. It’s an multi-subnet and the node is a DR node on a different subnet.
It is a three node cluster two in same data center (US East) and third node is in DR (US Central).
Node A – 172.28.76.12
Node B – 172.28.76.13
Node 3 – 172.29.77.14
Error Message Received while adding the Node 3 in Replica Set.
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
None of the IP addresses configured for the availability group listener can be hosted by the server . Either configure a public cluster network on which one of the specified IP addresses can be hosted, or add another listener IP address which can be hosted on a public cluster network for this server.
Failed to join local availability replica to availability group the operation encountered SQL Server error 19456 and has been rolled back. Check the SQL Server error log for more details. When the cause of the error has been resolved, retry the ALTER AVAILABILITY GROUP JOIN command. (Microsoft SQL Server, Error: 19456)
Once looked at the IP addresses under the network name in the “Failover Cluster Manager” and found that there were only one IP range is added one in 172.28.XX.XX Whereas the replica that we were attempting to add was in 172.29.XX.XX range. now added an IP address (172.29.77.45) in the DR subnet as a dependency of the network name in the configured Listener “AG-Listner”. After adding the IP address in the cluster configuration we again attempted to join the replica and issue fixed node is added successfully.