Archives: June 2012
Login failed for [SQLSTATE 28000] (Error 18456) the step failed
When you query the data from another SQL server (Linked server) and SQL server agent run as a domain user. You may get the error following error message in your job history.
Executed as user: Domain\XXX.Service. Login failed… Read more