Not able to access the secrets in keyvault??

Question

i have been trying to migrate a database from my enterprise edition of microsoft SQL server.i have used express setup for the integration runtime setup.But when i try to access the password from the key vault iam getting error as attached.can someone help me ???iam entirely new to azure and doing some demo projects for better understanding.Any help is appreciated.

Answer 1

@Rufaid P

Thank you for your post and for sharing a screenshot of your error message!

Error:

Operation returned an invalid status code 'Forbidden'.

Based off your error message, there are two reasons you could be running into the Forbidden message, and to help point you in the right direction or resolve your issue, I'll share the solutions below.

Common error codes for Azure Key Vault:

From the Azure Key Vault side of things, you could be running into a firewall or insufficient permissions related issue.

Azure Key Vault Firewall:

If your Key Vault has its Firewall enabled, please make sure that you've configured it correctly to allow Trusted Services Only (as needed), and that you've added the appropriate IP addresses or Private Link configurations.

Key Vault Access Policy:

If your issue isn't related to your vault's firewall, please make sure that your vault's access policies or RBAC role assignments are correctly set up for the actual calling identity.

For example, if you're using a system assigned managed identity through your Azure Data Factory, please make sure that the object ID of that managed identity has the correct key vault permissions to GET your Keys or Secrets. For more info - Data Factory Store credentials in Azure Key Vault.

For more info - Troubleshooting Azure Key Vault access policy issues

• Using Azure RBAC secret, key, and certificate permissions with Key Vault
• Assign a Key Vault access policy (legacy)

Additional Links:

• Operation returned an invalid status code 'Forbidden'
• Configure Azure Key Vault firewalls and virtual networks
• Recommended troubleshooting Steps for following error types
• Common error codes for Azure Key Vault

I hope this helps!

If you have any other questions, please let me know. Thank you for your time and patience throughout this issue.

---

If the information helped address your question, please Accept the answer. This will help us and also improve searchability for others in the community who might be researching similar information.