Cannot connect remotely to a new named instance

Posted on 2009-02-20
Last Modified: 2012-05-06
I just created a new named instance on SQL Server 2005.  The default instance is unnamed and I can connect to that just fine.

In Management Studio Connect to Server/Browse For Servers, if I click on the Network Servers portion, I can see the default instance, but not the named instance.

I can connect to the named instance on the server itself through Management Studio using Shared Memory, but if I try and connect with TCP/IP or Named Pipes, I can't.  

Any ideas?
Question by:ScottieSLG
    LVL 6

    Assisted Solution

    connect to "ServerName\InstanceName"

    make sure you put the \ between the two.
    LVL 1

    Assisted Solution


    Can you confirm that the required connection methods have been enabled in SQL Configuration Manager? I have attached a file with an example configuration.

    LVL 1

    Assisted Solution

    Go to "SQL Server Configuration Manager" > 'SQL Native Client Configuration" > "Client Protocols".
    Enable the "TCP/IP" and "Named Pipes".

    After this go to "SQL Server 2005 Surface Area Configuration" > "Surface Area Configuration for Services and Connections". Expand the "Database Engine" in your named instance and go to "Remote Connections". Check the "Local and remote connections" and "Using both TCP/IP and named pipes".

    In the Management Studio try to connect using ServerName\InstanceName

    Accepted Solution

    I'm not sure if this is what fixed it or not, but I started the "SQL Server Browser" service and was able to connect.

    Thank you all for your suggestions.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now