Prerequisites for SSRS/SSIS Reporting

You must have access to a pre-configured SQL DB user registered to the Windows domain.

Note: The versions of the Workhub SQL database and the Reporting SQL database must be the same.

For example, a user with the domain account as follows:

<Domain>/<SQLServer Machine Name>$

Note: For more information about SQL Server Reporting Services, refer to http://msdn.microsoft.com/en-us/library/ms159106.aspx.

If you are using Deployment Manager to install the Reporting Sample feature, Data Transformation Services (DTS) must be installed on the machine on which the Deployment Manager is running. Installing the Integration Services feature of SQL Server provides the required files (see the installation documentation for the relevant version of SQL Server). For more details, see the MSDN documentation for the dtutil (https://msdn.microsoft.com/en-us/library/ms162820%28v=sql.105%29.aspx) and dtexec (https://msdn.microsoft.com/en-us/library/ms162810%28v=sql.105%29.aspx) utilities for the version of SQL Server you are using.

If you want to use Deployment Manager to configure SSRS reports on a machine without SQL Server installed, then Microsoft® Windows PowerShell Extensions for Microsoft® must be installed.

For information relating to SQL Server, refer to https://www.microsoft.com/en-gb/download/details.aspx?id=104781.