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

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.

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.

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.

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.