Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 [2]. 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?

share|improve this question
    
Have you tried accessing 1433 port of the SQL from any remote machine on the same LAN? –  Vick Vega Feb 16 '11 at 21:11
    
I don't have access to any other machines on the same LAN unfortunately. –  Jason Feb 16 '11 at 21:14
    
Ever crack this nut? –  justSteve Aug 18 '11 at 19:40
    
Not directly. I had this problem when trying to configure a shared database for two ASP.NET applications. In the end I exposed web services to provide the access I needed. –  Jason Aug 20 '11 at 8:07
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.