Allow remote connections to named instance

Aim: To allow remote connections to a SQL Server named instance. These steps are useful as a basic troubleshooting guide when you are experiencing problems connecting to a named instance from another computer.

  1. Open SQL Server Services in SQL Server Configuration Manager & start the Browser if it is stopped.
    01_browser_start
    If the Browser is disabled, enable it via the Service tab in Properties by setting the Start Mode to Automatic or Manual.
    02_browser_start_mode
  2. In the Network Configuration section of SQL Server Configuration Manager, open Protocols for MyNamedInstance & enable TCP/IP. Note that the service must be stopped & restarted before the changes will take effect.
    03_enable_tcpip
    04_warning
    In the TCP/IP properties, set the TCP port for IPAll to a suitable value & set the TCP Dynamic Port to blank (disabled). Again, you will receive a warning that the service must be stopped & restarted before the changes will take effect.
    05_tcp_port
    In SQL Server Services, restart MyNamedInstance.
  3. Open Windows Firewall With Advanced Security & create a new inbound rule for the TCP port set in step 2. Create a second inbound rule for UDP port 1434, which is the port that the SQL Server Browser listens on.
    06_firewall
  4. As an aside, if you are having difficulty connecting to the default instance, it’s worth checking that there is an inbound firewall rule for the default instance’s TCP port (usually 1433, unless it has been changed).
Advertisements

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

Kevin Kline

Career and Technical Advice for the IT Professional

TroubleshootingSQL

Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Powershellshocked

A blog about PowerShell and general Windows sysadmin stuff

Simon Learning SQL Server

I'm trying to become "better" at SQL Server and data - here's how I'm doing it!

%d bloggers like this: