locked
AZURE KEY VAULT - Failed To retrieve Key Information RRS feed

  • Question

  • We are using always encrypted  in Azure SQL Database and encrypted few column. They Key information is stored in “Azure Key Vault”.

    Now in our Power BI report we use ODBC 17 to decrypt the values but it fails with below error message:

    Details: "ODBC: ERROR [CE275] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error requesting access token, HTTP status 400, expected 200

    ERROR [CE275] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error requesting access token, HTTP status 41360, expected 200

    ERROR [CE258] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error retrieving key information for https://genralkeyvault.vault.azure.net:443/keys/CMKAuto3/2e7e81645b1d4ac6a1506465ede763eb

    ERROR [CE202] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The keystore provider AZURE_KEY_VAULT failed to decrypt the ECEK https://genralkeyvault.vault.azure.net:443/keys/CMKAuto3/2e7e81645b1d4ac6a1506465ede763eb with RSA_OAEP."

    We are also using  below parameter in our ODBC connection string but it did not worked and failed with same above error.

    columnencryption=Enabled;keystoreauthentication=;keystoreprincipalid=;keystoresecret=

    Kindly help us in fixing this issue.

    Tuesday, May 14, 2019 4:26 AM

All replies