Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I had created a SQL Server Job that throws the error that is mentioned in the question itself. I have searched in Google for same and everywhere its about giving rights/permission but not sure from where to give the same or how to give that?

My SQL Server 2008 Account info

Username: (local)

Authentication: Windows

No Password is needed

Thanks!

share|improve this question
add comment

1 Answer 1

Try to set the job owner to sa user. For me it works all the time. There is a known security problem when the SQL Server can't check the Windows users's credentials. Look here for some guideline about the issue.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.