SQL Server jobs failling with below error.
The job failed. Unable to determine if the owner (domain\user) of job test has server access (reason: Could not obtain information about Windows NT group/user ‘domain\user’, error code 0x5. [SQLSTATE 42000] (Error 15404)).
From SQL agent logs we see below errors
2011-02-25 01:00:00 – ! [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user
1. ADD the SQL Agent service account to the Pre-Windows 2000 Compatible Access Group
2. If SQL Server is running under localsystem add the computer object to the domain group “Pre-Windows 2000 compatible access”
3. verify if xp_logininfo ‘domain\user’ is successful.
4. Make sure account is not locked