连接超时到期... [预登录]初始化= 211; handsake = 14787; [英] Connection Timeout Expired ... [Pre-Login] initialization=211; handsake=14787;

问题描述

我必须在我的Visual Studio 2017社区中添加基于服务的数据库"，但是我发现了以下消息: 连接超时已到期.尝试使用登录前握手确认时已过超时时间.这可能是因为登录前握手失败或服务器无法及时响应.尝试连接到此之前所花费的时间服务器是-[登录前]初始化= 211；握手= 14787；" 谁能告诉我我该怎么办?

I have to add "service based database" in my visual studio 2017 community, but i found this message: "Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=211; handshake=14787;" can anyone tell me what i must to do?

推荐答案

在以下情况下通常会发生连接超时过期"错误:

The "Connection Timeout expired" error commonly occurs in the following cases:

• SQL Server数据库引擎的实例未运行.
• SQL Server浏览器服务未运行.
• TCP/IP被禁用.
• 服务器名称输入错误.
• 存在网络问题.
• 数据库引擎实例的TCP/IP端口被防火墙阻止.
• 客户端和服务器未配置为使用相同的网络协议.

此链接可能会为您提供帮助，连接超时已过期

this link might help you, Connection Timeout expired

这篇关于连接超时到期... [预登录]初始化= 211; handsake = 14787;的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！