Problem

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



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"



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



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

Popularity: 62% [?]