SQL Server 2019 Service account Local Activation permission

 

1. Run Dcomcnfg.exe. Dcomcnfg.exe provides a user interface for modifying certain settings in the registry.
2. In the Component Services dialog, expand the Component Services > Computers > My Computer > DCOM Config node.
3. Right-click Microsoft SQL Server Integration Services 15.0, and then click Properties.
4. On the Security tab, click Edit in the Launch and Activation Permissions area.
5. Add users and assign appropriate permissions, and then click Ok.

• NOTE: You'll need to do this for the job proxy account(s) used for each SSIS job step that has a dependency on the legacy service, or for the SQL Server Agent service account if there are any SSIS job steps with such a dependency that do not use a proxy account.

6. Repeat steps 4 - 5 for Access Permissions.
7. Restart SQL Server Management Studio.
8. Restart the Integration Services Service.

https://dba.stackexchange.com/questions/292620/sql-server-2019-service-account-local-activation-permission