Jump to content


  • 0
Tech1914

SMS_SRS Reporting Services

Question

A little background

I completed a SCCM restore using the backed up site data base. I didn't mess with the reporting database at all left them in place just replacing the site database. Now I am getting the following message in the monitoring.

Site Component Manager failed to install this component on this site system.

Solution: Review the previous status messages to determine the exact reason for the failure. Site Component Manager will automatically retry the installation in 60 minutes. To force Site Component Manager to immediately retry the installation, stop and restart Site Component Manager using the Configuration Manager Service Manager.

I also noticed when I click on reporting and try to click on my hyperlinks http://servername/reports and https://servername/reportserver I get the following error.

 

The version of the report server
database is either in a format that is not valid, or it cannot be read. The
found version is '162'. The expected version is '163'.
(rsInvalidReportServerDatabase)

 

 

Please let me know if you have seen this. Thanks.

Share this post


Link to post
Share on other sites

Recommended Posts

  • 0

This is the process I followed. Please let me know if it was wrong.

https://prajwaldesai.com/how-to-re-install-sql-reporting-services-for-sccm/

 

 

Now I am getting the following error:

The report server service is not running on Reporting Service Point server. Even though it is running. I restarted the SQLServer(Instance) service even though it was running.

Share this post


Link to post
Share on other sites

  • 0

So for other that find this post, to be clear, you MUST create a new database and NOT reuse the old database. Yes this will mean you loose any custom reports you have imported into CM but you import those RDL again and everything will be back to normal.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.