Home > Microsoft, SQL > Enable Remote Connections on SQL Server 2008 R2

Enable Remote Connections on SQL Server 2008 R2

There are few things that needs to be sorted in order to get this running properly.

  • Enable TCP/IP and Named Pipes protocols. In order to do that open Sql Server Configuration Manager (Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Configuration Manager). Now on the left go SQL Server Network Configuration and select Protocols for YourInstanceName. Enable Named Pipes and TCP/IP.
  • Allow Remote Connections. Open Management Studio, right click on SQL server and select properties. Under Properties select connections and make sure that under Remote Server Connections Allow Remote Server Connections has been ticked. If its not then tick it (enable it) and click ok.
  • Create Firewall rules. Go to Control Panel > Administrative Tools and open Windows Firewall with Advanced Security.
    SQL Server rule. Select Inbound Rules, right-click and select “New Rule”. Select Program and click Next, enter the path to the SQL server program (C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\sqlserver.exe), click Next three times, then enter the name of the firewall rule (e.g. SQL Server), then click finish.
    SQL Server Browser rule. Select Inbound Rules, right-click and select “New Rule”. Select Program and click Next, enter the path to the SQL server program (C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe), click Next three times, then enter the name of the firewall rule (e.g. SQL Server Browser), then click finish.

Once all this is done, you should have Remote Connections enabled for SQL Server 2008 R2.

-Eric

Advertisements
Categories: Microsoft, SQL Tags:
  1. May 17, 2013 at 3:12 am

    Hey just wanted to give you a brief heads up and let you know a few of the images aren’t loading properly. I’m not sure why but I
    think its a linking issue. I’ve tried it in two different web browsers and both show the same results.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: