question

Hackmuss66-9545 avatar image
0 Votes"
Hackmuss66-9545 asked Amandayou-MSFT commented

Installing RSP gives SQL Native client error

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.

mem-cm-site-deployment
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Amandayou-MSFT avatar image
0 Votes"
Amandayou-MSFT answered Amandayou-MSFT commented

Hi @Hackmuss66-9545,

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.

129806-97.png

129800-971.png

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.



97.png (16.7 KiB)
971.png (21.8 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

May we know the current status of the question? If there is any other assistance we can provide, please feel free to let us know, we will do our best to help you.

Thanks and regards,
Amanda

0 Votes 0 ·