登录前握手SQL 2012和VS 2012 [英] Pre-Login handshake SQL 2012 and VS 2012

问题描述

得到此错误与服务器成功建立了连接，但是在登录前握手期间发生了错误."通过SQL Management Studio 2012和VS 2012连接到服务器时，但通过SQL Management Studio 2008和VS 2010连接到同一服务器时，使用相同的登录名和相同的密码有效.SQL Server启用了TCP/IP，并且禁用了NamedPipes.未安装SSL.配置了防火墙并启用了端口. SQL服务在网络服务下运行.有任何想法吗?

Got this error "A connection was successfully established with the server, but then an error occurred during the pre-login handshake." when connecting to the server via SQL management studio 2012 and VS 2012. But works when connecting to the same server same login same password via SQL management studio 2008 and VS 2010. The SQL server has TCP/IP enabled and NamedPipes disabled. No SSL installed. Firewall configured and port is enabled. SQL services run under network service. Any ideas?

推荐答案

也许这并不是您要找的东西，但这可能会有所帮助:
http://msdn.microsoft.com/en-us/library/aa952081％28v = bts.20％29.aspx [ ^ ]

Maybe this is not exactly what you''re looking for, but it might be helpful:
http://msdn.microsoft.com/en-us/library/aa952081%28v=bts.20%29.aspx[^]
http://www.escapekeys.com/blog/index.cfm/2011/1/26/Microsoft-SQL-Server-Error-64-A-connection-was-successfully-established-with-the-server[^]

需要对DB服务器中的防火墙设置进行域检查.

The firewall settings in the DB server needs to have domain checked.

这篇关于登录前握手SQL 2012和VS 2012的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！