SQL Server Performance

job failed due to Login Failed.

Discussion in 'SQL Server 2008 General DBA Questions' started by kumaravel v, Mar 3, 2009.

  1. kumaravel v New Member

    Hi
    This is not SSIS.

    This job contains my stored procedure (USP_CalculateDataCapture) which is running in management studio without any problem when
    i run seperately.

    EXEC USP_CalculateDataCapture @DCId = 2

    but the same, when i run it through job which is not working. it gives the below error message.

    Message
    Executed as user: NT AUTHORITYSYSTEM. Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. [SQLSTATE 28000] (Error 18456). The step failed.

    Kindly let me what should i do to solve this error!
    kumaravel v, Mar 3, 2009
    #2

  2. satya Moderator

    Please do not post duplicate post for same problem, refer to your other thread for replies. This is locked.
    satya, Mar 3, 2009
    #3

Share This Page