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 trying to connect to a Microsoft SQL Server 2008 Express edition over the internet. Connecting to the server over LAN works just fine. I have opened port 1433 on the firewall and set the appropriate firewall-rules on the Windows-7 machine.

A portscan also tells me that "xxx.xxx.xxx.xxx is responding on port 1433 (ms-sql-s)."

Services (Server and Browser) are running and "Allow remote connections to this server" in the server settings is also enabled.

But a connection just doesn't want to work:

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.

Update

More information about the network:

We have a Windows 7 machine functioning as our SQL-Server and this server is directly connected to a Netgear ProSafe Firewall which then connects our server to the internet.

Both ports 1433 and 1434 are opened and forwarded to 10.9.0.1.

netstat -noab | find /i "1433"

  TCP    0.0.0.0:1433           0.0.0.0:0              LISTENING       3884
  TCP    10.9.0.1:1433          10.9.0.1:51048         ESTABLISHED     3884
  TCP    10.9.0.1:51047         10.9.0.1:1433          TIME_WAIT         0
  TCP    10.9.0.1:51048         10.9.0.1:1433          ESTABLISHED     2296
  TCP    [::]:1433              [::]:0                 LISTENING       3884
share|improve this question
    
Can you show us your connection details? Can you be more specific about the topology than just "connecting over the Internet"? It might be helpful to show the output from netstat -noab | find /i "1433" on the server too. –  Somantra Jul 19 '12 at 14:46
    
Additionally, port 1434 needs to be forwarded for SQL Browser –  MichelZ Jul 19 '12 at 15:13
    
I've updated the question and copied the output of netstat .... Also I forgot to mention that not only port 1433 is opened but also 1434. –  libjup Jul 20 '12 at 6:08

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.