SQL connection using incorrect account
Article ID: 259196
Updated On:
Products
Issue/Introduction
Unable to start SQL agent from service manager or Administration perspective Start option
Service Manager log shows the following:
U00022021 Logon of user 'someuser' to domain 'DOMAIN' successful.
U00022029 Cannot load the user profile, error code: '5'
Access is denied
U00022030 Cannot load environment variables, error code: '5'
Access is denied
U00022008 Could not start process 'AGENT_NAME'. Error Code '1314'.
A required privilege is not held by the client
Environment
Release : 21.0.4
Resolution
The error message 1314 is usually something we see with Windows agents when jobs are run and we have to add the following local security policy privileges explicitly for that user (adding to the Administrator group is not enough):
Act as part of the operating system
Adjust memory quotas for a process
Back up files and directories
Log on as a service
Replace a process level token
Restore files and directories
Turn off UAC completely and restart the server. Once we did this, the agent was able to start from the service manager dialog and run jobs correctly.
Feedback
