Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 540
  • Last Modified:

sql server 2012 -Named Pipes Protocol

Hi experts,

i am reading about Named Pipes Protocol but it is not clear
it is?
it for?
when to use it?
0
enrique_aeo
Asked:
enrique_aeo
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
Here's the Microsoft page on the subject: http://msdn.microsoft.com/en-us/library/windows/desktop/aa365590%28v=vs.85%29.aspx  In simple terms, it's just another method of communicating.  It would be used, for example, between an SQL client and an SQL server.  I have never used it and I don't know where it would be commonly used.
0
 
PadawanDBACommented:
The available methods for establishing connectivity with a SQL Server instance via the SNI (SQL Server Network Interface) are: Shared memory (this is the default method for connections originating on the same host as the SQL Server instance), TCP/IP (this is the most commonly used access method for SQL Server, access via IP address/port), Named pipes, and VIA (will be removed from future release of SQL Server).

Named pipes is a protocol that is comparable to TCP/IP.  Named Pipes was developed for LANs, but can be inefficient over WANs.  If you desire to use it, you will need to enable it in the SQL Server Configuration Manager and then create a SQL Server Alias that connects to the server using Named Pipes as the protocol.  Named Pipes utilize TCP Port 445.

Regardless of what protocol used to establish your connection, the SNI will create a secure connection to a TDS (tabular data stream) endpoint, to which you will send requests and from which you will receive data.  The protocol merely determines how you establish your connection with the TDS endpoint (there is one per protocol + 1 for the DAC)
0
 
Sagir87Commented:
Hi,

Please refer these link for information:

http://technet.microsoft.com/en-us/library/aa178138(v=sql.80).aspx

Also refer for more information about named pipe protocol:

1. Configure a Server to Listen on an Alternate Pipe (SQL Server Configuration Manager):

http://technet.microsoft.com/en-us/library/ms189321.aspx

2. Creating a Valid Connection String Using Named Pipes

http://technet.microsoft.com/en-us/library/ms189307(v=sql.105).aspx
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now