Can't run the scheduled SQL Agent Job?

Hi,

I'm tried to run the job that created from maintenance plan. It fail and give me the following message:

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

We are using the Windows Autheniciaton mode only and my id is set as sysadmin, setadmin, processadmin in the server roles.

I don't why I can't run the job, I check the SQL agent services is login using LOCALSYSTEM.

I try to the NT admin account to login the box, but still getting the same error message.

Any idea?

Thanks!

use a local login for the SQLAgent and try to schedule it again.|||

Hi,

What is local login? we only setup use the windows authenication mode for the sql server?

Thanks!

|||

this may help u : http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=102884&SiteID=1

change the owner of the job

Madhu

|||

Is the SQL Server machine in the same domain as the user mentioned in the error message?

The 0x5 error code means access denied - the DC doesn't allow you to query the user information. If there are different domains involved, you may need to set the trust between them.

Also, what did you say you tried at the end of your message? There is a word missing I think.

Thanks
Laurentiu