SCOM 2016 DB Migration - Reporting Server

Chan, Johnny 21 Reputation points
2020-09-18T12:23:22.567+00:00

Hi,

We are doing the SCOM 2016 DB migration. We have moved the operation DB into a separate SQL Server. The management console able to connect to the new DB after edit the registry. However, we need to move the reporting server to new DB. We have removed the reporting server feature from the management server, and trying to install reporting server on the new SQL server. During the installation we have some issue when pointing to the management console.

25779-image.png

Does the reporting server need to install at the management server or the DB server?

Please advise.

Thank you!

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,419 questions
Windows Server Migration
Windows Server Migration
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Migration: The process of making existing applications and data work on a different computer or operating system.
409 questions
0 comments
Accepted answer
  1. Leon Laude 85,666 Reputation points
    2020-09-18T12:55:36.91+00:00

    Hi @Chan, Johnny ,

    The SCOM reporting feature needs to be installed on the server where the SQL Reporting Services is installed, it does not have to be installed on a SCOM management server.

    When installing the SCOM Reporting feature you will be asked point the Reporting feature to one of your SCOM management servers (not ”console”).
    If you’ve changed servers, make sure you have the firewalls open.

    Also did you follow the steps outlined in the official documentation here?

    How to Move the Reporting Server Role
    https://learn.microsoft.com/en-us/system-center/scom/manage-move-reporting-services-role?view=sc-om-2016

    ----------

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

    Best regards,
    Leon

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. SChalakov 10,266 Reputation points MVP
    2020-09-18T18:27:24.34+00:00

    Hi,
    you can install the reporting feature on any server, even on the management server, but in order to install it you need to install SQL Server Reporting Services first.
    In bigger and also in production environments this is not a good idea in my opinion. I am also not a fan of installing SCOM Reporting on a SQL Server too. What I would recommend is dedicating a server for this and installing both SQL Server Reporting Services and SCOM Reporting role on it.
    Still if you consider otherwise and install the SCOM Reporting Role on your SQL Server (of course after installing and configuring SQL Reporting Services), please consider that during the installation, like Leon stated you need to enter the name of a management server.
    The error message you get simply states that the server you are installing the role on cannot connect to your management server on port 5724.
    Please make sure:

    • that under "Management Server Namne" you enter the FQDN of your SCOM management server
    • you can connect to your management server on port 5724.

    A simple PowerShell command will tell you if this is the case. Please run this on the server, on which you are installing the SCOM reporting role:

    Test-NetConnection -ComputerName SCOMMgmtServer.domain.suffix -Port 5724

    If the results says "False" then you need to ensure that you can connect on this port. Check the Windows Firewall on your Management Server as well as any firewall in between and ensure the connection can be established.

    If you have further questions, please do not hesitate to post them here.

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

    0 comments
  2. Chan, Johnny 21 Reputation points
    2020-09-18T19:49:52.87+00:00

    Hi LeonLaude,

    I am able to installed the SCOM reporting server into separate SQL. When I try to test the report I got the following error.25892-11.png

    I did try updated the DataSource from the SSRS web console. Is there have any other place need to update the new SQL server/instance name?

    Thank you!