(http://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. Caution 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 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. Caution Do not upgrade to SQL Server 2008 SP1 until after you have completed these steps. 4. Run the SRSUpgradeTool program 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=cRMS\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.
(http://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. Caution 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 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. Caution Do not upgrade to SQL Server 2008 SP1 until after you have completed these steps. 4. Run the SRSUpgradeTool program 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=cRMS\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.
OM2007R2_UpgradeGuide.docx