Which SQL CLR version and Report Viewer can be used for SCOM 2019/Win 2018 and SQL 2019/Win 2018

Question

You are usig SQL CLR 2014 and Report Viewer 2015 in your quick start deployment.with SQL 2017.
https://kevinholman.com/2019/03/14/scom-2019-quickstart-deployment-guide/

We are using SQL 2019 / OS 2018 for our SCOM 2019 deployment. Is it still okay to use the version of SQL CLR and Report Viewer you used in your steps? Searched for new version of both the SQL CLR and Report Viewer but could only find newer SQL CLR 2019. Does it make a difference which version I use?

Answer 1

I do not think it matters. Install it and try, if it fails, then you know that you need to use a lower version.

Answer 2

Hi,

As mentioned above, it should work.

Microsoft SQLSysCLRTypes
https://www.microsoft.com/en-us/download/details.aspx?id=100451

MICROSOFT® REPORT VIEWER 2015 RUNTIME
https://www.microsoft.com/en-us/download/details.aspx?id=45496

Regards,

Alex
If the response is helpful, please click "Accept Answer" and upvote it.

Answer 3

>We are using SQL 2019 / OS 2018 for our SCOM 2019 deployment. Is it still okay to use the version of SQL CLR and Report Viewer you used in your steps?

SQL CLR 2014 and Report Viewer 2015 work fine on SCOM 2019 under SQL server 2019.

Roger