Tag Archives: Windows Server 2003

System Center Data Protection Manager 2012 R2 Operating System Support

As part of the planning stage for a System Center Data Protection Manager (SCDPM) 2012 R2 upgrade I found the support matrix for SCDPM 2012 R2.  The matrix shows that support for Windows Server 2003 and 2008 has been removed in the 2012 R2 release.

As I manage some SQL Servers that are running on Windows Server 2003 and 2008 I investigated the upgrade options.  Below is a short summary of the latest Windows OS version that is supported on various versions of SQL Server:

SQL Server 2005 supports up to Windows Server 2008 R2 as long as at least SQL 2005 SP3 is installed.

SQL Server 2008 supports Windows Server 2012 R2 as long as at least SQL 2008 SP3 is installed.

SQL Server 2008 R2 supports Windows Server 2012 R2 as long as at least SQL 2008 SP2 is installed.

SQL Server 2012 supports Windows Server 2012 R2 as long as at least SQL 2012 SP1 is installed.

Useful links:

Known issues installing SQL Server on Windows 7 or on Windows Server 2008 R2

Using SQL Server in Windows 8, Windows 8.1, Windows Server 2012 and Windows Server 2012 R2 environments

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