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

最新推荐文章于 2021-01-21 11:22:50 发布

GIS20070001

最新推荐文章于 2021-01-21 11:22:50 发布

阅读量401

点赞数 1

分类专栏： sql

本文链接：https://blog.csdn.net/GIS20070001/article/details/80835689

版权

sql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

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