SQLSTATE 42000- Error 15404 with ADS

Hello,

I'm having trouble running jobs with my active directory (ADS) account. I've setup my SQL services to run under an ADS account, but jobs cannot seem to query ADS for user information. We're running Windows Server 2003 and SQL Server 2005 SP2.

Here is the error message:

==

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

==

also this message in log:

==

[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'ADS\me, error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

==

I already tested the suggested:

execute as login='ads\me' and I get the same error on both (my local installations and production)

appreciate your help

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.

-Raul Garcia

SDE/T

SQL Server Engine

I have been receiving the same error - only intermittently. Popped up after installing SP2 on SQL 2005. For example a job that runs every ten minutes failed at 6:10, worked until 7:30 and then failed. Received the same error on both - Unable to determine if the owner of job... has server access (reason: Could not obtain information about Windows NT group/user 'ad\user', error code 0xea [SQLSTATE 42000] (Error 15404)

The ad account had administrator access on the server and in SQL. The service account also has administrator access.

Thanks for any help,

Sandy