Failure Audit message in SQL Server - Event ID: 18456 every minute? This is a event log error I have seen in Project Server 2007 on various farms going right back to the Beta and I finally found some time to track it down. It didn't seem to be breaking anything on my server, but made it difficult to read the logs and see other "important" stuff. This is the error: Event Type: Failure Audit Event Source: MSSQLSERVER Event Category: (4) Event ID: 18456 Date: 1/17/2008 Time: 1:29:00 PM User: DOMAIN\User Computer: SERVERNAME Description:Login failed for user 'DOMAIN\user'. [CLIENT: ] I did a SQL Profiler trace to see where it was coming from and discovered the cause was a SQL Server Agent job called SharedServices_DB_Job_DeleteExpiredSessions that was running every minute. The reason for the failure was that I did not have a SharedServices_DB on that server. I did once - but my test server gets changed around a fair bit and this was a remnant that didn't get clean