A few bumps on the "Building SCOM SP1 Reporting Server" Road
We have a SCOM 2007 environment and initially it was a one server (RMS, OpsDB)environment. We upgraded it to SP 1 recently. Now we are adding two more servers for reporting purpose. One for the Data Warehouse and the other is for reporting server.
I follow the design and deployment guide. But when I was trying to create the DW DB on the Data Warehouse Server, I run into the below error:
“the setup wizard was interrupted before Operations Manager 2007 could by installed”
I was able to create DW DB by using the Database Configuration Wizard – I thought I was OK there!
Database Configuration Wizard
Then when I tried to install the reporting server – I got this error:
“Invalid Microsoft Operations Manager Dw database version
setup found that the Microsoft operation manager database version on the specified database server is not the same as the current product version”
I was goggling around and couldn't find the solution. I have to call Microsoft Support and they quickly identified the problem.
It turns out when I was installing the reporting component, since our SCOM server is already upgraded to SP1. I think it would be logic to use SP1 media to install the reporting part. But since there is no official SP1 media out yet. I used the Evaluation SP1 media and thought if it asks, I can put in our license information. I WAS WRONG ON THAT! That’s why I got those “Invalid DW database version” errors. What I need to do is to use the SCOM RTM media to install the reporting components and then use the SP1 Upgrade media to upgrade the reporting servers to SP1. I did all that and now my reporting server is UP and RUNNING!
Another thing I would like to point out is that you may see some Microsoft documentation or blog saying that for SQL 2005, the DW DB can be SP2 but the reporting service has to be SP1.
SQL SP
This is no longer the case, I guess may be the SCOM SP1 fixed that. Now all my Ops DB, DW DB and reporting DB are all running SQL 2005 SP2