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.


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

netstat -noab | find /i "1433"

  TCP               LISTENING       3884
  TCP         ESTABLISHED     3884
  TCP          TIME_WAIT         0
  TCP          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


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

Browse other questions tagged or ask your own question.