KB000267

Security and Kerberos Authentication with K2 Servers Whitepaper

Microsoft Report Viewer Redistributable 2005 SP1 download

Microsoft Report Viewer Redistributable 2005 SP1 (upgrade) download

Introduction

This article provides troubleshooting steps for dealing with the "Please install Microsoft Report Viewer Redistributable 2005 SP1 to view reports" error when attempting to view one of the out of the box reports in K2 Workspace.
 

Troubleshooting the Error

Use this article to verify that everything is installed and setup as expected. The error most commonly occurs due to one or more of the following conditions:

• A dependency is missing for the K2 reports functionality on either the Reports Server or K2 Server
• Authentication issues involving Kerberos
• Issues with various connection strings between the K2 Server and SQL Server Reporting Services (SSRS)

Steps

1. Verify that the Microsoft Report Viewer Redistributable 2005 SP1 is installed.
   This redistributable can be found on Microsoft’s website at: http://www.microsoft.com/downloads/details.aspx?FamilyID=E7D661BA-DC95-4EB3-8916-3E31340DDC2C&displaylang=en
    
2. If SSRS and K2 Server are on separate boxes please ensure that the Microsoft Report Viewer Redistributable 2005 SP1 is on the server as well as on the box that has SQL Reporting Services (if they are distributed).
    
3. Verify that the workspace SPN has been properly set up. For assistance with Kerberos setup please refer to page 11 in the “Security and Kerberos Authentication with K2 Servers” Whitepaper that can be located on the K2 Underground.
   For example:
    
   Setspn –A HTTP/[MachineName] [DomainName][AppPoolAccount]
   Setspn –A HTTP/[MachineName.FQDN] [DomainName][AppPoolAccount]
4. If you are using Kerberos please ensure that you have set the metabase correctly to “Negotiate,NTLM”. Please refer to pages 22-25 in the “Security and Kerberos Authentication with K2 Servers” Whitepaper that can be located on K2 Underground.
   
   
    
5. Verify the BLACKPEARL data source through the Report Manager and verify the connection string is as follows:
   • Server=[server name]; Port=5555; AutoAlias=false
     (where [server name] = the K2 server name)
   • Be sure to also set the authentication mode to “Windows Integrated”.
     See example below:
     
   
    
6. If the machine has a previous version of the Microsoft Report Viewer Redistributable installed, the solution is to :
   a) install Microsoft Report Viewer Redistributable 2005 then
   b) install Microsoft Report Viewer Redistributable 2005 SP1 (upgrade).
    

The above steps are the more common fixes for this error. If you are receiving this error and have not been able to remedy your issue following the options described, please contact K2 Support.

Further Information

1. K2 blackpearl User Guide > Getting Started > Deployment Planning >K2 blackpearl Requirements > Software Requirements.
2. Security and Kerberos Authentication with K2 Servers Whitepaper: http://k2underground.com/files/folders/technical_product_documents/entry21001.aspx pages 11 and 22-25
3. Microsoft Report Viewer Redistributable 2005 SP1 download: http://www.microsoft.com/downloads/details.aspx?FamilyID=E7D661BA-DC95-4EB3-8916-3E31340DDC2C&displaylang=en
4. Microsoft Report Viewer Redistributable 2005 SP1 (upgrade) download: http://www.microsoft.com/downloads/details.aspx?FamilyId=35F23B3C-3B3F-4377-9AE1-26321F99FDF0&displaylang=en