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:

  1. Go to SQL Server Configuration Manager
  2. Update SQL Server Agent to ‘Log On As’:  LocalSystem
    1. Note we will need to stop the SQL Server Agent first
SQL Server Configuration Manager

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/

Author

Write A Comment