Prerequisites for the Reporting Services Server role

For the latest information concerning K2 blackpearl software compatibility, please see the article K2 blackpearl Compatibility Matrix on http://help.k2.com/en/blackpearlmatrix.aspx

Reporting Services Server

The Reporting Services Server role is defined to be the server on which the K2 Reports will be stored, and is already running Microsoft SQL Server Reporting Services. This may or may not be installed on the SQL Server itself, depending on your environment. The K2 for Reporting Services component, configuration manager, and K2 documentation will be installed on this server.

The Reporting Services Server role requires the following prerequisites:

K2 blackpearl Prerequisites for the Reporting Services Server
Operating System	Microsoft Windows Server 2008 Standard, Enterprise SP2 or Microsoft Windows 2008 R2, RTM and SP1 or Windows Server 2012
Latest security patches 32-bit and 64-bit support
Windows Components	IIS 7.0 with IIS 6.0 Compatibility or IIS 7.0 Management Tools or IIS 8 Manager Distributed Transaction Coordinator (DTC) IPv4 (IPv6 can exist, but IPv4 must also be configured) ASP.NET Windows Authentication Role Services
Additional Software	Microsoft SQL Server 2014 Reporting Services or 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-267D22B6AAC6&displaylang=en NOTE: K2 Reports Runtime – requires Microsoft Report Viewer Redistributable 2008 SP1 K2 SSRS Service Broker – requires Microsoft Report Viewer Redistributable 2005 SP1 Microsoft .NET Framework 3.5 SP1 Redistributable Package and Microsoft .Net Framework 4 http://www.microsoft.com/downloads/details.aspx?FamilyID=AB99342F-5D1A-413D-8319-81DA479AB0D7&displaylang=en Browser: Microsoft Internet Explorer. See the K2 blackpearl 4.6 Compatibility Matrix for information on supported versions. If you want to integrate with CRM 4, download and install the CRM 4 SDK prior to starting the K2 Setup Manager. (Note that the CRM 4 SDK Assemblies must be added to the Global Assembly Cache (GAC) of the K2 server) CRM 4 SDK: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=82e632a7-faf9-41e0-8ec1-a2662aae9dfb&displaylang=en If you want to integrate with CRM 2011, 2013 or 2015, the K2 Setup Manager will automatically install the required SDK and redistributables.

Important: You must be running Reporting Services in Native mode. K2 blackpearl does not currently support SharePoint Integrated mode.

Microsoft SQL Server

In K2 blackpearl 4.5 and later the K2 Workspace Report Designer does not use the SSRS server.

SSRS integration is still supported for customers:

Who wish to use the SSRS server to expose reports in other contexts other than K2 Workspace or K2 Process Portals
Who wish to use other design tools and then import reports into K2 Workspace Report Designer

K2 blackpearl leverages the services available in SQL Server, which provides the following features:

“Microsoft SQL Server Reporting Services (SSRS) provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend and customize your reporting functionality.” (http://msdn.microsoft.com/en-us/library/ms159106.aspx)

For further details on deployment options: http://msdn.microsoft.com/en-us/library/bb522791.aspx
For further details on security: http://msdn.microsoft.com/en-us/library/bb522728.aspx

While infrastructure changes are required by K2, each environment is different and has its peculiarities which must be taken into account. Modifying the infrastructure could have unforeseen results if the changes are not appropriately understood or managed. Given the broad spectrum of underlying infrastructure utilized, it is recommended that a panel or committee with appropriate skill in each area concerned be assembled to outline the underlying infrastructure changes and gauge the impact of the required changes.