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:
 SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'ADS\me, error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
I have done a *lot* of searching and cannot find the solution. I believe the 0x5 code is access denied.ÃÂ
The same job runs if I change the owner to a SQL login that's not an ADS account.
I'm not certain how to confirm that the SQL Agent account is the account actually querying ADS, also.
Any help would be greatly appreciated!