By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,363 Members | 2,440 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,363 IT Pros & Developers. It's quick & easy.

plssssssssss help

P: 3
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\Anonymous Login' [SQLSTATE: 28000] [Error 18456]"


I've checked the BUILT\ADMINISTRATOR its present. Ive checked the right for NT Authority\Anonymous and its sysadmin. can any one suggest how should i get rid of this error. Pls mail me at [b]mail id removed[b]/
May 22 '08 #1
Share this Question
Share on Google+
4 Replies


ck9663
Expert 2.5K+
P: 2,878
Who owns the job?

-- CK
May 22 '08 #2

P: 3
Who owns the job?

-- CK
The owner of the job is
owner= sa
May 23 '08 #3

P: 3
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?
May 23 '08 #4

deepuv04
Expert 100+
P: 227
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\Anonymous Login' [SQLSTATE: 28000] [Error 18456]"


I've checked the BUILT\ADMINISTRATOR its present. Ive checked the right for NT Authority\Anonymous 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\ADMINISTRATOR, if the password is changed, go to job properties and give the new login details in (run as section) probably will help you.

thanks
May 23 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.