mysql连接错误2_sql连接错误（Microsoft SQL Server,错误:2)

秒速五厘米 2022-10-25 05:51 193阅读 0赞

昨天用SQL语句建表的时候写了一段代码，对于代码的逻辑和内容我不太肯定对不对，反正是毫不犹豫的让它执行了，过程中出现好几个错误，当时没有太在意，想着大不了出错了再重写一个，结果……玩坏了，从昨天到现在十几个小时，SQL Server毫无商量的给我罢工了

昨天用SQL语句建表的时候写了一段代码，对于代码的逻辑和内容我不太肯定对不对，反正是毫不犹豫的让它执行了，过程中出现好几个错误，当时没有太在意，想着大不了出错了再重写一个，结果……玩坏了，从昨天到现在十几个小时，SQL Server毫无商量的给我罢工了！于是乎，漫长的“寻错”之路开始了。

先看下出错信息：

![test.jsp?url=http%3A%2F%2Fimg.blog.csdn.net%2F20140620155447453%3Fwatermark%2F2%2Ftext%2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ%3D%3D%2Ffont%2F5a6L5L2T%2Ffontsize%2F400%2Ffill%2FI0JBQkFCMA%3D%3D%2Fdissolve%2F70%2Fgravity%2FSouthEast&refer=http%3A%2F%2Fblog.csdn.net%2Fwangjingna%2Farticle%2Fdetails%2F32713695][test.jsp_url_http_3A_2F_2Fimg.blog.csdn.net_2F20140620155447453_3Fwatermark_2F2_2Ftext_2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ_3D_3D_2Ffont_2F5a6L5L2T_2Ffontsize_2F400_2Ffill_2FI0JBQkFCMA_3D_3D_2Fdissolve_2F70_2Fgravity_2FSouthEast_refer_http_3A_2F_2Fblog.csdn.net_2Fwangjingna_2Farticle_2Fdetails_2F32713695]

1.通过以往经验我先打开了SQL Server配置工具——>配置管理器，检查里边的协议是否开启，就在这时我又犯了一个错误。因为不知道那些协议到底是什么意思，索性干脆都启用了，结果可想而知，数据库依旧打不开(不过不影响继续找错……)，在后期找错误的过程中将这里的VIA更正为了禁用

![test.jsp?url=http%3A%2F%2Fimg.blog.csdn.net%2F20140620163523390%3Fwatermark%2F2%2Ftext%2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ%3D%3D%2Ffont%2F5a6L5L2T%2Ffontsize%2F400%2Ffill%2FI0JBQkFCMA%3D%3D%2Fdissolve%2F70%2Fgravity%2FSouthEast&refer=http%3A%2F%2Fblog.csdn.net%2Fwangjingna%2Farticle%2Fdetails%2F32713695][test.jsp_url_http_3A_2F_2Fimg.blog.csdn.net_2F20140620163523390_3Fwatermark_2F2_2Ftext_2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ_3D_3D_2Ffont_2F5a6L5L2T_2Ffontsize_2F400_2Ffill_2FI0JBQkFCMA_3D_3D_2Fdissolve_2F70_2Fgravity_2FSouthEast_refer_http_3A_2F_2Fblog.csdn.net_2Fwangjingna_2Farticle_2Fdetails_2F32713695]

2.然后又查看了TCP/IP属性——>TCP动态端口是否为空、TCP端口是否为1433，检查过后这里基本没有问题

![test.jsp?url=http%3A%2F%2Fimg.blog.csdn.net%2F20140620162220187%3Fwatermark%2F2%2Ftext%2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ%3D%3D%2Ffont%2F5a6L5L2T%2Ffontsize%2F400%2Ffill%2FI0JBQkFCMA%3D%3D%2Fdissolve%2F70%2Fgravity%2FSouthEast&refer=http%3A%2F%2Fblog.csdn.net%2Fwangjingna%2Farticle%2Fdetails%2F32713695][test.jsp_url_http_3A_2F_2Fimg.blog.csdn.net_2F20140620162220187_3Fwatermark_2F2_2Ftext_2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ_3D_3D_2Ffont_2F5a6L5L2T_2Ffontsize_2F400_2Ffill_2FI0JBQkFCMA_3D_3D_2Fdissolve_2F70_2Fgravity_2FSouthEast_refer_http_3A_2F_2Fblog.csdn.net_2Fwangjingna_2Farticle_2Fdetails_2F32713695]

