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.
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
SQL server 2008 R2 Remote conenction
in SQL Server
Posted
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