Login Failed For User ‘NT AUTHORITY\SYSTEM’. [CLIENT: ]



You receive hundreds if not thousands of NT Authority\SYSTEM “Login failed for user ‘NT AUTHORITY\SYSTEM’. [CLIENT: <local machine>]” error messages


Errors often occur every minute



You’ve probably deleted your Shared Service Provider or created a new one. Unfortunately, some scheduled jobs will remain on your SQL server that reference the now defunct database.


  • Launch SQL Server Management Studio and connect to the server that houses your Shared Service Provider
  • Within SSMS expand the SQL Server Agent and select jobs.
  • Locate the jobs that have names that end in “_DeleteExpiredSessions”
  • clip_image003

  • You in the “Steps” tab double click on the first step and check to see if there’s a database, if there’s no database selected you’ve probably deleted said database so you can safely disable the job.
  • clip_image004

  • If you don’t understand these instructions or are confused then STOP! Disabling SQL jobs is dangerous business and can cause undesired outcomes.
  • Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out /  Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out /  Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out /  Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out /  Change )


    Connecting to %s