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

http://www.sharepointassist.com/2009/04/19/login-failed-for-user-nt-authoritysystem-client/

Problem

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

clip_image001

Errors often occur every minute

clip_image002

Explanation

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.

Solution

  • 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.
    Advertisements
  • 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 )

    Twitter picture

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

    Facebook photo

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

    Google+ photo

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

    Connecting to %s