Installing RSP gives SQL Native client error

Question

Hi,

I am trying to add a second Reporting Services Point to our existing Endpoint Manager environment (v2006). SQL 2019 and SSRS has been successfully installed on a separate DB server for this. When I add the RSP it starts off OK and creates the SMS folder on the C: drive of the SQL server, but then I get an error in the srsrpsetup.log saying that the srsrp.msi could not be installed. The only clue is this error:
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
Any idea how to do this? I have SQL Server 2012 Native Client v11.4.7462.6 installed and have tried in vain to find a download of any newer version.
Second issue is that the reports folder (SMS_SRSRP) is not created on the C: drive where I want it, but is instead being created on the L: drive where my SQL log DBs are created.

Answer 1

Hi @Hackmuss66 ,

This mistake may not be fatal. According to the logs this article provided, even through this error exists, the installation succeed.

https://www.prajwaldesai.com/install-sccm-software-update-point-role/
Note: Non-Microsoft link, just for the reference.

So we could ensure if these URLs shown in the screenshot connect normally.

Second issue is that the reports folder (SMS_SRSRP) is not created on the C: drive where I want it, but is instead being created on the L: drive where my SQL log DBs are created.

We could refer to this article to check if solve the problem.
https://social.technet.microsoft.com/Forums/en-US/bbcfe2ec-c60d-4d86-a0b4-2f114407dc03/sccm-2012-sp1-srs-role-stopped-working-and-wont-reinstall?forum=configmanagerdeployment

---

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.