Yes TCP/IP is enabled verified it using SQL Server configuration manager.
Error -
Cannot connect to SQLInstance.
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
Hello,
My SQL cluster is a multi subnet failover cluster...failover is working fine but the i am not able to ping the SQL cluster with the name of the instance. It's a 2 node cluster and i can ping within the node when it's active but can't ping from another node or from outside.
I have checked/rechecked all the settings related to DNS, Network and everything seems to be fine at this stage.
But because i can't ping the cluster i can not access it using my connection string.
What should be the next set of troubleshooting i can do?
Thanks for the reply.
its a lab environment created for testing in Azure VM....where the network is mostly internal with a Jump box on public network.
The cluster validation report does shows a warning for the ip configuration but other than that the failover and SQL service hosting is working fine.
So, does a cluster does not work in the case when nodes are on different subnets ?
Please, suggest.
Trying to do this using powershell script.