我安装了sql server 2012,需要将网络传输类型从命名管道更新为tcp协议。我在SQLServer配置管理器中执行此操作,然后重新启动服务。然而,在跑步时
select connectionproperty('net_transport') as net_transport,
connectionproperty('protocol_type') as pt,
connectionproperty('auth_scheme') as sh,
connectionproperty('local_net_address') as lna,
connectionproperty('local_tcp_port') as tcport,
connectionproperty('client_net_address') as cna
from sys.dm_exec_connections
它给我的网络传输类型命名为管道。
1条答案
按热度按时间pbgvytdp1#
您可以只启用tcp/ip并禁用“命名管道”,这将更改为tcp/ip