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.
    If the Browser is disabled, enable it via the Service tab in Properties by setting the Start Mode to Automatic or Manual.
  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.
    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.
    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.
  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).

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

Kevin Kline

Career and Technical Advice for the IT Professional


Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert


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: