Share via

Cannot ping SQl listener outside primary sql server

Patel, Hitesh 1 Reputation point
2021-07-27T21:04:29.67+00:00

HI
i have 2 sql servers in azure setup with a cluster and AG but i cannot ping the listener outside the primary sql server .. i can only ping the listener from the primary sql server this was even before i setup the Azure LB

Azure Load Balancer
Azure Load Balancer

An Azure service that delivers high availability and network performance to applications.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,431 Reputation points Microsoft External Staff
    2021-07-28T09:38:40.973+00:00

    Hi @Patel, Hitesh ,

    The SQL server AG in Azure environment? An availability group requires a load balancer when the SQL Server instances are on Azure Virtual Machines. The load balancer stores the IP address for the availability group listener. If an availability group spans multiple regions, each region needs a load balancer. Refer to MS document Configure a load balancer for a SQL Server Always On availability group in Azure Virtual Machines.

    If your AG in on-premises environment. Did you check whether the firewall block the connection? Try disable the firewall on both nodes. Did your listener using a static IP address and default port of 1433? Is this multi subnet cluster ?

    If I misunderstood your issue, please let me know.

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

    Was this answer helpful?

    0 comments

Your answer

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