We have been getting the following error appearing in our production SCOM 2007 R2 installation for the last week or 2.
OleDb Module encountered a failure 0x80004005 during execution and will post it as output data item. Unspecified error : Login timeout expired Workflow name: Microsoft.SystemCenter.SqlBrokerAvailabilityMonitor
I’ve found the following post from a guy in Belgium, which describes his SQL Service Broker as not enabled, with screenshots to go along with the article showing what to do. See it here.
This TechNet article also describes best practice SQL settings for Ops Manager
In our case however, the SQL Broker service is actually running. SQL Management Studio on the SQL server hosting the Ops Manager database also shows no warnings or errors in it’s logs for the same time.
The investigation continues…