Subscribe to this blog
SQL Server Blog Forum
My name is Muthukkumaran Kaliyamoorthy and I am living in India (Chennai). I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server, and I’m specialized in Administration and Performance tuning.
Archives: June 2012
Login failed for [SQLSTATE 28000] (Error 18456) the step failed
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.
Error:
Executed as user: Domain\XXX.Service. Login failed… Read more
0 comments, 2,498 reads
Posted in SQL Server Blog Forum on 18 June 2012