Skip to content

SQL server 2008 R2 Remote conenction

Featured Replies

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

  • 8 months later...

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

  • 2 months later...

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.