Upgrading System Center Operations Manager 2007 R2 To 2012

I needed to upgrade System Center Operations Manager (SCOM) 2007 R2 running on Windows Server 2003 x64 with SQL Server 2005 to System Center Operations Manager 2012.  All SCOM components and SQL Server were installed on the same server.  These are the steps I followed.

  1. Upgrade the drivers and firmware on the server to the latest versions
  2. Backup the SQL databases
  3. Install SQL Server 2005 SP4
  4. Upgrade Windows Server 2003 x64 to Windows Server 2008 R2 SP1
  5. Install the server drivers for Windows Server 2008 R2
  6. Install  SCOM 2007 R2 Cumulative Update 6 (CU6), the latest available update at the time of writing http://support.microsoft.com/kb/2626076
  7. Follow the instructions to enable the SQL Server upgrade to work successfully http://technet.microsoft.com/en-us/library/dd789004.aspx.  This fixes the “No Custom Security Extensions” and “No Custom Authentication Extensions” errors when upgrading SQL Server.  For CU6, SRSUpgradeTool.exe can be found in C:\Program Files (x86)\System Center 2007 R2 Hotfix Utility\KB2449679\SupportTools\amd64
  8. Upgrade SQL 2005 to SQL 2008 R2
  9. Run the SRSUpgradeTool.exe PostSQLUpgrade step
  10. Run the SRSUpgradeHelper program step
  11. Install SQL 2008 R2 SP1
  12. Uninstall SQL 2005 Management Tools
  13. Follow the steps here to upgrade SCOM to 2012 http://technet.microsoft.com/en-us/library/hh205978
  14. Update SCOM 2012 to the latest update rollup, at the time of writing this is System Center Update Rollup 2 http://support.microsoft.com/kb/2706783
  15. Change the SCOM databases to run in SQL 2008 compatibility level http://support.microsoft.com/kb/2700028
  16. If you only have one Management Server, add the registry keys detailed here to fix the “The All Management Servers Pool has not reported availability” error http://support.microsoft.com/kb/2714482
  17. Add the license key to convert the evaluation edition to the full edition.  Run Set-SCOMLicense –ProductID <XXXX> from the Operations Manager Shell
  18. Restart the System Center Data Access Service on all management servers to pickup the license change