sql server server name connected by ip setting. SQLServerManager14.msc

最新推荐文章于 2025-06-11 09:03:18 发布

原创最新推荐文章于 2025-06-11 09:03:18 发布 · 462 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

sql 专栏收录该内容

2 篇文章

订阅专栏

本文介绍了如何通过SQL Server Configuration Manager检查并配置SQL Server不同版本的TCP/IP设置，包括从SQLServer2012到SQLServer2017的具体路径及步骤。

win+R,

SQL Server 2017	C:\Windows\SysWOW64\SQLServerManager14.msc
SQL Server 2016	C:\Windows\SysWOW64\SQLServerManager13.msc
SQL Server 2014 (12.x)	C:\Windows\SysWOW64\SQLServerManager12.msc
SQL Server 2012 (11.x)	C:\Windows\SysWOW64\SQLServerManager11.msc

Did you check TCP/IP settings in SQL Server Configuration Manager?

Please follow these steps to check it;

Case #1:

1) SQL Server Configuration Manager --> SQL Server Network Configuration --> Protocols for INSTANCENAME

2) TCP/IP. If it is not Enable, right click to enter Properties to Enable it.

3) Look at IP Addresses tab for your IP Address. If you have more than one IP Address check their TCP Port numbers and be sure your INSTANCE IP address Active.

https://jingyan.baidu.com/article/93f9803f217eafe0e46f55af.html