SCOM Reporting Service installation issue in SCOM 2016 UR7

Sai Kumar M 26 Reputation points
2022-05-31T11:17:28.703+00:00

SCOM Reporting Service installation issue in SCOM 2016 UR7.

We have environment with SCOM 2016 UR7 and we wanted to upgrade the SQL's as they are 2012. In order to upgrade we have chosen a new server for reporting, migrated the reporting database from old to new server, while installing the reporting service on the new reporting service it is failing. Could someone help me if I m missing somewhere or doing wrong.

Regards
Sai

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,528 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. SChalakov 10,571 Reputation points MVP
    2022-05-31T11:30:19.653+00:00

    Hi @SaliKumarM-5560,

    The SSRS is a very fragile component and it could easily break during such operations (migration). I would first go ahead and check the allowed extentions in order to be sure that this is not blocking it:

    Operations Manager 2019 and 1807 reports fail to deploy
    https://learn.microsoft.com/en-us/troubleshoot/system-center/scom/cannot-deploy-operations-manager-reports

    After you have verified this, please restart the service and check the Application Event Log on the system, on whihc SSRS is running. What related events do you see? Can you please post some of those here after masking any sensitive information?

    Did you check also the DW Data Source?

    Creating a Data Source for the Operational DB on OpsMgr 2012 R2 Reporting Server
    https://blog.tyang.org/2013/12/06/creating-data-source-operational-db-opsmgr-2012-r2-reporting-server/

    Please post some more information about the symptoms and erros that you get.

    Thanks and Regards,

    ----------

    (If the reply was helpful please don't forget to upvote or accept as answer, thank you)
    Regards,
    Stoyan

    0 comments No comments

  2. Sai Kumar M 26 Reputation points
    2022-06-28T09:00:09.43+00:00

    The Default Report MP's were not up to date. Post updating the MP's, reporting service started installing.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.