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!
Best Answer
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.