SCOM Reporting Server

Luke Lim 531 Reputation points
2020-09-30T09:41:43.363+00:00

If I want the report module.

Must I only install SQL Reporting Services (SRSS) on the same SQL DB?
Or I can install SQL Reporting Services on another server like a Management Server and configure the SRSS but create a new reporting DB on the SQL DB server.
Then I install the SCOM Reporting Server on the Management Server.

I tried this setup but when I install Reporting Server, it will fail even if SCOM installation pass the pre-requisite checks.
If I install SRSS on the SQL DB and then Reporting Server, then it will be okay.

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,204 questions
No comments
{count} votes

Accepted answer
  1. Leon Laude 85,036 Reputation points
    2020-09-30T09:58:05.093+00:00

    Hi @Luke Lim ,

    The SCOM Reporting feature must be installed on the server where the SQL Server Reporting Services (SSRS) is installed, the Reporting feature & the SSRS can located on any server, it can be a dedicated server, a management server, the database server etc...

    Make sure to use the same version for SQL Server Reporting Services as the SQL Server used by the SCOM database & data warehouse.

    If your Reporting feature is failing to install, please provide the exact error, I also suggest you to check the SCOM installation log over here:

    • %LocalAppData%\SCOM\LOGS\OpsMgrSetupWizard.log

    ----------

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

    Best regards,
    Leon

    No comments

1 additional answer

Sort by: Most helpful
  1. Luke Lim 531 Reputation points
    2020-09-30T10:14:47.37+00:00

    Thanks. I am able to install now. I suspect is you need to open other ports on the SQL DB other than just 1433.