SSRS 中的 AZURE_KEY_VAULT 提供程序

SSRS 中的 AZURE_KEY_VAULT 提供程序

我最近在本地 SQL Server 数据库上设置了 Always Encryption,并使用 Azure Key Vault 中的列主密钥。如果我从 SSMS 中的表中选择“列加密设置 = 已启用”,我可以以纯文本形式读取该列,因此_我非常有信心*加密按预期运行。

现在我想在 Visual Studio 2017 中将 SSRS 报告投射到该表上。我的数据源使用集成安全性,并且我已将“列加密设置 = 已启用”添加到连接字符串,但 SSRS 无法解密该列。我收到以下错误:

[rsMissingFieldInDataSet] The dataset ‘DataSet1’ contains a definition for the Field ‘Number’. This field is missing from the returned result set from the data source.
[rsErrorReadingDataSetField] The dataset ‘DataSet1’ contains a definition for the Field ‘Number’. The data extension returned an error during reading the field. System.Data.SqlClient.SqlException (0x80131904): Failed to decrypt column 'Number'.
Failed to decrypt a column encryption key. Invalid key store provider name: 'AZURE_KEY_VAULT'. A key store provider name must denote either a system key store provider or a registered custom key store provider. Valid system key store provider names are: 'MSSQL_CERTIFICATE_STORE', 'MSSQL_CNG_STORE', 'MSSQL_CSP_PROVIDER'. Valid (currently registered) custom key store provider names are: . Please verify key store provider information in column master key definitions in the database, and verify all custom key store providers used in your application are registered properly. ---> System.ArgumentException: Failed to decrypt a column encryption key. Invalid key store provider name: 'AZURE_KEY_VAULT'. A key store provider name must denote either a system key store provider or a registered custom key store provider. Valid system key store provider names are: 'MSSQL_CERTIFICATE_STORE', 'MSSQL_CNG_STORE', 'MSSQL_CSP_PROVIDER'. Valid (currently registered) custom key store provider names are: . Please verify key store provider information in column master key definitions in the database, and verify all custom key store providers used in your application are registered properly.

SSRS 解决方案似乎不支持 Nuget,我已经将我能想到的所有 Azure 先决条件和扩展都安装到了 Visual Studio 中。有没有办法将 AZURE_KEY_VAULT 注册为 SSRS 的密钥存储提供程序?

相关内容