How to move the Operations Manager 2007 Reporting Server

1.Stop all services on RMS and MS servers
a. On opsmgr-rms2 stop the following

•  Opsmgr config
•  Opsmgr sdk
•  Opsmgr health

b. On opsmgr-ms2 stop the following

•  Opsmgr heatlh

2.Backup OperationsManagerDW Opsmgr-sql1
a. Backup to the following location
D:\restore\OperationsManagerDW.bak

3. On the current Operations Manager Reporting Server computer, uninstall the Operations
Manager Reporting Server component as follows:
a. Click Start, click Control Panel, and then click Add or Remove Programs.
b. In the Add or Remove Programs dialog box, select System Center Operations
Manager 2007 Reporting Server, and then select Change.
c. In the System Center Operations Manager 2007 Reporting Setup Wizard, on the
Operations Manager 2007 Maintenance page, select Modify, and then click Next.
d. On the Custom Setup page, configure the Reporting Server component with the
This component will not be available option.
e. Complete the wizard

4.restore the OperationsManagerDW opsmgr-sql1
a. On SQL1 open SQL Server Management Studio

• In the left Colum Expand opsmgr-sql1 and right click on databases
• Select restore database
• Source for restore (do this before setting destination)

1. Select "From device" click on the navigate button on the right
2. Select file for Backup Media and say add
3. Navigate to D:\Restore and select OperationsManagerDW.bak and say ok twice
4. Select the most recent backup and say ok.
.Destination for Restore
1. Click on the dropdown arrow beside "To database"
2. Select OperationsManager
3. Place a checkmark beside OperationsManagerDW-Full Database Backup
4. Click on OK
5. Progress is shown in the bottom left corner. When complete there will hopefully be a successful window     popup. Say ok.
6. You are done restoring the database

5.Update the OperationsManager DatabaseTable
With the New Database Server Name, ensure that the account
that you are logged on with has sufficient privileges on the SQL
Server instance.
a. Open SQL Server Management Studio.
b. Expand Databases, OperationsManager and Tables.
c. Right-click dbo.MT_ManagementGroup, and then click Open Table
d. Change the value in the
SQLServerName_6B1D1BE8_EBB4_B425_08DC_2385C5930B04 column to reflect the
name of the new SQL Server-based computer.
e. Save your change.

6. Restart all services on RMS and MS servers
a. On opsmgr-rms2 stop the following

• Opsmgr config
• Opsmgr sdk
• Opsmgr health

b. On opsmgr-ms2 stop the following

• Opsmgr heatlh

7.Install Reporting services Opsmgr-rpt1
a. run SetupOM.exe from the opsmgr install source
b. On the System Center Operations Manager 2007 Setup page, select Install Operations Manager 2007 Reporting.
c. In the System Center Operations Manager 2007 Reporting Setup Wizard, on theCustom Setup page, configure only the Reporting Server component for installation.
Configure the Data Warehouse component with the This component will not be available option.
d. Enter the root manager server name opsmgr-rms2
e. SQL Database instance: opsmgr-sql1
f. Data Warehouse Write Acount

• Mom-dw-write
• Password same as action account

g. Data Warehouse Read Acount

• Mom-dw-read
• Password same as action account