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:
- Download and install Microsoft® System CLR Types for Microsoft® SQL Server® 2012
- Re-install the Report Viewer 2012
- Let’s go ahead and download the CLR types for 2012 from the link below
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
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.
SQL CLR types for 2012:
The MICROSOFT® REPORT VIEWER 2012 RUNTIME: https://www.microsoft.com/en-us/download/details.aspx?id=35747