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

本是古典何须时尚 2022-10-29 07:33 119阅读 0赞

1.打开sqlserver 管理配置器

![a1e80fbaa54d0565da3103f696562b6c.png][]

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

![7ef72296a87b6bc95d37e1a4b96d56c2.png][]

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

![e276d4267b0efa2a68764d04233c12d5.png][]

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

![29b7e2e615297eca1f8048674d96ec5c.png][]

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

![f100f8f911a3d24f6862ec6c9029eac6.png][]

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

![30f1a7ca044b87e8a076123a5f8751b7.png][]

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

![9640266c65449582da70af55b10679d7.png][]

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

![e5a6a5a6d8676dc2fd7afee7c989bbb3.png][]

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

[a1e80fbaa54d0565da3103f696562b6c.png]: /images/20221024/7902bdbf46724a379361c9e4b04f7d46.png
[7ef72296a87b6bc95d37e1a4b96d56c2.png]: /images/20221024/bc11a333b14b45d5a882eaff0e1f78cc.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
[e276d4267b0efa2a68764d04233c12d5.png]: /images/20221024/ab100b644410490db99039049d292d1c.png
[29b7e2e615297eca1f8048674d96ec5c.png]: /images/20221024/909de1a8560242a08e45efeda0cb8115.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
[f100f8f911a3d24f6862ec6c9029eac6.png]: /images/20221024/7c5b0a8964074354ae7bee1a8b9f6720.png
[30f1a7ca044b87e8a076123a5f8751b7.png]: /images/20221024/ebd78799188a49a8a6ae6de967458fd5.png
[9640266c65449582da70af55b10679d7.png]: /images/20221024/d230360ded00470fac33293b14a57553.png
[e5a6a5a6d8676dc2fd7afee7c989bbb3.png]: /images/20221024/d5d684e62a60458aad32704ef2b994ae.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/