failed to enable interactive authoring capability in Integrtion Pipele

rajendar erabathini 616 Reputation points
2021-02-06T13:58:32.873+00:00

HI - I am receiving below error in Integration pipeline when trying to enable Interactive authoring. What all are the access roles i need to perform this action. Appreciate your response.

64750-image.png

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,472 questions
0 comments No comments
{count} votes

Accepted answer
  1. rajendar erabathini 616 Reputation points
    2021-02-10T16:06:48.253+00:00

    HI @KranthiPakala-MSFT - Looks like we also need "Synapse Credential User" role access and after getting this role I am able to connect now. Thanks for your help and we can close this issue now.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,427 Reputation points Microsoft Employee
    2021-02-07T18:58:29.08+00:00

    Hi @rajendarerabathini-1405,

    Thank for posting your query.
    From the error message seems like your are trying to enable Interactive authoring of your Azure IR in Azure Synapse Analytics workspace and failing with authorization issue.

    In order to Create, update, or delete an Integration runtime in your workspace you need to have Azure Owner or Contributor on the workspace.

    64956-image.png

    Here is the MS doc that has info about common tasks and for each task, the Synapse RBAC, or Azure RBAC roles required: Tasks and required roles for Azure Synapse Analytics workspace

    Please make sure to grant the required roles based on the task to be performed as called out in the document.

    Additional helpful doc: What is Azure role-based access control (Azure RBAC)?

    Hope this info helps.

    ----------

    Thank you
    Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.

    1 person found this answer helpful.