SQL 2005登录错误:已成功与服务器建立连接，但是在登录前握手期间发生了错误 [英] SQL 2005 Login Error: A connection was successfully established with the server, but then an error occurred during the pre-login handshake
问题描述
大家好
我正在尝试使用Microsoft SQL Server Management Studio专用的ip连接到sql 2005共享服务器.
我没有问题可以连接和使用它，但是过一会儿，连接将关闭并且需要重新连接，我尝试这样做，但是出现以下错误:
已成功与服务器建立连接，但是在登录前握手期间发生错误"
有趣的一点是，当我尝试与另一台PC连接(我的意思是通过另一台Internet连接)时，该连接将被正确创建.
我在Google上进行了搜索，发现了一些解决方案，例如:启用管道名称和tcp连接，但没有人帮助我.
如果您有想法，请帮助我.
在此先感谢
Hello everyone
I''m trying to connect to a sql 2005 shared server with a dedicated Ip by Microsoft Sql server management studio.
I have no problem to connect and use it, but after a while, the connection will be closed and need to reconnect, I try to do, but the following error appears:
"A connection was successfully established with the server, but then an error occurred during the pre-login handshake"
The interesting point is, when I try to connect with another PC ( with another internet connection I mean ), the connection will be created with no errors.
I''ve googled it and found some solutions like: enabling the pipe names and tcp connections, but no one helped me.
if you have an idea, please help me.
thanks in advance
推荐答案
类似的声音可能是您的网络出现的问题.如果您使用的是SSMS，是否尝试增加连接超时参数，然后再尝试连接到服务器.
Sounds like this could be an issue with your network. if you''re using SSMS, have you tried increasing the connection time-out parameter before attempting to connect to the server.
连接到SQL Server 2008上的远程SQL Server数据库时，出现错误与服务器成功建立连接，但登录前握手时发生错误"
问题
BizTalk Server失去与容纳BizTalk Server数据库的远程SQL Server计算机的连接，并生成错误消息:
原因
如果满足以下一个或多个条件，则可能会出现此问题:
* SQL Server未配置为接受远程连接.
*在运行BizTalk Server的SQL Server计算机或SQL Server客户端计算机上，未启用SQL Server的必需协议.
决议
请按照以下步骤解决此问题:
* SQL Server外围应用配置器工具在SQL Server 2008上不可用.要在SQL Server 2008计算机上启用SQL Server的远程连接，请按照SQL Server 2008联机帮助中的说明进行操作.
*使用SQL Server配置管理器工具在SQL Server计算机上启用TCP/IP和/或命名管道协议.
1.单击开始"，指向所有程序"，然后单击"SQL Server配置管理器".
2.单击以展开"SQL Server网络配置"，然后单击"MSSQLSERVER协议".
3.右键单击TCP/IP协议，然后单击启用".
4.右键单击命名管道"协议，然后单击启用".
5.关闭SQL Server配置管理器工具.
*使用SQL Server配置管理器工具在运行BizTalk Server的SQL Server客户端计算机上启用TCP/IP和/或命名管道协议.
1.单击开始"，指向所有程序"，然后单击"SQL Server配置管理器".
2.单击以展开"SQL Server网络配置"，然后单击"ClientProtocols".
3.右键单击TCP/IP协议，然后单击启用".
4.右键单击命名管道"协议，然后单击启用".
5.关闭SQL Server配置管理器工具.
Error "A connection was successfully established with the server, but then an error occurred during the pre-login handshake" occurs when connecting to remote SQL Server databases on SQL Server 2008
Problem
BizTalk Server loses connectivity with a remote SQL Server computer that houses the BizTalk Server databases and an error message is generated:
Cause
This problem may occur if one or more of the following conditions is true:
* SQL Server is not configured to accept remote connections.
* The necessary protocols for SQL Server are not enabled on either the SQL Server computer or the SQL Server client computer that is running BizTalk Server.
Resolution
Follow these steps to resolve this problem:
* The SQL Server Surface Area Configuration tool is not available on SQL Server 2008. To enable remote connections for SQL Server on a SQL Server 2008 computer follow the instructions in the SQL Server 2008 online help.
* Use the SQL Server Configuration Manager tool to enable the TCP/IP and/or the Named Pipes protocols on the SQL Server computer.
1. Click Start, point to All Programs, and click SQL Server Configuration Manager.
2. Click to expand SQL Server Network Configuration and then click Protocols for MSSQLSERVER.
3. Right-click the TCP/IP protocol and then click Enable.
4. Right-click the Named Pipes protocol and then click Enable.
5. Close the SQL Server Configuration Manager tool.
* Use the SQL Server Configuration Manager tool to enable the TCP/IP and/or the Named Pipes protocols on the SQL Server client computer that is running BizTalk Server.
1. Click Start, point to All Programs, and click SQL Server Configuration Manager.
2. Click to expand SQL Server Network Configuration and then click ClientProtocols.
3. Right-click the TCP/IP protocol and then click Enable.
4. Right-click the Named Pipes protocol and then click Enable.
5. Close the SQL Server Configuration Manager tool.
这篇关于SQL 2005登录错误:已成功与服务器建立连接，但是在登录前握手期间发生了错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
