Listener IP Not Reachable from Primary Server in Hybrid Availability Group Setup

kedar giri 81

Hello there,

I have configured a 3-node SQL Server Availability Group with the following setup:

Primary Node: On-premises (10.10.1.10)
HA Node: On-premises (10.10.1.11)
DR Node: Azure VM (10.0.0.4)

The listener is configured with two IP addresses for the hybrid setup:

On-premises Listener IP: 10.10.1.22
Azure Listener IP: 10.0.0.22

The issue I’m facing is that the listener IP on Azure (10.0.0.22) is not reachable from the Primary Node (10.10.1.10) on-premises. To resolve this, I added the Azure listener IP (10.0.0.22) as a static IP in the Azure VM's network interface settings under IP Configurations, but the issue persists still Ip is unreachable.

I’m unclear about the correct configuration for this hybrid scenario and cannot find clear guidance on ensuring connectivity for the listener IP across the on-premises and Azure networks.

Additional Details:

All servers are domain-joined.
DNS records exist for all nodes, including the listener IPs.
Connectivity between the on-premises network and Azure DR node is established (via Site to Site VPN).

Is this behavior expected, or is there something I’m missing in the configuration?

All there configuration is done on SQL Server 2016 Enterprise.

Thank you for your assistance!

Sai Raghunadh M 1,450 Reputation points Microsoft Vendor

2024-11-28T11:16:13.0666667+00:00

Hi @ kedar giri,Thanks for the question and using MS Q&A platform.

can you please tell us the exact error you are getting so that we can help you better to resolve the issue.
kedar giri 81 Reputation points

2024-11-29T07:44:04.94+00:00

hello @Sai Raghunadh M , there is not error particularly, but whenever i try to ping DR Listener IP 10.0.0.22 from On-premises server it is not reachable. I am confuse that, Is this behavior expected in hybrid scenario or am i missing something in configuration.
Sai Raghunadh M 1,450 Reputation points Microsoft Vendor

2024-11-29T12:26:36.18+00:00
Hi @ kedar giri

Based on your setup, it seems that the issue may be related to network connectivity or routing between your on-premises network and Azure, which is preventing the primary node from reaching the Azure listener IP.

Here are some troubleshooting steps and recommendations to help resolve the issue:

Ensure the Site-to-Site VPN connection between your on-premises network and Azure is functioning correctly. The on-premises network (10.10.1.0/24) must have a route to the Azure subnet (e.g., 10.0.0.0/24). Check that routes are correctly propagated between the on-premises environment and the Azure VM.

Verify that the Network Security Group (NSG) associated with your Azure VM allows inbound traffic on port 1433 (or your custom SQL Server port) from your on-premises network (10.10.1.0/24).

Check that your on-premises firewall is not blocking outbound traffic to the Azure IP (10.0.0.22).

Ensure that DNS records for both the on-premises and Azure nodes, including the listener IPs, are configured correctly. If DNS is managed on-premises, make sure that the on-premises servers can resolve the Azure listener IP (10.0.0.22). If using Azure DNS, verify that DNS resolution is functioning as expected across both networks.

Make sure the listener IPs are properly configured for the hybrid environment. For the listener IPs (on-premises: 10.10.1.22 and Azure: 10.0.0.22), the on-premises server should communicate with the on-premises listener IP, while the Azure VM should communicate with the Azure listener IP.

Verify that the listener and failover group configuration align with the hybrid setup, ensuring that both IPs are configured properly for failover scenarios.

I hope this information helps, please do let us know if you have any Queries.
Sai Raghunadh M 1,450 Reputation points Microsoft Vendor

2024-12-02T09:17:23.29+00:00

Hi @ kedar giri,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sai Raghunadh M 1,450 Reputation points Microsoft Vendor

2024-12-03T15:52:32.7433333+00:00

Hi @ kedar giri,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

Listener IP Not Reachable from Primary Server in Hybrid Availability Group Setup

Your answer