Gregor Posted March 22, 2011 Report post Posted March 22, 2011 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 Quote Share this post Link to post Share on other sites More sharing options...
Brendant Posted December 13, 2011 Report post Posted December 13, 2011 Can you confirm that both TCP/IP & Named Pipes are enabled under the instances Network Protocols? Quote Share this post Link to post Share on other sites More sharing options...
aaronfenwick Posted February 23, 2012 Report post Posted February 23, 2012 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 Quote Share this post Link to post Share on other sites More sharing options...
