Home » Microsoft Operations Manager 2005 » KB Article 922332


Welcome to contoso.se! My name is Anders Bengtsson and this is my blog about Azure infrastructure and system management. I am a senior engineer in the FastTrack for Azure team, part of Azure Engineering, at Microsoft.  Contoso.se has two main purposes, first as a platform to share information with the community and the second as a notebook for myself.

Everything you read here is my own personal opinion and any code is provided "AS-IS" with no warranties.

Anders Bengtsson

MVP awarded 2007,2008,2009,2010

My Books
Service Manager Unleashed
Service Manager Unleashed
Orchestrator Unleashed
Orchestrator 2012 Unleashed
Inside the Microsoft Operations Management Suite

KB Article 922332

Article 922332: How to move Microsoft Operations Manager 2005 Reporting together with the MOM Reporting database to a different computer.

Article 9223322 is about moving the SystemCenterReporting database to a new machine. In general that KB is enough, but I would like to add some information.

During step 1 you should write down all permissions that you have in your reporting console. Also document all extra SQL permissions that you have setup, for example permissions to dev department. Step 1 describe how you should use RptUtil.exe to export reports. SQL 2005 is require higher XML security so most of your SQL 2000 reports will not work in SQL 2005. There is a KB about this KB919598 too. If you don’t get reports to work with the latest MP version you can call Microsoft Product Support Services and ask them to send you latest report version.

During step 4 you are told to install MOM 2005 reporting on the target machine. To make sure MOM 2005 don’t think the old machine still is the reporting server you can run the following query in the OnePoint database “SELECT * FROM reportingsettings”. If MOM 2005 thinks there is two reporting servers you will get problems when importing reports. They will be imported but never show up in reporting console.

Be sure that you export your custom made reports during step 1, you can import them in reporting console after step 8.

Don’t forget to write down all subscriptions too. If you use subscriptions you will have to setup SMTP again.

Configuring a Report Server for E-Mail Delivery

How to move Microsoft Operations Manager 2005 Reporting together with the MOM Reporting database to a different computer

When you try to import a Microsoft Operations Manager 2005 report file, the import process fails

1 Comment

Comments are closed.