Unable to load secrets when creating a linked service using Synapse

Question

Hello -

I have this setup and but I am facing some issues:

Created a key Vault

Public access disabled

Created private endpoint for the key vault

Create Private DNS records/Zones and link so all is working and I can see them

I created secrets for Oracle as such:

a) create the ks-connectstring=jdbc:oracle:thin:@hostaname:portno/servicename

b) created secrets for oracle username and password

I created a user managed identity for the synapse and added to access key policy on Key Vault

Created a Access Policy to be able to access the keys/secrets and I can see the keys.

I created a Linked Service on Azure Synapse on the Key vault and is connected fine

I tried to create a Linked service on Oracle using the Key vault but when I try to Load the secrets is not working.

I get this error (error loading) as shown on print screen.

Please can you help!

Answer 1

Hi Xhevahir Mehalla,

I suggest you to verify the permission model on key vault and associate to the managed identity that you are using.

Please check :

• Access Policy and Management model thread: https://learn.microsoft.com/en-us/answers/questions/1306020/access-policies-not-available
• Access Policy and RBAC thread: https://learn.microsoft.com/en-us/answers/questions/816270/provide-access-to-key-vault-keys-certificates-and
• Linked service publish https://learn.microsoft.com/en-us/answers/questions/1282897/unable-to-access-azure-secret-key-vault-even-thoug

If the information helped address your question, please Accept the answer.

Luis