Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Red face Unanswered: Connecting to SQL Server for Named Instances at client end

    Hi all,

    I have installed a named instance in my sql server. Am able to connect to the named instance at the server end. However, when i tried to register this named instance at my client end using sql enterprise manager, i have this error : Specified SQL Server not found. ConnectionOpen (Connect())

    Let's say my servername is Intranet and the named instance is UAT.
    Thus, i just have to supply the name to be --> Intranet\UAT . Am i correct? Please advise... have been figuring the whole morning still do not know what's wrong with it.

  2. #2
    Join Date
    Aug 2002
    You must add an alias that points to
    \\computername\pipe\MSSQL$instancename. If you use an alias name
    of computername\instancename, clients can connect by specifying this name in the same way as SQL Server 2000 clients do.

    For the TCP/IP Sockets andNWLink IPX/SPX Net-Libraries, you must use the Client Network Utility to define an alias on the client that specifies the port address on which the named instance is listening.

    Refer to this
    MSDN article for more information.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts