When installing chef as a scheduled task on Windows 2012r2 it creates it for the system account. When executing a database restore using powershell scripts it keeps failing. If we change the user in the scheduled task to Administrator and run the powershell script it works.
Is there a fix for this so we can leave the user as system?
Are you saying you have a chef created scheduled task that is doing a database restore? If so, you’ll want to change the user: https://docs.chef.io/resource_windows_task.html#properties
If you want the script to run as SYSTEM, then you’ll need to tell your database that you’re allowing the computer account to modify it. I’m assuming this is against a Windows database.
If you include a paste of the code, I can try to offer more help.
thanks for the reply. The developer is going to try that. Ill update when we run it.