Today I ran into this issue: Data Warehouse failed to enumerate database components to be deployed. Failed to enumerate Data Warehouse components for deployment. The operation will be retried. Exception 'SqlException': Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Component Instance name: scom.be Instance ID: {AC6FACD9...(read more)

Read the complete post at http://scug.be/blogs/scom/archive/2009/05/10/opsmgr-data-warehouse-failed-to-enumerate-database-components-to-be-deployed.aspx