Sqlserver安全篇之_启用和禁用Named Pipes的案列介绍

https://learn.microsoft.com/zh-cn/sql/tools/configuration-manager/named-pipes-properties?view=sql-server-ver16
https://learn.microsoft.com/zh-cn/sql/tools/configuration-manager/client-protocols-named-pipes-properties-protocol-tab?view=sql-server-ver16

默认情况下， SQL Server 侦听：\.\pipe\sql\query（对于默认实例）和 \.\pipe\MSSQL$\sql\query（对于命名实例）

Unless changed by the user, when the default instance of Microsoft SQL Server listens on the named pipes protocol, it uses \.\pipe\sql\query as the pipe name. The period indicates that the computer is the local computer, pipe indicates that the connection is a named pipe, and sql\query is the name of the pipe. To connect to the default pipe, the alias must have \<computer_name>\pipe\sql\query as the pipe name. If SQL Server has been configured to listen on a different pipe, the pipe name must use that pipe. For instance, if SQL Server is using \.\pipe\unit\app as the pipe, the alias must use \<computer_name>\pipe\unit\app as the pipe name.

At the time of connection, the SQL Server Native Client component reads the server, protocol, and pipe name values from the registry for the specified alias name, and creates a pipe name in the format np:\<computer_name>\pipe<pipename> or np:\\pipe<pipename>. For a named instance, the default pipe name is \<computer_name>\pipe\MSSQL$<instance_name>\sql\query.

SSMS如何以Named pipe方式连接sqlserver,直接在SSMS的Servername一栏填上np:servername

SELECT session_id, net_transport,auth_scheme,client_net_address,client_tcp_port,local_net_address,local_tcp_port FROM sys.dm_exec_connections
session_id	net_transport	auth_scheme	client_net_address	client_tcp_port	local_net_address	local_tcp_port
54	TCP	KERBEROS	172.22.136.35	55293	172.22.136.187	1433
58	Named pipe	KERBEROS	<named pipe>	NULL	NULL	NULL
63	Session	NTLM	<local machine>	NULL	NULL	NULL
64	Shared memory	NTLM	<local machine>	NULL	NULL	NULL
--net_transport值为TCP的表示是TCP连接，值为Named pipe的表示是Named pipe连接，值为Shared memory的一般是在数据库本地的连接类似mysql的socket连接且auth_scheme一般是NTLM