3.上网找了一些相关的解决办法，是通过 计算机——>管理——>服务与应用程序 解决的。在这里关于SQL的服务又不知道是什么意思，索性第二次全部开启(后来上网查询过，这些是可以都开启的)，可是在启动下图中两个服务的时候又出现了问题：无法启动。

出错信息1)是因为在1.中没有禁用VIA所致。

![test.jsp?url=http%3A%2F%2Fimg.blog.csdn.net%2F20140620174119406%3Fwatermark%2F2%2Ftext%2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ%3D%3D%2Ffont%2F5a6L5L2T%2Ffontsize%2F400%2Ffill%2FI0JBQkFCMA%3D%3D%2Fdissolve%2F70%2Fgravity%2FSouthEast&refer=http%3A%2F%2Fblog.csdn.net%2Fwangjingna%2Farticle%2Fdetails%2F32713695][test.jsp_url_http_3A_2F_2Fimg.blog.csdn.net_2F20140620174119406_3Fwatermark_2F2_2Ftext_2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ_3D_3D_2Ffont_2F5a6L5L2T_2Ffontsize_2F400_2Ffill_2FI0JBQkFCMA_3D_3D_2Fdissolve_2F70_2Fgravity_2FSouthEast_refer_http_3A_2F_2Fblog.csdn.net_2Fwangjingna_2Farticle_2Fdetails_2F32713695]

出错信息2)是因为它与1)是依存关系，1)没开启它就开启不了。这个逻辑关系倒是简单，主要它的错误提示信息太高大上了，再加上我也没注意过这个依存关系，直接导致我在无数的错误堆里寻寻觅觅。

![test.jsp?url=http%3A%2F%2Fimg.blog.csdn.net%2F20140620170450765%3Fwatermark%2F2%2Ftext%2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ%3D%3D%2Ffont%2F5a6L5L2T%2Ffontsize%2F400%2Ffill%2FI0JBQkFCMA%3D%3D%2Fdissolve%2F70%2Fgravity%2FSouthEast&refer=http%3A%2F%2Fblog.csdn.net%2Fwangjingna%2Farticle%2Fdetails%2F32713695][test.jsp_url_http_3A_2F_2Fimg.blog.csdn.net_2F20140620170450765_3Fwatermark_2F2_2Ftext_2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ_3D_3D_2Ffont_2F5a6L5L2T_2Ffontsize_2F400_2Ffill_2FI0JBQkFCMA_3D_3D_2Fdissolve_2F70_2Fgravity_2FSouthEast_refer_http_3A_2F_2Fblog.csdn.net_2Fwangjingna_2Farticle_2Fdetails_2F32713695]

至此终于打开了我的SQL Server2008，心情太激动了！在解决这个问题的时候，有同学用dos命令解决过，给我的感觉就是太cool了，可是没解决得了，那些命令也不太清楚是什么意思，所以还是从简单的界面来吧。这些解决方案也许不适合你的问题，但是可以参考下，也欢迎交流更多关于SQL的问题。

PS：在找解决方法的过程中看到很多关于“配置SQL Server身份验证方式”的问题，如果你也遇到了类似的情况，可以看下我在网易的一篇博客

http://m15369659554.blog.163.com/blog/static/211344045201362384136562/

![f68f2add0b68e4f9810432fce46917b7.png][]

本文原创发布php中文网，转载请注明出处，感谢您的尊重！

