SCOM Trick 17 – SCOM 2007 R2 and SQL 2008 R2

A question that comes up a lot is whether SQL 2008 R2 is supported for SCOM 2007 R2 and what to do while installing a new SCOM installation on that version of SQL.
If you do a fresh installation of SCOM on a SQL 2008 R2 you will find that you cannot connect to the SQL server. It will refuse to install the database component. In that case you will have to use the dbcreatewizard to create the databases (for operationsmanager and operationsmanagerdw databases).
Support for System Center Operations Manager 2007 R2 that runs on a SQL Server 2008 R2 database
Also you will first need to go to SQL 2008 R2 with CU5 or higher. Watch this post from Kevin pointing at the issues and fixes:
When upgrading from SQL 2008 SP1 to R2 version you might refer to this posting from Marnix:
And a posting from my friend Walter Eikenboom with videos:

Back to the SCOM Tricks general list