Solved

sql server 2012 -Named Pipes Protocol

Posted on 2013-11-12
3
476 Views
Last Modified: 2013-11-27
Hi experts,

i am reading about Named Pipes Protocol but it is not clear
it is?
it for?
when to use it?
0
Comment
Question by:enrique_aeo
3 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 200 total points
ID: 39643535
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
 
LVL 10

Expert Comment

by:PadawanDBA
ID: 39643699
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
 
LVL 3

Expert Comment

by:Sagir87
ID: 39644468
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used.

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question