SharePoint 2007 SQL Server Failure Audits in Event Log

Q. Are your event log's getting full of SQL Server Failure Audits for a service account or database access account you have created for MOSS?

Q. Have you also re-installed MOSS?

If you have answered yes to both of the above questions then you will have SQL Server Agent Jobs that are associated with old Shared Services databases running.

To resolve this

1. Open SQL Server Management Studio.
2. Expand SQL Server Agent.
3. Expand Logs.
4. Open the current log and look at the messages.
5. You should see error messages like: Cannot open database "SharedServices3_DB" requested by the login. (see figure 1).
6. Expand Jobs.
7. You should see jobs named in the following format "[SSP]_[DB]_DeleteExpiredSessions" for example: SharedServices1_DB_Job_DeleteExpiredSessions" (see figure 2).
8. Disable the jobs that don't relate to current Shared Services databases.
9. Verify that the failure audits are no longer logged.
10. Delete the disabled jobs.

Figure 1:



Figure 2:



Hope you find this helpful, it took ages to track the culprit down.