Symptoms

When you attempt to add a SQL Reporting Service instance using the K2 workspace a validation error is thrown:

'Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=Neutral, PublicKey=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
 

Diagnoses

Within the GAC the Microsoft.ReportVeiwer.Common version was set to 9.0.0.0 instead of 8.0.0.0. This was causing the error to surface within the workspace preventing the Service instance from being created.


 

Resolution

For this issue to be resolved the following SSRS prerequisites installed within the environment: http://help.k2.com/onlinehelp/K2blackpearl/ICG/4.6.9/webframe.html_Prereqs_K2forReportingServices.html

Microsoft SQL Server 2012 Reporting Services or Microsoft SQL Server 2008 Reporting Services
Microsoft Report Viewer Redistributable 2008 SP1
http://www.microsoft.com/downloads/details.aspx?FamilyID=BB196D5D-76C2-4A0E-9458-267D22B6AAC6anddisplaylang=en

NOTE:
K2 Reports Runtime – requires Microsoft Report Viewer Redistributable 2008 SP1
K2 SSRS Service Broker – requires Microsoft Report Viewer Redistributable 2005 SP1

Microsoft Report Viewer Redistributable 2005 SP1 needs to be installed on all distributed environments for the issue to be resolved.