I recently built a SQL Server 2005 cluster on the o/s Windows Server 2008 R2. I have been attempting to connect to the cluster from my Windows 7 dekstop with my SQL Server 2008 Tool set. I have been unable to attach to this cluster since its
creation. The firewall is temp off, remote connections in the surface area configuration is set to pipes and tcp/ip and the Browser surface is up and running.
I ran Wireshark against the cluster and I could see that there was UDP conversations for ms-sql-m (SQL Port) but that was as far as it would get. I am using a named instance so not using 1433, but I do see the cluster offering up high RPC ports but
the client never responds after the initial UDP response.
When I noticed that there was a two way conversation taking place, I went to a seperate machine and fired up SQL Server 2005 Tools and I was easily able to attach to the cluster. So my question is -
Are there any known incompatibilities between SQL Server 2005 cluster services and SQL Server 2008 Tool set? I can use my 2008 tools to attach to a non-clustered SQL Server 2005 w/o issue.
Error when attempting to connect:
A network-related or instance-specific error occured while establishing a connection to sql server. The server was not found or was not accessible. Verify that the instance name is correct and the SQL Server is con
View Complete Post