unable connect Azure Synapse database

Question

Hi,

while creating link services for connecting azure synapse database..i am getting error that

Insufficient permissions to call this API. 1829be47-97cd-4a80-b8f7-9402f8fbcc20 does not have Microsoft.Synapse/workspaces/credentials/useSecret/action on scope workspaces/ag-knx-syn-d/credentials/WorkspaceSystemIdentity  Activity ID: 4c91e928-d75b-4a12-868d-a2d018798337

I have contributor access and also has access to database but still unable to connect

'

Answer 1

@Vineet S - Thanks for the question and using MS Q&A platform.

It seems like the service principal was given the Contributor role instead of the Synapse Administrator role. According to the role overview, the Synapse Admin role is required to perform certain actions, including managing credentials.

To resolve this issue, you can assign the service principal the Synapse Administrator role in the Azure Synapse Analytics workspace. You can do this by following these steps:

1. Go to the Azure Synapse Analytics workspace in the Azure portal and select "Open synapse studio".
2. Go to Manage and under Security, click on the "Access control" tab.
3. Click on the "Add" button and select "Add role assignment".
4. In the "Add role assignment" blade, select the "Synapse Administrator" role.
5. In the "Add role assignment" blade, select the service principal that you want to assign the role to.
6. Click on the "Apply" button to save the role assignment.

After assigning the Synapse Administrator role to the service principal, try creating the linked service again and see if the issue is resolved.

For more details, refer to How to manage Synapse RBAC role assignments in Synapse Studio.

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.