WHAT TO DO TO AVOIDE ERROR SQLSYSCLRTYPE 15.0 NOT FOUND

Question

hello experts,

in my vs2022 project which uses ssrs extensively when deployed on client pc
when user run reports he gets error i then need to download install it from
https://www.microsoft.com/en-us/download/details.aspx?id=100451
SQLSysClrTypes.msi version 15.0.2000.5
on every pc this exercise need to be done.
why in clickonce publish the required package do not get installed automatically

Answer 1

@Sushil Agarwal ，you could try the following steps to install the Microsoft SQLSysCLRTypes software automatically before you installed the project.

First, Please choose Right-click Properties->Publish->Prerequisites.

Second, Please ensure that Create setup program to install Prerequisites components is checked and check Microsoft System CLR Types for SQL Server 2014.

Finally, Please click OK and Publish the Project.

If the software Microsoft SQLSysCLRTypes is not installed in your computer, you will see the following picture.

You could click Accept and use admin power to install the project automatically.

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.