Home

LinqPad 7 with SQL Server "Always Encrypted" / Azure Key Vault

db30db30
edited April 4

Hello, I have a database with tables using "always encrypted" columns.

I was able to run queries in LINQPad7 with encryption keys stored in Windows store by using Datacontext "Entity Framework Core" and using "Column Encryption Setting=Enabled".

I am having trouble getting it working with encryption keys stored in Azure KeyVault.

Error "SqlException: Failed to decrypt column 'Role'. 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."

Is there any solution for this other than mentioned here -https://forum.linqpad.net/discussion/1193/solved-linqpad-5-with-sql-server-always-encrypted

Any help is really appreciated

· Share on FacebookShare on Twitter
Sign In or Register to comment.