How do we setup access key vault for azure sql database userid and password

Question

hi

i have created the keyvault. but stuck to create secret keys via azure db resource.

my access policy create button is disabled.

hence not able to create secret name and access key inorder to change linked service direct db access to linked service via keyvault access.

can you advise how to enable the access policy. also how to add my useraccount to see in the access policy.

regards

sudha

Answer 1

Hi @Sudha Achuthan , I understand you have issues with Azure Key Vault authorization.

Azure Key Vault offers two authorization systems: Azure role-based access control (Azure RBAC), which operates on Azure's control and data planes, and the access policy model, which operates on the data plane alone.

It's recommended to use Azure RBAC, as the access policy model is a legacy authorization system.

If your Key Vault is still using access policy model, change it to enable RBAC authorization.

Then review Azure Built-in Roles for Key Vault Data Plane operation and assign the appropriate role, e.g. Key Vault Secrets Officer, to your user.

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.