I am creating an asymmetric key on the SQL Server database and have the SQL connector for Azure Key Vault installed and I am following the steps mentioned in the link setup steps for extensible key management using the azure key vault.
I am able to create CRYPTOGRAPHIC PROVIDER and credential, but when I try to create Asymmetric key using the below query, I get an error
CREATE ASYMMETRIC KEY EKMASYKey
FROM PROVIDER [KeyVault_EKM]
WITH PROVIDER_KEY_NAME = 'CMKAuto1',
CREATION_DISPOSITION = OPEN_EXISTING;
Below is the error I get
Cannot open session for cryptographic provider 'KeyVault_EKM'. Provider error code: 2050. (Provider Error - No explanation is available, consult EKM Provider for details)
I have seen similar questions Here and set up "SQL Server Cryptographic Provider" in registry and provided permissions to the service account under which SQL server is running (NT Service\MSSQLSERVER) with full control and have reviewed the permissions. but still get this error
Is there anything else I would need to setup that I am missing.