Upgrading SQL Server 2005 to SQL Server 2008

  • Article

Applies To: Operations Manager 2007 R2

Microsoft System Center Operations Manager 2007 R2 adds support for using Microsoft SQL Server 2008 for your databases. If you currently are using SQL Server 2005, you need to perform some steps on your Operations Manager 2007 data before and after you upgrade your SQL Server installation. Two tools are provided on the R2 installation media to facilitate the upgrade. These tools are also included in SP1 update rollup 971541 (https://go.microsoft.com/fwlink/?LinkID=167911) if you are upgrading from SQL Server 2005 to SQL Server 2008 with Operations Manager 2007 SP1. Use the following steps.

Warning

These steps apply to upgrading to the RTM version of SQL Server 2008. Do not upgrade to SQL Server 2008 with SP1 or to SQL Server 2008 with SP2 until after you have completed all of these steps.

To upgrade from SQL Server 2005 to SQL Server 2008

  1. Run the SRSUpgradeTool program. This tool saves and restores three configuration files that were modified during Operations Manager 2007 Reporting installation. Run the following command from a command prompt: SRSUpgradeTool.exe /InstanceName:<InstanceName> /Action:PreSQLUpgrade

    Where <InstanceName> is the name of the SQL instance that houses the SQL Reporting Services database. If you used the default instance name, you can use MSSQLSERVER.

  2. Restart the SQL Server Reporting Services service, and verify the configuration by using Reporting Services Configuration Manager.

  3. Upgrade the SQL Server 2005 installation to SQL Server 2008, using the procedures outlined in the SQL Server 2008 product documentation.

    Warning

    Do not upgrade to SQL Server 2008 SP1 until after you have completed these steps.

  4. Run the SRSUpgradeTool program again to update the registry entries for Operations Manager 2007 Reporting to point to the new SQL Server Reporting Services location. Run the following command: SRSUpgradeTool.exe /InstanceName:<InstanceName> /Action:PostSQLUpgrade

  5. Run the SRSUpgradeHelper program to move the Operations Manager Reporting files to the new SQL Server Reporting Services directory and to set the SQL Server Reporting Services configuration. Run the following command: Msiexec /i SRSUpgradeHelper.msi DATAREADER_DOMAIN=Lab DATAREADER_USER=momsdk MGSERVER=cRMS SRS_SERVER=cSRS\instance1

Important

After you complete the upgrade to SQL Server 2008 you must apply SQL Server 2008 SP1. Operations Manager 2007 R2 requires SQL Server 2008 SP1.