question

HPATEL2805 avatar image
0 Votes"
HPATEL2805 asked Cathyji-msft commented

Cannot ping SQl listener outside primary sql server

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

sql-server-generalazure-load-balancer
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @HPATEL2805,

Any update for this thread? Did the reply could help you? If the response helped, do "Accept Answer". If it is not work, please let us know the progress.

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @HPATEL2805,

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.