Post reply

Login Failed for User. Error 18456

  • August 2, 2011 at 2:50 pm

    #241007

    Hello Everyone,

    I am using sql server 2005.

    Following is the error i see in my error logs every 20secs

    Login Failed for user 'NT AUTHORITY\SYSTEM'. [client:IP]

    error:18456 severity:14 state:16

    Its default database is master.

    Any idea why i am receiving this error even if the default database is online and accessible.

    Also the login had sysadmin privilege

  • August 2, 2011 at 3:01 pm

    #1362663

    Is the default DB set to auto_close or auto_shrink?

  • August 3, 2011 at 6:49 am

    #1362996

    No. Both the options are set to false.

  • August 3, 2011 at 6:53 am

    #1363002

    No other idea for this one... stepping aside.

  • August 3, 2011 at 8:39 am

    #1363106

    I figured out the issue.

    I have a sql job that is running every 20 sec. And the job has to execute tsql command against a database which is deleted some time ago. As its not able to find the db the job is failing.

    I am getting this login failure error because the sql server agent is running under local system,.

    when i disable the job I don't see the error any more.

  • August 3, 2011 at 8:43 am

    #1363111

    Tx for the feedback.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply