您尝试连接的SQL Server实例需要加密，但本机不支持加密。 [英] The instance of SQL Server you attempted to connect to requires encryption but this machine does not support it.

问题描述

尝试从控制台应用程序或Asp.net Web应用程序连接Azure SQL   在Windows Server 2008 r2 使用.Net framework 4.5.1安装Entity framework 5.0并获得以下错误。连接字符串和每件东西看起来都是
罚款且相同 从本地Windows 10环境机器连接的应用程序

未处理的异常：System.Data.EntityException：基础提供程序失败 打开。 ---> System.Data.SqlClient.SqlException：您的SQL Server实例 试图连接到需要加密，但这台机器不支持
。

是否有任何人遇到此问题

解决方案

Azure SQL
要求始终对所有连接进行加密。

确保您包含"加密=开启"和"TrustServerCertificate = Off"在
中指定
这里以准备客户端连接到那里。

如果检查连接字符串后仍然失败，请检查下半部分
这篇知识库文章（第一个问题是关于数据库服务器配置，并且在您使用Azure SQL时对您无关）并查看其中的任何设置是否有帮助。

Iam trying to connect Azure SQL from Console app or Asp.net web application   in Windows Server 2008 r2  with .Net framework 4.5.1 using Entity framework 5.0 installed and getting the below error . The connecting string and every thing looks fine and same  application connecting from local windows 10 environment machine

Unhandled Exception: System.Data.EntityException: The underlying provider failed  to Open. ---> System.Data.SqlClient.SqlException: The instance of SQL Server you  attempted to connect to requires encryption but this machine does not support it.

Has any one faced this issue

解决方案

Azure SQL mandates encrpytion on all connection all the time.

Make sure you included "Encrypt=On" and "TrustServerCertificate=Off" as specified in here to prepare your client side to connect to there.

If still fails after checking connection string, check the second half of this KB article (the first helf is about database server configuration and is irrelevent to you as you're using Azure SQL) and see if any settings there can help.

这篇关于您尝试连接的SQL Server实例需要加密，但本机不支持加密。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！