在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。

Bertha 。 2021-09-18 19:14 224阅读 0赞

1.打开sqlserver 管理配置器

![1205905-20171123101644680-1757994426.png][]

2.点击sqlExpress的协议，我们要启动所有状态。

![1205905-20171123101942477-1886085173.png][]

3.选择[TCP/IP][TCP_IP]，点击右键，选择属性，我们修改连接数据库的[端口地址][Link 1]，非常重要

![1205905-20171123102338399-1877054080.png][]

4.修改三处，第一你查看下跳出来的对话框，里面有好多[TCP/IP][TCP_IP]的端口。我们要找的是三处。

![1205905-20171123102546680-434316193.png][]

5.[IP地址][IP] 是自己电脑的地址 在[TCP端口][TCP]添加1433，然后选择启动

![1205905-20171123102520274-290557088.png][]

6. [IP地址][IP]是127.0.0.1的是默认的，也要改掉，如下

![1205905-20171123102446571-455328934.png][]

7.IPALL是否是表示所有端口？？反正也要修改下[端口地址][Link 1]了。

![1205905-20171123102401586-721543374.png][]

8.重新启动服务，不支持热修改，修改重新启动服务。

![1205905-20171123102324040-320225689.png][]

标签: [转载：https://zhidao.baidu.com/question/3940263265422][https_zhidao.baidu.com_question_3940263265422]

[1205905-20171123101644680-1757994426.png]: /images/20210720/1cdd5c59c46e42be947d1b45b72e57a0.png
[1205905-20171123101942477-1886085173.png]: /images/20210720/d6634ffc4bfe4fa8aa6403f1f77ae1a7.png
[TCP_IP]: http://www.baidu.com/s?wd=TCP%2FIP&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YdrHRznW0vrjwhmWn1uhD30ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3En1bYnjcvn1cvPHfznWD4nW6d
[Link 1]: http://www.baidu.com/s?wd=%E7%AB%AF%E5%8F%A3%E5%9C%B0%E5%9D%80&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YdrHRznW0vrjwhmWn1uhD30ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3En1bYnjcvn1cvPHfznWD4nW6d
[1205905-20171123102338399-1877054080.png]: /images/20210720/447f28d6684544e8b421b3a976e7bcc7.png
[1205905-20171123102546680-434316193.png]: /images/20210720/a0662153d5e547818b8006876a716985.png
[IP]: http://www.baidu.com/s?wd=IP%E5%9C%B0%E5%9D%80&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YdrHRznW0vrjwhmWn1uhD30ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3En1bYnjcvn1cvPHfznWD4nW6d
[TCP]: http://www.baidu.com/s?wd=TCP%E7%AB%AF%E5%8F%A3&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YdrHRznW0vrjwhmWn1uhD30ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3En1bYnjcvn1cvPHfznWD4nW6d
[1205905-20171123102520274-290557088.png]: /images/20210720/cfa7baf43e4445ab837f6930de44b448.png
[1205905-20171123102446571-455328934.png]: /images/20210720/0921ba02dc0c46eaa516e92970dc4676.png
[1205905-20171123102401586-721543374.png]: /images/20210720/adca7a8533a34300b0f8e3e20b388a05.png
[1205905-20171123102324040-320225689.png]: /images/20210720/e8420c43cae24baaae2e62769b3c2621.png
[https_zhidao.baidu.com_question_3940263265422]: https://www.cnblogs.com/dzhf/tag/%E8%BD%AC%E8%BD%BD%EF%BC%9Ahttps%3A%2F%2Fzhidao.baidu.com%2Fquestion%2F3940263265422/