名称为“mykey”的密钥在提供程序中不存在或访问被拒绝。提供商错误代码：3113。（提供商错误 - 无法解释，详情请咨询EKM提供商） [英] Key with name 'mykey' does not exist in the provider or access is denied. Provider error code: 3113. (Provider Error - No explanation is available, consult EKM Provider for details)

问题描述

使用SQL Server连接器模板验证访问策略权限。 卸载并重新安装最新的SQL连接器。 创建了regkey  SQL Server.Cryptographic Provider和SQL Server加密提供程序，具有完全权限
到SQL服务登录。 事件日志显示以下错误

无法找到源SQL Server Connector for Microsoft Azure Key Vault中的事件ID 2的说明。引发此事件的组件未安装在本地计算机上，或者安装已损坏。您可以在本地计算机上安装或修复
组件。



如果事件源自另一台计算机，则显示信息必须与事件一起保存。$


活动中包含以下信息： 
$


保险柜名称：< vaultnameremoved> ; .vault.azure.net

操作：getKeyByName

键名：MyTestKey

消息：[错误：113，信息：403，状态：0]服务器响应403，因为用户没有执行操作的适当权限。请确保您拥有指定操作的权限。至少需要'get，list，wrapKey，unwrapKey'权限
。

解决方案

< blockquote>您是否在Azure Key Vault的访问策略刀片上为用户授予了适当的权限。  

Verified Access Policy permissions using SQL Server Connector Template.  Uninstalled and Reinstalled the latest SQL Connector.  Created the regkey SQL Server.Cryptographic Provider and SQL Server Cryptographic Provider with full permissions to SQL Service login.  Event log shows following error

The description for Event ID 2 from source SQL Server Connector for Microsoft Azure Key Vault cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event: 

Vault Name: <vaultnameremoved>.vault.azure.net
Operation: getKeyByName
Key Name: MyTestKey
Message: [error:113, info:403, state:0] The server responded 403, because the user does not have proper permission to perform the action. Please make sure you have the permission for the specified operation. At minimum,'get, list, wrapKey, unwrapKey' permissions are required.

解决方案

Have you given proper permissions to the user on the access policy blade of Azure Key Vault.  

这篇关于名称为“mykey”的密钥在提供程序中不存在或访问被拒绝。提供商错误代码：3113。（提供商错误 - 无法解释，详情请咨询EKM提供商）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！