Not able to ping SQL Cluster

NM 36 Reputation points
2021-04-19T13:56:06.5+00:00

Hello,

I am unable to ping or connect to my SQL cluster. My cluster is a multi site failover cluster.

Below is my configuration -

  1. Environment is setup in Azure
  2. I have 2 Windows Server 2019 acting as Cluster nodes.
  3. IP Address - Node 1 - 10.1.100.10, Node 2 - 10.2.100.10.
  4. Installed failover cluster role, added the storage and created the cluster.
  5. ICMP allowed through NSG, TCP Port 1433 port also allowed.
  6. Cluster is running fine, all my other machine can ping these nodes and vice versa.
  7. Installed SQL Server 2019 failover cluster instance on both the nodes.
  8. Name of SQL Instance - SQLCluster
  9. IP Address of SQL Instance - Node 1 - 10.1.100.20, Node 2 - 10.2.100.20 (Multi side failover configuration)
  10. Failover working fine, tested on both the nodes.
  11. I can access the instance via SQL server management studio installed on both the nodes.

Problems -

  1. I cant ping the SQL instance (SQLCLUSTER)
  2. NSLookup shows both the ip address - 10.1.100.20, 10.2.100.20
  3. If Node1 is the active node then ping to this only work from within the node and not from other node.
  4. Ping is not working from any other server.

I have checked all the network and DNS configuration all working fine and setup correctly. Also, i have tried to connect from outside the nodes using the option MultiSubnetFailove=True but it also did not worked since there is no reply to ping.

This is the second time i tried this. Earlier i created the cluster but the IP address was bit conflicting so, have rebuilt it but getting the same results again.

Experts please suggest.

Thanks,
NM

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,564 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
732 questions
1 vote

3 answers

Sort by: Most helpful
  1. Tom Phillips 17,511 Reputation points
    2021-04-19T14:45:35.337+00:00

    In a failover cluster, there are multiple IP addresses. You do not connect via the IP addresses.

    You connect to the cluster using the "network name". This is a shared resource and points to the active node. Only 1 node at a time is "active". So you cannot connect to the 2nd SQL Server until it becomes "active".


  2. Oury Ba-MSFT 9,566 Reputation points Microsoft Employee
    2021-04-20T17:16:12.973+00:00

    @NM Thank you for posting your question.

    Make sure that TCP/IP is enabled as a client protocol on the application server. For more information, see Configure client protocols. On application servers where you don't have SQL tools installed, verify that TCP/IP is enabled by running cliconfg.exe (SQL Server Client Network utility).

    Check the application's connection string to make sure it's configured correctly. For example, make sure that the connection string specifies the correct port (1433) and fully qualified server name. See Get connection information.

    Try increasing the connection timeout value. We recommend using a connection timeout of at least 30 seconds.

    Test the connectivity between the application server and the Azure SQL Database by using SQL Server management Studio (SSMS), a UDL file, ping, or telnet. For more information, see Troubleshooting connectivity issues and Diagnostics for connectivity issues. Please let us know if that solve your problem. Thanks


  3. Shree Niraula 6 Reputation points
    2022-06-03T18:47:26.297+00:00

    @NM I am facing the same issue, can you help me to fix this?