{"id":75,"date":"2006-08-11T08:20:31","date_gmt":"2006-08-11T06:20:31","guid":{"rendered":"http:\/\/contoso.se\/blog\/?p=75"},"modified":"2006-12-29T12:47:51","modified_gmt":"2006-12-29T10:47:51","slug":"artikel-922332","status":"publish","type":"post","link":"http:\/\/contoso.se\/blog\/?p=75","title":{"rendered":"KB Article 922332"},"content":{"rendered":"<p><strong><a href=\"http:\/\/support.microsoft.com\/?id=922332\">Article\u00c2\u00a0922332<\/a>: How to move Microsoft Operations Manager 2005 Reporting together with the MOM Reporting database to a different computer<\/strong>.<\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 10pt\"><font face=\"Calibri\" size=\"3\">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.<\/font><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 10pt\"><font face=\"Calibri\" size=\"3\">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&#8217;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. <\/font><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 10pt\"><font face=\"Calibri\" size=\"3\">During step 4 you are told to install MOM 2005 reporting on the target machine. To make sure MOM 2005 don&#8217;t think the old machine still is the reporting server you can run the following query in the OnePoint database &#8220;SELECT * FROM reportingsettings&#8221;. 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. <\/font><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 10pt\"><font face=\"Calibri\" size=\"3\">Be sure that you export your custom made reports during step 1, you can import them in reporting console after step 8.<\/font><\/p>\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 10pt\"><font face=\"Calibri\" size=\"3\">Don&#8217;t forget to write down all subscriptions too. If you use subscriptions you will have to setup SMTP again.<\/font><\/p>\n<p><a href=\"http:\/\/msdn2.microsoft.com\/en-us\/library\/ms159155.aspx\">Configuring a Report Server for E-Mail Delivery<\/a><\/p>\n<p><a href=\"http:\/\/support.microsoft.com\/kb\/922332\">How to move Microsoft Operations Manager 2005 Reporting together with the MOM Reporting database to a different computer<\/a><\/p>\n<p><a href=\"http:\/\/support.microsoft.com\/kb\/919598\">When you try to import a Microsoft Operations Manager 2005 report file, the import process fails<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Article\u00c2\u00a0922332: 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 &hellip; <a href=\"http:\/\/contoso.se\/blog\/?p=75\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[2],"tags":[],"_links":{"self":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/75"}],"collection":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=75"}],"version-history":[{"count":0,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/75\/revisions"}],"wp:attachment":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=75"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=75"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=75"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}