Since the release of CU3 for SCOM 2007 R2, users might be confused about the exact support matrix for running SCOM 2007 R2 databases on SQL Server. Since our database team is, let’s say “very responsive” and tend to install Service Packs very quickly after their release and sometimes even without notifying the service owner, this might get a bit messy with the release of SP2 for SQL 2008.
CU3 for SCOM 2007 R2, as stated here http://support.microsoft.com/kb/2425714 supports the following:
- New installations of SCOM 2007 R2 with CU3 are supported to run on SQL 2008 R2
- Existing installations of SCOM 2007 R2 without CU3 are supported to run on SQL 2008 SP1
CU3 for SCOM 2007 R2 does NOT support:
- Existing installations of SCOM 2007 R2, even with CU3 installed, the upgrade of the SQL backend systems (OperationsManager, OperationsManagerDW and Reporting Services) from SQL 2008 to SQL 2008 R2 are NOT supported
- It is also NOT supported to install SP2 for SQL 2008 on all the SQL backend systems!
According to MS, the support for the two missing scenarios above will come with CU4.