I have a few sql 2008 servers on windows 2008 and except to one of them I am unable to connect to these instances from my local machine(which is sql 2005 sp3 on winXP) . I also tried from my laptop which has sql 2008 installed on it but with no luck. Here is the message I get:
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)
Since there is no trust between the two domains I am using sql logins to connect to the servers in question. And here is what I tried so far: I check 1433 port is open, I turned on sql browser, I checked the firewall is not blocking.
BTW I am not also able to connect to these 2008 instances from 3rd party tools that I use to monitor my servers.
Please let me know if you have any solutions.