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.

OpsMgr R2 Preq Checker Error

OpsMgr R2 Error Preq Checker 02

Hope this helps other’s out there that may run into a similar error or situation.