Can't able to connect to Key Vault from SSMS for configuring Always Encrypted columns

Vasanth Janakiraman 96

I am trying to create a CMK for a database to configure Always Encrypted column. And am getting the below error in SSMS while connecting to the Azure Key Vault. Any insight on how to fix this error would be helpful.

Vasanth Janakiraman 96 Reputation points

2021-12-03T18:39:55.967+00:00

PS: I have created an access policy and given all the permissions to keys for the ID I am using to connect the vault
GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee

2021-12-08T00:29:26.533+00:00

Hi @Vasanth Janakiraman Thanks for posting your question in Mirosoft Q&A
By seeing the error screenshot I want to check if you have provided access to the account which you are using to connect to Azure SQL and Azure Key Vault as shown below. please provide more information.

Regards
Geetha

Accepted answer

Vasanth Janakiraman 96 Reputation points

2021-12-08T15:05:32.923+00:00

Hi @GeethaThatipatri-MSFT , Thanks for getting back. This issue got resolved after I removed the "Get-Rotation" policy in the access policies for the user.
Please sign in to rate this answer.
GeethaThatipatri-MSFT 27,102 Reputation points Microsoft Employee

2021-12-08T17:42:57.993+00:00

Hi, @Vasanth Janakiraman I'm glad that your issue is resolved, and thanks for sharing the information.

Regards
Geetha

Saurabh Sharma 23,671 Reputation points Microsoft Employee

2021-12-09T20:12:02.563+00:00

Hi, @Vasanth Janakiraman ,

Thanks for sharing your solution. Please feel free to accept your answer and it will help other community members looking for solution.

Thanks
Saurabh
Sign in to comment

Can't able to connect to Key Vault from SSMS for configuring Always Encrypted columns

0 additional answers