November 9, 2017 at 6:17 pm
I have created SQL Agent proxy accounts to execute sql jobs but for reason it fails in SQL 2016. I know it's related to permission but unable to resolve this issue.
1.Created credentials.
2. Created proxy account and assigned sub system object level permissions.
3. The SQL Agent proxy account does have appropriate db level and msdb database permissions.
4. Local Security policy - Permissions were granted to 5 object level.
All these steps worked in SQL Server 2008 R2 but not in SQL 2016.
Have anyone seen this issue ?
The error message :
executed by user: ad-ent\app_account_name. The process could not be created for step 1 of job OXCEFC822D11F1A4458DICCCDDFF558F(reason : A required privilege is not held by the client). The step failed.
November 9, 2017 at 8:18 pm
I got it working ?? Thanks!
Looks like it was permission related to SQL Agent service account. These below steps were taken :
1. Set the SQL Server Agent service account in SQL Configuration manager to the local system account.
2. Stop and then start the SQL Agent service.
3. Reset the account back to the original SQL Agent service account.
4. Stop and then Start SQL Server Agent service.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply