SQL server 2008 R2 Remote conenction

[Gregor]

Hi,

I have a problem connecting to my MS SQL 2008 R2 express from remote machines but it works in the same subnet for example I have SQL server in

192.168.2.15 and I try to connect from 192.168.2.123 I connect normally but if I try to connect from outside IP:port\SQLEXPRESS it fails I checked with http://www.ping.eu/port-chk/ if port is open and it is I also configured TCP/IP in Sql Server Config Manager to that port.

I also tried this tutorial:

http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/

 

Any suggestions

[Brendant]

Can you confirm that both TCP/IP & Named Pipes are enabled under the instances Network Protocols?

[aaronfenwick]

One thing this link doesn't discuss is the windows 2008 R2 firewall.

 

Open ports:

1433, TCP. (Database Engine)

1434 UDP (Browser Service)

 

This should solve your connection issue, like brendant says, if your TCPIP and Names pipes are enabled in configuration manager, under network protocols.

 

Aaron