Hello,
I am unable to ping or connect to my SQL cluster. My cluster is a multi site failover cluster.
Below is my configuration -
Environment is setup in Azure
I have 2 Windows Server 2019 acting as Cluster nodes.
IP Address - Node 1 - 10.1.100.10, Node 2 - 10.2.100.10.
Installed failover cluster role, added the storage and created the cluster.
ICMP allowed through NSG, TCP Port 1433 port also allowed.
Cluster is running fine, all my other machine can ping these nodes and vice versa.
Installed SQL Server 2019 failover cluster instance on both the nodes.
Name of SQL Instance - SQLCluster
IP Address of SQL Instance - Node 1 - 10.1.100.20, Node 2 - 10.2.100.20 (Multi side failover configuration)
Failover working fine, tested on both the nodes.
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
