Solved

Unable to determine if the owner of job has server access

Posted on 2010-09-16
3
1,022 Views
Last Modified: 2012-05-10
the owner of this job is in 'BUILTIN\Administrators', and yet the job fails.

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

is this a problem with OS setting?

thanks
0
Comment
Question by:anushahanna
3 Comments
 
LVL 9

Assisted Solution

by:jerrypd
jerrypd earned 150 total points
ID: 33694464
the owner looks like SRBSV\jimw, not administrators... that is a group...
does JimW have access to the system at this level?
0
 
LVL 3

Accepted Solution

by:
jetpowercom earned 350 total points
ID: 33694474
From an MS SQL forum moderator on that error message:

"Most likely the machine account doesn’t have permission to query the AD.

I would recommend requesting access to the AD administrator or change SQL Server and run the service as a low-privileged domain account that has proper permissions on the AD."
Also, this link to another SQL forum _may_ be useful:

Lastly, here's one from a dba forum:

Hope this helps!
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33816272
Thanks for the helpful pointers.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

705 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

21 Experts available now in Live!

Get 1:1 Help Now