SSIS Scale out security: run as

• Glennvancauter

  SSC Enthusiast

  Points: 113

  More actions

  May 10, 2021 at 1:24 pm

  #3881461

  Hi Everyone,

  I have a SQL Server 2019 SSIS scale out setup with 1 scale out master and 2 scale out workers.

  The SSIS packages are executed by the service account running the scale out worker service. So in order to execute the packages I have to grant access to a lot of resources to the worker service account.

  Anyone have an idea on how to avoid this? I don't think there's a "run as" option or the option to use a proxy account...

  Regards,

  Glenn

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  May 11, 2021 at 2:10 pm

  #3881909

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.