I'm currently trying to configure an installation of SQL Server Express 2008 R2 to allow remote connections but can't seem to get it to work remotely. To connect to the server I have to connect via a VPN.
Every time I run the command "sqlcmd -e -s server_ip\SQLEXPRESS" while connected to the machine it works correctly however when I try it from my local machine I get the following error:
HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server . Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred whil the fact that under the default settings SQL Server does not allow remo Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
UPDATE: When I connect to the VPN on my local machine and run this command I still get the error above
I get a similar error when I try to connect via an ASP.NET application that doesn't reside on the server.
Am I missing something in my configuration or is the VPN what is causing the problem?