ERROR SQLSTATE 42000 Error 15404

Question

Out of the blue I started getting this error trying to run a SQL Agent job:

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

The SQL Agent service IS running as a domain user, which IS a member of Domain Users.  This job has run fine dozens of times and no domain changes have been made (other than retiring an old DC).  If I change the owner to SA, the job runs fine.  There appears to be a very serious bug in the wal SQL Server 2008 tries to verify domain accounts.

Answer 1

Hi,

From Raul Garcia in the other thread: http://social.msdn.microsoft.com/Forums/en-IE/sqlsecurity/thread/9dddf08e-929c-43b4-bc10-ac8f36cbb023
-----------------------
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.

---

ChunSong Feng
Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 2

Already checked this out, SQL Agent is already running as a domain account per my post

Answer 3

I believe that ChunSong Feng was talking about the SQL Server service account, not SQL Agent, running as a domain account,. 

RLF

Answer 4

Hello,

Better you configure your SQl server and SQL Server Agent with two separate account.

Thanks

Thanks

Regards,
RM Thirunavukkarasu MCP, MCITP
http://www.thiruna.blog.com

Answer 5

In this case, you can create a job with the SQL agent service account as job owner and JOb steps can use AD account to run the job steps. This will resolve the problem.

---

---

Thanks Ayyappan Thangaraj, http://SQLServerRider.wordpress.com