Authentication error while start and stop Azure-SSIS Integration Runtime on a schedule

Aravind Reddy 41 Reputation points
2021-11-02T06:38:44.73+00:00

Hi all,
So basically, i have created a pipeline(Start IR ) which starts the Azure-SSIS integration runtime(qa-ssis-ir). and i have used this newly created integration run time as a part of setting up Start IR pipeline. but right now i am facing an authentication issue. i am kind of new to this azure and creating pipelines, Vnet configurations stuff. can you help me out with this error?

Error descritption:-

Operation on target Start IR failed: {"error":{"code":"AuthorizationFailed","message":"The client 'XXXXXXXXXXXXXXX' with object id 'XXXXXXXXXXXXXXX' does not have authorization to perform action 'Microsoft.DataFactory/factories/integrationRuntimes/start/action' over scope '/subscriptions/XXXXXXXXXXXXXXXX/resourceGroups/imd-inovcare-data-qa-rg/providers/Microsoft.DataFactory/factories/qa-df/integrationRuntimes/qa-ssis-ir' or the scope is invalid. If access was recently granted, please refresh your credentials."}}

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,643 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2021-11-03T00:38:50.557+00:00

    Hi @Aravind Reddy ,

    Welcome to Microsoft Q&A forum and thanks for posting your query.

    In order to overcome this error message, you need to assign the managed identity for your ADF a Contributor role to itself, so Web activities in its pipelines can call REST API to start/stop Azure-SSIS IRs provisioned in it. In order to do so, on your ADF page in Azure portal, click Access control (IAM) , click + Add role assignment, and then on Add role assignment blade, do the following actions:

    1. For Role, select Contributor.
    2. For Assign access to, select Azure AD user, group, or service principal.
    3. For Select, search for your ADF name and select it.
    4. Click Save.
      145938-image.png

    For more info please refer to this doc: Create and schedule ADF pipelines that start and or stop Azure-SSIS IR

    Hope this info helps. Do let us know of you have further query.

    ----------

    • Please don't forget to click on 130616-image.png and upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful