WSUS 2016 error: Report Viewer 2012 Redistributable is required for this feature.

Trying to generate reports on SUS 2016 gives out  an error stating that its missing  “The Microsoft Report Viewer  2012 Redistributable is required for this feature”

Head over to Microsoft’s website to download and install the “The MICROSOFT® REPORT VIEWER 2012 RUNTIME”  https://www.microsoft.com/en-us/download/details.aspx?id=35747

During its installation  you might get another error, this time warning you about missing ” Microsoft System CLR Types for SQL Server 2012

And then Report Viewer installations fails with below error.

 

If that is the case, then you will need to do the following:

TL;DR

  1. Download and install Microsoft® System CLR Types for Microsoft® SQL Server® 2012
  2. Re-install the Report Viewer 2012

Long version

  1. Let’s go ahead and download the CLR types for 2012 from the link below

Go to https://www.microsoft.com/en-us/download/details.aspx?id=29065

Expand the  Install Instructions

Scroll all the way down and find “Microsoft® System CLR Types for Microsoft® SQL Server® 2012″

I have the SUS service running on Windows 2016 Server, so I will be using x64 Package in my case.

Click Next, and Next again

Click Yes to Agree to the install

Finish

2 Now go back, and install the Report Viewer again. This time it should install without any issues.

Click Next and Next and  Finish the Report Viewer 2012 install

 

You must close the Update services Console, and re-open it again, if it wasn’t closed before.

And now report generation works as expected.

And that is it.

 

Downloads:

SQL CLR types for 2012:

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

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