When setting up an SSIS package to run on a schedule in SSMS there is a chance there is an error around which user is running the script. To fix this we will do the following:
- Go to SQL Server Configuration Manager
- Update SQL Server Agent to ‘Log On As’: LocalSystem
- Note we will need to stop the SQL Server Agent first
That’s it – after this change the scripts should run without any issues!
For more on the SQL Server Configuration Manager: https://learn.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-ver16
Keep reading about D365 tips and tricks here: https://markedcode.com/index.php/category/d365/
