SCCM RP SSRS datasource issues

NP 396 Reputation points
2022-03-24T00:56:13.393+00:00

we recently had an issue where our reporting point broke and we went thru the process of removing the role as well as uninstall and re-installing SSRS

What i have now is confusing and wondering if anyone has seen this before or can advise. One datasource seems to point to our server, the other one doesnt point to any server. Is it just a matter of deleting the redundant datasource? I can see all the rdl files under C:\Program Files\SMS_SRSRP\Reports

Multiple .old files

186275-image.png

Which has 2 datasets which goes to:

186276-image.png

Which then goes to this page:

186301-image.png

Then here:

186311-image.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,826 questions
Microsoft Configuration Manager
{count} votes

4 additional answers

Sort by: Most helpful
  1. Garth 5,801 Reputation points
    2022-03-24T11:16:49.04+00:00

    One ds is for the cm db and the other is for the cm data warehouse. I would leave both ds alone. They will come back every 10 minutes if you change them.
    As for the extra cm folders that we can clear see, those i would delete as they are not needed.


  2. Garth 5,801 Reputation points
    2022-03-24T20:21:24.107+00:00

    I can see all the folders there, when you click into any of them do you see the reports?

    BTW why are you looking at the Reportserver URL and not the Reports url?


  3. Garth 5,801 Reputation points
    2022-03-25T02:02:24.397+00:00
    0 comments No comments

  4. Amandayou-MSFT 11,051 Reputation points
    2022-03-30T07:19:00.387+00:00

    Hi,

    Haven't heard from you for some time, is Garth's answer helpful to you? If it is helpful, please accept answer. It will make someone who has the similar issue easily find the answer.

    If you have any other issues, please don't hesitate to let us know.

    Thanks and have a nice day.

    Thanks and regards,
    Amanda

    0 comments No comments