Login Failed for User.
Applies to: Microsoft SQL Server 2005 Enterprise Edition.
Error Message.
Examining the SQL Server Error Log we found the following records:
Date 10/8/2008 2:50:00 PM
Log SQL Server (Current - 10/8/2008 3:45:00 PM)
Source Logon
Message
Login failed for user 'DOMAIN\user account'. [CLIENT: 192.1681.1]
Cause.
On this case, the error occurred because a job was referencing a database that
no longer exists. The database was deleted, but the job was not eliminated.
Solution.
Identify the job, then delete or disable it.