The Operations Manager 2007 audit collector service encountered a fatal error while attempting to perform a database operation. ...

The Operations Manager 2007 audit collector service encountered a fatal error while attempting to perform a database operation. The Operations Manager Audit Collector service is unable to continue operation and is stopping.
 Please check the log for previous events describing the nature of the problem.
 To restore the collector to operation, you must troubleshoot Microsoft SQL Server or the Microsoft SQL data access components to find the cause of the error and resolve it, then restart the collector service.