Check the below link, likely a security issue, the user that runs the job needs http://www.sqlserverblogforum.com/2012/06/login-failed-for-sqlstate-28000-error- .