Logon Failures in the Application Event Log
Remember this if you ever have to delete a MOSS Shared Services Provider database.
Originally posted at: http://mosschampions.com/blogs/moss/archive/2006/12/22/Cleanup-task-if-you-delete-a-Shared-Services-DB.aspx
Cleanup task if you delete a Shared Services DB
I just noticed on our SQL back end server an error occurring every minute for the SQL service account trying to access a no longer existing SSP DB. The error was a "Logon Error: 18456, Severity: 14, State: 16". Although the error is not actually affecting anything it does fill up the logs (both SQL and Application) so you may miss something important as a result.
These are caused by a SQL job scheduled every minute to delete expired sessions. It appears this gets created but never gets deleted (or even disabled) if you remove that database. Just delete or disable it from the Management Studio at \SQL Server Agent\Jobs.