Solved

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)).

Posted on 2010-11-16
4
2,795 Views
Last Modified: 2012-05-10
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
Comment
Question by:basaral
  • 3
4 Comments
 
LVL 8

Accepted Solution

by:
dba2dba earned 500 total points
Comment Utility
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
 
LVL 1

Author Comment

by:basaral
Comment Utility
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
 
LVL 1

Author Comment

by:basaral
Comment Utility
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
 
LVL 1

Author Closing Comment

by:basaral
Comment Utility
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

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now