SSIS Scale Out and its services on local group policies

Damodhar 1 Reputation point
2020-08-04T18:26:45.42+00:00

As per MS recommendation, scale out master service and worker service accounts should be member of which local group policies ?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,449 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,891 Reputation points
    2020-08-05T01:37:44.487+00:00

    Hi Damodhar,
    The Scale Out Master service is a Windows service that is responsible for the communication with Scale Out Workers. It returns the status of package executions on Scale Out Workers over HTTPS and operates on the data in SSISDB.
    The Scale Out Master service log file is located in the <drive>:\Users[account]\AppData\Local\SSIS\ScaleOut\Master folder.

    The Scale Out Worker runs the Scale Out Worker service to pull execution tasks from Scale Out Master. Then the worker runs the packages locally with ISServerExec.exe.
    The log file of the Scale Out Worker service is in the \<drive\>:\Users\[account]\AppData\Local\SSIS\ScaleOut\Agent folder.

    Please refer to Integration Services (SSIS) Scale Out Master and Integration Services (SSIS) Scale Out Worker.
    Best Regards,
    Mona

    0 comments