Post reply

Named Pipes Protocol

  • November 2, 2005 at 11:12 am

    #95630

    Hi friends,

    Is it mandatory to install Named pipes protocol ? What exactly the use of this? how it differs from TCP/IP(for sql and its clients)

     

    thanks in advance.

  • November 2, 2005 at 2:56 pm

    #601997

    Hi,

    I assume you are asking about adding Named Pipes to the list of the protocols available for SQL Server when installing SQL Server or using Server Network Utility and not asking for installing Named Pipes on Windows server (in this case ask your server support)

    These are 2 different protocols. You may install none. For example MSDE out-of-the-box installs none, everything is running on shared memory SQL Server is accessible only from a local machine. This is recommended for locked-down environments when only an app on the local machine is supposed to access SQL Server.

    You may allow only TCP/IP (not adding Named Pipes) . In this case you have to use Client Network Utility on each client to configure a new alias to your SQL Server to use TCP/IP protocol and all application connection strings should be configured specifying network protocol TCP/IP in case the default protocol on the client is Named Pipes. You configure the default protocol in the Client Network utility too. Do TCP/IP

    Yelena

    Regards,Yelena Varsha

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

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