禁用TLS1.0后出现Sql server连接问题 [英] Sql server connection problem after disabling TLS1.0

问题描述

在.net framework 3.5和sql server 2005上构建的应用程序。



出于安全原因，我们已禁用TLS1.0。



完成后我们可以使用Management Studio连接到远程sql服务器但是当我们将相同的sql server指向我们的应用程序时，我们收到错误

Out application built on .net framework 3.5 and sql server 2005.

For security reason we have disabled TLS1.0.

After doing it we are able to connect to remote sql server using Management Studio but when we point the same sql server to our application we are getting the error

Logged~Database~0~A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The client and server cannot communicate, because they do not possess a common algorithm.)~S0000!

我尝试了什么：



我们尝试过从数据库服务器访问所有协议但没有运气。

What I have tried:

We have tried giving all protocol access from database server but no luck.

推荐答案

确保您的应用程序在支持TLS 1.1的操作系统上运行，并使用Microsoft的补丁启用.NET 3.5来使用它：

< a href =https://support.microsoft.com/en-gb/help/3154519/support-for-tls-system-default-versions-included-in-the--net-framework>支持TLS系统Windows Server 2012上的.NET Framework 3.5中包含的默认版本 [ ^ ]



取决于在操作系统中，您可能还需要启用TLS 1.1作为客户端协议。最简单的方法是通过Internet Explorer的高级选项。

Make sure your application is running on an OS which supports TLS 1.1, and use the patch from Microsoft to enable .NET 3.5 to use it:
Support for TLS System Default Versions included in the .NET Framework 3.5 on Windows Server 2012[^]

Depending on the OS, you might also need to enable TLS 1.1 as a client protocol. The simplest way to do that is through Internet Explorer's "Advanced" options.

这篇关于禁用TLS1.0后出现Sql server连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！