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.
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
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.
- Upgrade the drivers and firmware on the server to the latest versions
- Backup the SQL databases
- Install SQL Server 2005 SP4
- Upgrade Windows Server 2003 x64 to Windows Server 2008 R2 SP1
- Install the server drivers for Windows Server 2008 R2
- Install SCOM 2007 R2 Cumulative Update 6 (CU6), the latest available update at the time of writing http://support.microsoft.com/kb/2626076
- 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
- Upgrade SQL 2005 to SQL 2008 R2
- Run the SRSUpgradeTool.exe PostSQLUpgrade step
- Run the SRSUpgradeHelper program step
- Install SQL 2008 R2 SP1
- Uninstall SQL 2005 Management Tools
- Follow the steps here to upgrade SCOM to 2012 http://technet.microsoft.com/en-us/library/hh205978
- 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
- Change the SCOM databases to run in SQL 2008 compatibility level http://support.microsoft.com/kb/2700028
- 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
- Add the license key to convert the evaluation edition to the full edition. Run Set-SCOMLicense –ProductID <XXXX> from the Operations Manager Shell
- Restart the System Center Data Access Service on all management servers to pickup the license change