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屋!