unable connect Azure Synapse database

Vineet S 265 Reputation points
2024-07-01T19:38:25.9533333+00:00

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

'

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,621 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,015 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 84,381 Reputation points Microsoft Employee
    2024-07-02T02:50:19.71+00:00

    @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.

    User's image

    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.

    0 comments