SQL Server 2000 Multiple Instance

  • Hi All,

    Recently, I installed the second SQL Server instance on the server.

    I changed the named pipe settings as following:

    From \\.\pipe\MSSQL$Instance_Name\sql\query

    To \\Machine_Name\pipe\MSSQL$Instance_Name\sql\query

    Right now, I cannot connect to that instance from either enterprise manager or query analyzer.

    When I try to connect, both Enterprise Manager and Query Analyzer crushes.

    Anyone knows how to set named pipes to the original settings from out side of the instance, please help me.

    Thank you very much

  • I fixed the problem as following:

    Start>All Programs>Microsoft SQL Server>Server Network Utility

    Named pipes>Properties>

    Changed path into previous settings.

    My problem is I can see the instance on the server locally but I cannot

    see it from the network clients.

    Does anyone know how to set the multiple

    instances for clients?

    Thank you very much

  • From the client machine run prompt type cliconfg.exe and then follow what you did for the server config.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • I definitely agree!!

  • I set the same configurations on the client side (cliconfg.exe)

    For the new instance (Test Instance), client can connect to the server via Named pipes.

    I could not get the connection working via TCP/IP.

    "The Default Instance" is using TCP/IP dynamic port.

    Can you explain me why "The Test Instance" only can connect via Named Pipes?

    Should I be able connect via TCP/IP as well?

    Thanks in advance

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply