March 12, 2019 at 7:14 am
Hi
We are using SQL 2016 and just recently ( last two week) the jobs created by Maintenance plans to delete old bak-files fails with this error:
" Executed as user: NT Service\SQLSERVERAGENT. The process could not be created for step 1 of job 0xDD36461A167E074EBB758BD23B9E5BD1 (reason: Access is denied). The step failed."
I haven´t change anything and it has been working before.
I have added NT Service\SQLSERVERAGENT to the bakup-folder with full access but no difference.
What could be the cause to this ?
With regards
Jonas
March 13, 2019 at 2:59 pm
Just a small insight, if its saying that the process could not be created.. I don't think its access to the operating system folder thats the issue, its access within the sql server, are you sure the SQL Server Agent/Engine hasn't been reconfigured to use a different account?
March 13, 2019 at 5:11 pm
Give the account Sysadmin rights aswell.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply