On one of my SQL servers my event log is filled with errors SQL Server Agent to login due to error per minute:
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
User: CORP \ Usr_SQLServerAgent
Computer: SLQ1
Description:
Login failed for user 'DOMAIN \ Usr_SQLServerAgent'. [CLIENT: <local machine>]
In SQL Server, go to SQL Server Agent and right click on Job Activity Monitor, then click View Job Activity. You should see a job failure, one that causes the error login.
To get rid of the errors simply right click on the job in question and click Disable Job.
Tags: SQL Server 2005










