Microsoft announced that the Supported Configurations for System Center Operations Manager 2007 R2 has now been updated to support SQL Server 2008 SP2. The following rolls are now supported on SQL Server SP2:
- Operations Manager database
- Data Warehouse database
- Audit Collections database
Note: When using SQL 2008 Service Pack 2, reports will only run correctly from the Operations Console. Running reports directly from SQL Reporting Services will not render correctly. This is a known issue that will be corrected in a future Cumulative Update.
More Info: Supported Configurations Statement