sql客户端登录前握手错误 [英] sql client pre-login handshake error

问题描述

您好

我可以从我当地的sql server管理工作室连接到远程sql服务器。

但是当我想连接到这个网络服务器时，来自visual studio（ SqlClient），我给出以下错误：

与服务器成功建立连接，但在登录前握手期间发生错误。（提供者：SSL提供者，错误：0 - 等待操作超时。）



我可以从另一个客户端视觉工作室连接到这个远程sql服务器非常了不起。

我启用了sql server tcp / ip和命名管道。



请帮帮我。谢谢。

Hello
I can connect to remote sql server from my local sql server management studio.
But when I want to connect to this network server, from visual studio (SqlClient), I give following error:
"A connection was successfully established with the server,but then an error occurred during the pre-login handshake.(provider: SSL Provider, error:0 - The wait operation timed out.)

It's remarkable that I can connect to this remote sql server from another client visual studio.
I've enabled sql server tcp/ip and named pipes .

please help me. Thank you.

推荐答案

那里 A提供了许多解决方案已成功与服务器建立连接，但在登录前握手期间发生错误 [ ^ ]。尝试一下。

There are many solutions given at A connection was successfully established with the server, but then an error occurred during the pre-login handshake[^]. Try them.

在我的情况下，我有一个名为Covenant Eyes的内容过滤器/代理，这可能是原因。


我尝试修复SQL Server 2012的安装，它崩溃了安装，仍然没有解决问题。一旦我生成了卸载代码并卸载了过滤器，我就可以连接;我甚至不需要重启。



检查机器上的代理和内容过滤器并禁用它们！

In my situation, I had a content filter/proxy called Covenant Eyes that was the likely cause.

I tried repairing the install of SQL server 2012 and it crashed the install and still did not fix the problem. As soon as I generated an uninstall code and uninstalled the filter, I could connect; I did not even have to reboot.

Check for proxies and content filters on the machine and disable them!

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