WHAT TO DO TO AVOIDE ERROR SQLSYSCLRTYPE 15.0 NOT FOUND

Sushil Agarwal 361 Reputation points
2022-02-01T04:31:34.01+00:00

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

Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,395 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jack J Jun 21,976 Reputation points Microsoft Vendor
    2022-02-02T06:40:05.123+00:00

    @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.

    170415-image.png

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

    170436-image.png

    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.

    170474-image.png

    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.