SCCM reporting services failing to install

Question

I have the SCCM server on a dedicated server with the SQL databases & reporting services on a SQL2016 server.
The Database & SCCM is all working normally - the only problem is with the setup of reporting services.
Reporting services is installed & running, the SCCM component detected the instance when installed.

However every hour it attempts to install the reporting point:
Error 4951 Site Component Manager failed to install this component, because the Microsoft Installer File for this component (srsrp.msi) could not install.

I found the srsrp.msi in the SMS folder on the SQL server - tried installing manually & ran OK but SCCM still tries & fails to install the SMS_SRS_Reporting_point

Anyone have any ideas?

Answer 1

Hi @Steve Hathaway ,

> Parameters: \<redacted>\S$\SMS\bin\x64\rolesetup.exe /install

1, According to the logs, this path is specified manually. If the following information cannot help you, you may need to ask the person who installed it. By default, the path should look like this:

By default, srsrp.msi is located at C:\Program Files\Microsoft Configuration Manager\bin\x64\srsrp.msi, the screenshot as follows.

> Enabling MSI logging. srsrp.msi will log to S:\SMS\logs\srsrpMSI.log

2, Please help check srsrpMSI.log, is there any useful information?

3, Furthermore, I found a similar case. Its solution is: Copy the D:\SMS_SRSRP\ folder to your clipboard (CTRL+C) and open the S:\ drive than re-insatlling the role.
This link for your reference:
http://www.networksteve.com/enterprise/topic.php/SCCM_2012_SP1_-_SRS_Role_stopped_working_and_wont_re-install/?TopicId=66866&Posts=1
Note: Microsoft provides third-party contact information to help you understand the problem. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

4, For more information about how to install SCCM Reporting Services Point, please refer to this link:
How to Install a MEMCM / SCCM Reporting Services Point - Recast Software
Note: Microsoft provides third-party contact information to help you understand the problem. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

Looking forward to your feedback.

Best regards
Cherry

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

what do the srsrpmsi and srsrp log say is the issue? exactly what account is running the Ssrs service?

Answer 3

Hi Garth,

Thanks for the info
The installation was performed by a client's tech (who then left without fixing this)
On the target SQL server the SMS folder is on the S: drive. There is also a second SMS folder on the D: drive
SCCM appears to be running the install from the S: instance.

Tue Dec 6 10:12:59 2022> SMSSRSRP Setup Started....
<Tue Dec 6 10:12:59 2022> Parameters: \<redacted>\S$\SMS\bin\x64\rolesetup.exe /install /siteserver:SCCM_01 SMSSRSRP 0
<Tue Dec 6 10:12:59 2022> Installing Pre Reqs for SMSSRSRP
<Tue Dec 6 10:12:59 2022> ======== Installing Pre Reqs for Role SMSSRSRP ========
<Tue Dec 6 10:12:59 2022> Found 1 Pre Reqs for Role SMSSRSRP
<Tue Dec 6 10:12:59 2022> Pre Req SqlNativeClient found.
<Tue Dec 6 10:12:59 2022> SqlNativeClient is already installed (Product Code: {9D93D367-A2CC-4378-BD63-79EF3FE76C78}). But to support TLS1.2, a new version with Product Code: {B9274744-8BAE-4874-8E59-2610919CD419} needs to be manually installed
<Tue Dec 6 10:12:59 2022> Pre Req SqlNativeClient is already installed. Skipping it.
<Tue Dec 6 10:12:59 2022> ======== Completed Installation of Pre Reqs for Role SMSSRSRP ========
<Tue Dec 6 10:12:59 2022> Installing the SMSSRSRP
<Tue Dec 6 10:12:59 2022> Passed OS version check.
<Tue Dec 6 10:12:59 2022> .NET Framework 4.6.2 or later is installed.
<Tue Dec 6 10:13:00 2022> Clean up old files
<Tue Dec 6 10:13:00 2022> No versions of SMSSRSRP are installed. Installing new SMSSRSRP.
<Tue Dec 6 10:13:00 2022> Enabling MSI logging. srsrp.msi will log to S:\SMS\logs\srsrpMSI.log
<Tue Dec 6 10:13:00 2022> Installing S:\SMS\bin\x64\srsrp.msi SRSRPINSTALLDIR="S:\SMS_SRSRP" SRSRPLANGPACKFLAGS=0
<Tue Dec 6 10:13:10 2022> srsrp.msi exited with return code: 0
<Tue Dec 6 10:13:10 2022> Installation was successful.
<Tue Dec 6 10:13:10 2022> Cannot register S:\SMS_SRSRP\srsserver.dll, it doesn't exist
<Tue Dec 6 10:13:10 2022> Cannot register S:\SMS_SRSRP\srsserver.dll, it doesn't exist
<Tue Dec 6 10:13:10 2022> Cannot register SRSRP interop DLL S:\SMS_SRSRP\srsserver.dll. Installation cannot continue.
<Tue Dec 6 10:13:10 2022> Fatal MSI Error - srsrp.msi could not be installed.
<Tue Dec 6 10:13:10 2022> ~RoleSetup().

The SMS_SRSRP folder is on the D: drive.

The SQL reporting services service is running under the SCCM administrator account & the SCCM server computer account is also an admin on the SQL server

Is there a setting in the SCCM to get the remote install to run from the D:\SMS location on the SQL server as I think that this is the issue?