SQL connection using incorrect account
search cancel

SQL connection using incorrect account


Article ID: 259196


Updated On:


CA Automic Workload Automation - Automation Engine CA Automic One Automation


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


Release : 21.0.4


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.