Just a heads up to those who plan on upgrading to Ops Mgr R2 – you may run into an error while going through the Prerequisite checker:
Problem: Preq checker for Ops Mgr R2 upgrade fails if upgrading the OpsMgr DW, and Reporting Services. Preq Checker reports that the SQL Service instance names were not available.
Cause: Still looking into why this is happening.
Resolution: Reinstall SQL 2005 SP3 and re-run the Preq Checker.
Hope this helps other’s out there that may run into a similar error or situation.