Sql server Blog Forum Helping SQL server DBAs and Developers


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 service is 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 for user ' SSBF\SQL.Service '. [SQLSTATE 28000] (Error 18456).  The step failed.


Step 1: Check the source SQL server agent logon service account name

All programs --> SQL server 2008 --> Configuration Tools --> SQL server configuration manager. Go to the SQL server agent  --> properties --> Check the logon tab and find the account name.

Step 2: Check the same is available in the target SQL server.

Under the security tab -->logins.  If it’s not available add the domain user with necessary permission on your target machine.

I hope this will help someone.

Muthukkumaran Kaliyamoorthy

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. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

More Posts