且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

尝试使用登录前握手时出现超时错误

更新时间:2023-02-22 17:38:30

您好alrusso,

Hi alrusso,

基于在我的研究中,错误通常发生在以下可能性中:

Based on my research, the error commonly occurs in the following possibilities:

1。 SQL Server数据库引擎的一个实例未运行。

2. SQL Server Browser服务未运行。

3.禁用TCP / IP。 />
4.服务器名称输入错误。

5.存在网络问题。

6.数据库引擎实例的TCP / IP端口被防火墙阻止。

7.客户端和服务器未配置为使用相同的网络协议。 

1. An instance of the SQL Server Database Engine is not running.
2. The SQL Server Browser service is not running.
3. The TCP/IP is disabled.
4. The server name was typed incorrectly.
5. There are network problems.
6. The TCP/IP port for the Database Engine instance is blocked by a firewall.
7. The client and server are not configured to use the same network protocol. 

那么对于解决方案,请参考以下文章:

Then for the solutions, please refer to following articles:

https://blog.devoworx.net/2017/01/30/connection-timeout-expired-pre-login-handshake/  

https://social.technet.microsoft .COM /论坛/ EN-US / 84b08d13-ca15-4295-bf10-3a6f195fcf35 / SQL服务器 - 预登录握手?论坛= sqldat abaseengine  

谢谢,b
Xi Jin。

Thanks,
Xi Jin.