如何解决连接到SQL Server的错误:SSL提供程序,error:0 - 收到的消息是意外或格式错误错误、如何解决、连接到、意外

2023-09-03 16:23:18 作者:萌萌哒の小傻瓜

这是我的本地开发中使用Visual Studio 2012(或2013)对SQL Server 2008 R2 SP1的连接时,我得到这个消息:

When connecting from my local dev box using Visual Studio 2012 (or 2013) against a SQL Server 2008R2 SP1, I get this message:

一个连接成功建立与服务器,但随后的   在登录过程中发生错误。 (提供者:SSL提供商,   错误:0 - 收到的消息是意外或格式)

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The message received was unexpected or badly formatted.)

我的.NET框架版本是当地4.5.50938

My version of .Net framework locally is 4.5.50938

我的同事有完全相同的问题。我也相信我有这个问题前面,然后再重新安装电脑,当我有SSMS 2012安装,因为这也依赖于NET框架4,不净V2作为SSMS2008R2,工作正常。这也将是有意义的,在Visual Studio中的内部数据工具依赖于.NET 4中。

My colleague has the exact same problem. I also believe I had the problem earlier, before re-installing the pc, when I had SSMS 2012 installed, as that also relies on .Net framework 4, not .Net v2 as SSMS2008R2, which works fine. It would also make sense, that the internal data tooling in visual studio relies on .Net 4.

这个问题并不是一直在那里,我相信它被介绍时,我第一次安装了Visual Studio 2013 - 再稍后再重新安装后,最有可能的更新.net框架后

The problem has not always been there, and I believe it was introduced when I first installed Visual Studio 2013 - and then again later after a reinstall, most likely after updating the .Net framework.

这个问题似乎我连接对SQL Server 2008 R2 SP1时,涉及到System.Data这在这个版本的.NET Framework。

The problem seems to me to be related to System.Data in this version of the .Net framework, when connecting against a SQL Server 2008R2 SP1.

我该如何解决这个问题?是否有任何已知的修复,更新等?

How can I fix this? Are there any known fixes, updates etc?

不幸的是更新的SQL Server 2008R2SP1目前还不是一个选项。

Unfortunately updating SQL Server 2008R2SP1 is not currently an option.

我也搜索解决方案,但没有发现任何有用的,到目前为止。这里有几个链接到其他岗位有类似的问题:

I have also searched for solutions, but have found nothing usable, so far. Here are a couple of links to other posts with similar issue:

http://social.msdn.microsoft.com/Forums/en-US/ea2c470f-14ba-4864-8a39-1396f4e361e8/sqlconnection-now-failing-exception-when-connecting-to-remote-instance?forum=sqldataaccess

http://www.sqlservercentral.com/Forums/Topic1529609-2799-1.aspx

推荐答案

您只剩下下面的选项根据Microsoft的指示:

You are only left with the following options as instructed by Microsoft:

卸载有问题的LSP或BSP(即,Sophos的防病毒) 在卸载的.NET Framework 4.5.1(因而,VS 2013将无法正常工作) 在安装的.NET Framework 4.5.2

参考: http://support.microsoft.com/kb/2915689