SCOM 2012 – Operational Database not upgraded to meet the minimum CU requirement

While upgrading an System Center Operations Manager 2007 (SCOM 2007) environment running on Windows Server 2003 to System Center Operations Manager 2012 (SCOM 2012) running on Windows Server 2008R2 i ran across a problem with the install. It said:

The Operational Database  has not been upgraded to meet the minimum Cumulative Upgrade requirement.

The resolution, according to the setup itself, would be to upgrade the database to the required Cumulative Upgrade version. I know i did just that. I installed CU6 on my machine. But.. i didn’t read the whole documentation regarding the upgrade. The documentation clearly states that there are some manual actions required to upgrade the SQL database(s).

On my Windows 2008 SQL server i opened Microsoft SQL Server Management Studio and double clicked databases after i logged in. There i went to the OperationsManager database and ran a query that was on my old Root Management Server (RMS).

I did the same for the OperationsManagerDW database.

Please be aware that you have to use the correct query for the database you execute it on.

When you rerun the prerequisites checker in the SCOM 2012 setup you will see the error is gone.

I hope this was informative for you.

If you like this post please support phits.nl. Thanks!