Share via

MECM Reporting point server instance blank with remote sql server

lalajee 1,811 Reputation points
2022-02-26T23:00:29.027+00:00

Hi, I have installed MECM with remote SQL server.

I have installed and configure the sql reporting on sql server

When I try to install sql reporting service role it show instance blank.

I try following but still same issue

In CfgMgr, In the Administration workspace, expand Site Configuration, and then click Servers and Site System Roles.

I right click on the sql box and Add Site System Role. The Add Site System Roles Wizard opens. Choose Reporting Point, and after verifying the connection to the CfgMgr DB, but the instance doesnt populates.

Is they something i'm missing.

I already check following site but still no luck.

https://social.technet.microsoft.com/Forums/en-US/4479e73e-8a19-4c7e-9418-b36770656b9b/sccm-2012-reporting-point-server-instance-blank?forum=configmanagergeneral

https://sccmentor.com/2014/02/06/reporting-services-point-server-instance-blank/#:~:text=Basically%20when%20running%20a%20remote,and%20not%20the%20SCCM%20server.

Microsoft Configuration Manager
0 comments
Accepted answer
  1. Garth 5,801 Reputation points
    2022-02-27T02:21:46.683+00:00

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Garth 5,801 Reputation points
    2022-02-27T02:20:02.687+00:00

    Where are you trying to install the reporting point? Are the ports open to your Ssrs server?

  2. Ben Whitmore 1 Reputation point MVP
    2022-07-06T19:11:49.93+00:00

    To enumerate the SSRS instance when adding the Reporting Services role, you need to have the dynamic port range open on the Firewall. This is documented in note 6 at
    https://learn.microsoft.com/en-us/mem/configmgr/core/plan-design/hierarchy/ports#bkmk_note2

    Dynamic Range for Server 2012 or later is 49152 through 65535.