• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3549
  • Last Modified:

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

MS SQL 2008

Both my "SQL Server" and "SQL Server Agent" services are running under 'DOMAIN\SQLServiceAccount'

Within the DB, I have 'DOMAIN\SQLUserAccount' with sysadmin rights.

I created a backup job where DOMAIN\SQLUserAccount is the job owner.

When I run the job, I get he following:

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

Any ideas?
0
basaral
Asked:
basaral
  • 3
1 Solution
 
dba2dbaCommented:
I have faced this issue in the past.

Looks like the server lost the comunication with the Domain Controller .. so the user authontication on DC server is not found ... so the job failed.

Please validate if the Server is able to communicate with Domain Controller.

Thanks,
0
 
basaralAuthor Commented:
I did try rebooting the server.  I can ping the domain controller from the DB serevr.  All of the SQL services started.  I was able to connect to the database engine using a domain login.  But the job still fails.  
0
 
basaralAuthor Commented:
Should my service account have any special permissions to query the domain controller?  

If I start the services with a domain admin, I don't have this issue.  If I start the services with a domain user, this is when I see the error.  
0
 
basaralAuthor Commented:
Although dba2dba's solution was not my exact case, I appreciate their time to respond to my problem.  I am closing the ticket due to lack of additional feedback.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now