[test.jsp_url_http_3A_2F_2Fimg.blog.csdn.net_2F20140620155447453_3Fwatermark_2F2_2Ftext_2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ_3D_3D_2Ffont_2F5a6L5L2T_2Ffontsize_2F400_2Ffill_2FI0JBQkFCMA_3D_3D_2Fdissolve_2F70_2Fgravity_2FSouthEast_refer_http_3A_2F_2Fblog.csdn.net_2Fwangjingna_2Farticle_2Fdetails_2F32713695]: https://www.php.cn/inc/test.jsp?url=http%3A%2F%2Fimg.blog.csdn.net%2F20140620155447453%3Fwatermark%2F2%2Ftext%2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ%3D%3D%2Ffont%2F5a6L5L2T%2Ffontsize%2F400%2Ffill%2FI0JBQkFCMA%3D%3D%2Fdissolve%2F70%2Fgravity%2FSouthEast&refer=http%3A%2F%2Fblog.csdn.net%2Fwangjingna%2Farticle%2Fdetails%2F32713695
[test.jsp_url_http_3A_2F_2Fimg.blog.csdn.net_2F20140620163523390_3Fwatermark_2F2_2Ftext_2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ_3D_3D_2Ffont_2F5a6L5L2T_2Ffontsize_2F400_2Ffill_2FI0JBQkFCMA_3D_3D_2Fdissolve_2F70_2Fgravity_2FSouthEast_refer_http_3A_2F_2Fblog.csdn.net_2Fwangjingna_2Farticle_2Fdetails_2F32713695]: https://www.php.cn/inc/test.jsp?url=http%3A%2F%2Fimg.blog.csdn.net%2F20140620163523390%3Fwatermark%2F2%2Ftext%2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ%3D%3D%2Ffont%2F5a6L5L2T%2Ffontsize%2F400%2Ffill%2FI0JBQkFCMA%3D%3D%2Fdissolve%2F70%2Fgravity%2FSouthEast&refer=http%3A%2F%2Fblog.csdn.net%2Fwangjingna%2Farticle%2Fdetails%2F32713695
[test.jsp_url_http_3A_2F_2Fimg.blog.csdn.net_2F20140620162220187_3Fwatermark_2F2_2Ftext_2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ_3D_3D_2Ffont_2F5a6L5L2T_2Ffontsize_2F400_2Ffill_2FI0JBQkFCMA_3D_3D_2Fdissolve_2F70_2Fgravity_2FSouthEast_refer_http_3A_2F_2Fblog.csdn.net_2Fwangjingna_2Farticle_2Fdetails_2F32713695]: https://www.php.cn/inc/test.jsp?url=http%3A%2F%2Fimg.blog.csdn.net%2F20140620162220187%3Fwatermark%2F2%2Ftext%2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ%3D%3D%2Ffont%2F5a6L5L2T%2Ffontsize%2F400%2Ffill%2FI0JBQkFCMA%3D%3D%2Fdissolve%2F70%2Fgravity%2FSouthEast&refer=http%3A%2F%2Fblog.csdn.net%2Fwangjingna%2Farticle%2Fdetails%2F32713695
[test.jsp_url_http_3A_2F_2Fimg.blog.csdn.net_2F20140620174119406_3Fwatermark_2F2_2Ftext_2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ_3D_3D_2Ffont_2F5a6L5L2T_2Ffontsize_2F400_2Ffill_2FI0JBQkFCMA_3D_3D_2Fdissolve_2F70_2Fgravity_2FSouthEast_refer_http_3A_2F_2Fblog.csdn.net_2Fwangjingna_2Farticle_2Fdetails_2F32713695]: https://www.php.cn/inc/test.jsp?url=http%3A%2F%2Fimg.blog.csdn.net%2F20140620174119406%3Fwatermark%2F2%2Ftext%2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ%3D%3D%2Ffont%2F5a6L5L2T%2Ffontsize%2F400%2Ffill%2FI0JBQkFCMA%3D%3D%2Fdissolve%2F70%2Fgravity%2FSouthEast&refer=http%3A%2F%2Fblog.csdn.net%2Fwangjingna%2Farticle%2Fdetails%2F32713695
[test.jsp_url_http_3A_2F_2Fimg.blog.csdn.net_2F20140620170450765_3Fwatermark_2F2_2Ftext_2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ_3D_3D_2Ffont_2F5a6L5L2T_2Ffontsize_2F400_2Ffill_2FI0JBQkFCMA_3D_3D_2Fdissolve_2F70_2Fgravity_2FSouthEast_refer_http_3A_2F_2Fblog.csdn.net_2Fwangjingna_2Farticle_2Fdetails_2F32713695]: https://www.php.cn/inc/test.jsp?url=http%3A%2F%2Fimg.blog.csdn.net%2F20140620170450765%3Fwatermark%2F2%2Ftext%2FaHR0cDovL2Jsb2cuY3Nkbi5uZXQvd2FuZ2ppbmduYQ%3D%3D%2Ffont%2F5a6L5L2T%2Ffontsize%2F400%2Ffill%2FI0JBQkFCMA%3D%3D%2Fdissolve%2F70%2Fgravity%2FSouthEast&refer=http%3A%2F%2Fblog.csdn.net%2Fwangjingna%2Farticle%2Fdetails%2F32713695
[f68f2add0b68e4f9810432fce46917b7.png]: /images/20221024/feaad369f29947348b8241d7a57feac3.png