Post reply

Second instence of SQL Server 2000

  • December 23, 2004 at 1:24 am

    #85034

    Hi,

    I am having a second instence of SQL server installed on SQL Server 2000 and it is using Named Pipes. 

    How can I force it to use the TCP/IP network protocol?

     

     

    Best regards,

     

    Atiq

  • December 23, 2004 at 4:13 am

    #534876

    Yes, you can disable the Named pipe protocol at the installation stage.

    When installing, choose the custom option. In one of the screens you will have an option to uncheck the named protocol.

    after installtion, you can use the "server network utility" in 

    start >>programs>> sql server folder .

     

    Yoav.

  • December 24, 2004 at 3:33 am

    #534962

    Indeed, you should use the Server Network Utility to enable the TCP/IP protocol (and maybe disable the Named Pipes protocol). It may also be useful to read the following article:

    http://support.microsoft.com/kb/823938

    Razvan

Viewing 3 posts - 1 through 2 (of 2 total)

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