I have a network with two Windows Server boxes. One is a 64bit machine and the other is a 32bit machine. I can ping the 32bit machine while on the 64bit machine and vice versa. My problem is if I'm on the 32bit machine I can't connect to SQL Server 2005 installed on the 64bit machine and vice versa. I have SQL Server 2005 64bit installed on the 64bit machine.
I have SQL Server Browser running on both machines and Windows Firewall turned off. Both are allowing remote connections. I disabled Named Pipes connection on both machines so only TCP/IP is enabled. I tried using SQL Server Authentication to connect to SQL Server but that didn't work either. This is the error 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) (Microsoft SQL Server, Error: 121)
I don't know what other troubleshooting should I perform in order to get these two SQL Server Installs to talk to each other. Any help is greatly appreciated.