[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
SQL Server Agent error code 0x5 Error 15404

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

SQL Server Agent error code 0x5 Error 15404.


Applies to: Microsoft SQL Server.

Date created: March 12, 2020.
 

Problem Description.
 

A SQL Server administrator was receiving the following error on SQL Server Management Studio when he setup a new job on SQL Server Agent and tries to run it.

Message
The job failed. Unable to determine if the owner (DOMAIN\USERB) of job OppInfo has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\USERB', error code 0x5. [SQLSTATE 42000] (Error 15404)).

 

Cause.


Error 0x5 means access denied. This error is related to lack of permissions.

 

Solution.


Try to change the owner of the jobs to the "sa" account, on the properties of the job.

If the above does no help, please change the service account for the SQL Server agent service to an account with proper permissions. This may be happening because the service account for SQL Server Agent service is a local account. Try starting the service with a domain account.

 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.