locked
Named Pipes Protocol RRS feed

  • Question

  • Hi,

    Our SQL Server 2008 default instance have databases for multiple applications. Shared Memory and TCP/IP enbaled. Named Pipes and VIA disabled.

    One of our vendor needs to enbale Named Pipe to resolve some issues for his application that have databases on this sql server instance.

    Is there any issue to enbale both tcp/ip and named pipes? Or what precaution should be taken?

    Thanks

    Monday, December 31, 2012 3:58 PM

Answers

  • Hello there will be no impact it totally depends on your business/application need thats it.. usually most of the recommended is TCP/IP  but even this is also not an mandatory as well-

    Why Use Named Pipes?
    http://www.sqlservercentral.com/blogs/brian_kelley/2009/08/10/why-use-named-pipes/    

    Default SQL Server Network Configuration
    http://msdn.microsoft.com/en-us/library/ms190198%28v=sql.100%29.aspx

    Choosing a Network Protocol
    http://msdn.microsoft.com/en-us/library/ms187892%28v=sql.100%29.aspx

    TCP/IP

    TCP/IP is a common protocol widely used over the Internet. It communicates across interconnected networks of computers that have diverse hardware architectures and various operating systems. TCP/IP includes standards for routing network traffic and offers advanced security features. It is the most popular protocol that is used in business today. Configuring your computer to use TCP/IP can be complex, but most networked computers are already correctly configured. To configure the TCP/IP settings that are not exposed in SQL Server Configuration Manager, see the Microsoft Windows documentation.
    Named Pipes

    Named Pipes is a protocol developed for local area networks. A part of memory is used by one process to pass information to another process, so that the output of one is the input of the other. The second process can be local (on the same computer as the first) or remote (on a networked computer).


    How to: Enable or Disable a Server Network Protocol (SQL Server Configuration Manager)
    http://msdn.microsoft.com/en-us/library/ms191294%28v=sql.100%29.aspx


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Tuesday, January 1, 2013 4:19 AM

All replies

  • Hi,

              Try this link

                                               http://social.msdn.microsoft.com/Forums/zh/sqlgetstarted/thread/214b0fcc-206e-4c50-93f4-7474d0a2677c


    Thanks & Regards, sathya

    Monday, December 31, 2012 4:37 PM
  • Hi

    Due to security reason in Microsoft SQL Server 2005, and 2008 ,TCP/IP and Named Pipes network protocols may not be turned on by default .

    You can CLCONFIG and set up the alias here to force the SQL just to use named pipes vs TCP/IP if you want to without going into SQL and unchecking the connections.

    How to enable Transmission Control Protocol/Internet Protocol (TCP/IP) and Named Pipes protocols in Microsoft SQL Server

    http://btsc.webapps.blackberry.com/btsc/viewdocument.do;jsessionid=BD276F0B82029224BB4EFF8D42C5BDFD?externalId=KB05057&sliceId=2&cmd=displayKC&docType=kc&noCount=true&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl 


    Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/


    Monday, December 31, 2012 5:28 PM
  • Hello there will be no impact it totally depends on your business/application need thats it.. usually most of the recommended is TCP/IP  but even this is also not an mandatory as well-

    Why Use Named Pipes?
    http://www.sqlservercentral.com/blogs/brian_kelley/2009/08/10/why-use-named-pipes/    

    Default SQL Server Network Configuration
    http://msdn.microsoft.com/en-us/library/ms190198%28v=sql.100%29.aspx

    Choosing a Network Protocol
    http://msdn.microsoft.com/en-us/library/ms187892%28v=sql.100%29.aspx

    TCP/IP

    TCP/IP is a common protocol widely used over the Internet. It communicates across interconnected networks of computers that have diverse hardware architectures and various operating systems. TCP/IP includes standards for routing network traffic and offers advanced security features. It is the most popular protocol that is used in business today. Configuring your computer to use TCP/IP can be complex, but most networked computers are already correctly configured. To configure the TCP/IP settings that are not exposed in SQL Server Configuration Manager, see the Microsoft Windows documentation.
    Named Pipes

    Named Pipes is a protocol developed for local area networks. A part of memory is used by one process to pass information to another process, so that the output of one is the input of the other. The second process can be local (on the same computer as the first) or remote (on a networked computer).


    How to: Enable or Disable a Server Network Protocol (SQL Server Configuration Manager)
    http://msdn.microsoft.com/en-us/library/ms191294%28v=sql.100%29.aspx


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Tuesday, January 1, 2013 4:19 AM
  • From Choosing a Network Protocol

    "For named pipes, network communications are typically more interactive. A peer does not send data until another peer asks for it using a read command. A network read typically involves a series of peek named pipes messages before it starts to read the data. These can be very costly in a slow network and cause excessive network traffic, which in turn affects other network clients."


    Please use Marked as Answer if my post solved your problem and use Vote As Helpful, if a post was useful to help other user's find a solution quicker.

    Tuesday, January 1, 2013 1:46 PM