Second instence of SQL Server 2000

  • 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

  • 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.

  • 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