Protocol used by SQL Server: Named Pipe (Named Pipe)

Recently I have followed some network protocols used by SQL Server, such as named pipe:

Named Pipe (Named Pipe) is a protocol used for LAN. Under this protocol, a part of the computer's memory is used by a process to transmit information to another process. The latter can be a local process or remote process.

In what scenarios will named pipe be considered?

If the server and client are both in the LAN, you can consider using it. The speed of named pipe in the LAN is faster than that of TCP/IP. If you disable TCP/IP, you can use named pipe to improve network security.

Using Named Pipe:

InProgramThe SQL Server connection string in can be roughly like this:

"Server =. \ yourinstancename; database = yourdatabasename; uid = sa; Pwd = pass @ word;Network library = dbnmpntw"

Make sure that the named pipe protocol and the SQL Server Browser Service are enabled on the SQL Server server. The latter is used to listen for external requests to SQL Server resources and provide information about SQL Server instances installed on the computer.