Named pipes enables clients applications to request a reliable and two way connection between the client application and Sql Server, across a network. A named pipe has a name which follows the UNC naming convention : \\Server\pipe\name
The default names pipe for SQL server is :
\\Server\pipe\sql\query
A named instance would have a named pipe of
\\server\pipe\MSSQL$instancename\sql\query
Early versions of SQL Server only provided Named Pipes.
Named Pipes also allows for impersonation of a clients credentials. The feature is used by SQL server when using Linked Servers. The clients logon credentials are passed across to the Linked Server for authentication.
Named Pipes can operate over TCP/IP, NETBEUI or IPX as it indirectly relies on the Common Internet Files Sytems
The default names pipe for SQL server is :
\\Server\pipe\sql\query
A named instance would have a named pipe of
\\server\pipe\MSSQL$instancename\sql\query
Early versions of SQL Server only provided Named Pipes.
Named Pipes also allows for impersonation of a clients credentials. The feature is used by SQL server when using Linked Servers. The clients logon credentials are passed across to the Linked Server for authentication.
Named Pipes can operate over TCP/IP, NETBEUI or IPX as it indirectly relies on the Common Internet Files Sytems
Comments
Post a Comment