I'm a programmer working over a VPN.
I use local databases most of the time, but my local SQL Server 2005 has "Link Server" server object pointing at the production server.
This has been working great (albeit, slow over VPN) until the company had some IT people install a new firewall.
Now, my linked servers on my local database don't work when I try to access data through them (Example: a simple select command)
Named Pipes Provider: Could not open a connection to SQL Server .
I am able to connect to the databases just fine through SSMS or through SQLCMD on the command line.
I'm very confused as to why I am able to connect to the remote server by 2 methods, but not via linked server.