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

Sudha Achuthan 20 Reputation points
2024-06-18T11:10:43.69+00:00

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

Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
1,173 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,014 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Silvia Wibowo 3,411 Reputation points Microsoft Employee
    2024-06-19T00:20:39.3+00:00

    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.