I've just built a virtual SQL Server 2 node cluster using VMWare workstation. The windows cluster has been created, SQL has been installed on both nodes and added to the cluster, all latest updates have been applied, but I'm trying to connect to the Database Engine from my workstation and I just recieve the error:
"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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)"
I've added port 1433 as an inbound firewall rule to both nodes, tried disabling the firewall service entirely, and disabled Named Pipes on the MSSQLSERVER protocols for SQL Server Network Configuration, on both nodes. Additinally, if I remote into the active cluster node, I can't connect locally either using SQL Server Management Studio.
Not sure if my issues are cluster related or SQL server related. Am I missing a step here?