plssssssssss help

[harrycool22]

IM facing this unusual problem. I had a job scheduled on my server. But past couple of days the job is getting failed. The error which i get is "Login failed for user 'NT Authority\Anony mous Login' [SQLSTATE: 28000] [Error 18456]"


I've checked the BUILT\ADMINISTR ATOR its present. Ive checked the right for NT Authority\Anony mous and its sysadmin. can any one suggest how should i get rid of this error. Pls mail me at [b]mail id removed[b]/

[ck9663]

Who owns the job?

-- CK

[harrycool22]

Who owns the job?

-- CK

The owner of the job is
owner= sa

[harrycool22]

the owner of the job is SA. i've also deleted he linked server and added it once again. But no success.can u help me out?

[deepuv04]

IM facing this unusual problem. I had a job scheduled on my server. But past couple of days the job is getting failed. The error which i get is "Login failed for user 'NT Authority\Anony mous Login' [SQLSTATE: 28000] [Error 18456]"


I've checked the BUILT\ADMINISTR ATOR its present. Ive checked the right for NT Authority\Anony mous and its sysadmin. can any one suggest how should i get rid of this error. Pls mail me at [b]mail id removed[b]/

Hi,
Is there any change in user password of the user BUILT\ADMINISTR ATOR, if the password is changed, go to job properties and give the new login details in (run as section) probably will help you.

thanks