I'm using VS2008 on my local machine for writing an ASP.Net app. Our SQL Server 2008 instance is hosted remotely on a dedicated database server. I can connect to the server through my app on both my local machine and production server, but not on our development server.
I have opened port 1433 on the dev server but that didn't work. The connection string is the same on both servers. Both production and dev servers are using windows server 2008. The error i get it
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)
EDIT: I think I should make it clear that the SQL Server is run by a hosting company which we pay for so I don't have access to any configuration of this server. Also, as far as I am aware, the server is working fine since I can connect to it from 2/3 different places through my application.
EDIT 2: So it turns out that one of the routers in our office was blocking traffic through port 1433. Thanks Bryan for your persistent help.