Installing Reporting for MS Reporting Services

Installation order and procedure of MS Reporting Services

CAUTION:

Carry out the installation steps in right order. The wrong order will fail the installation.

Install the steps in the following order:

  1. Install Reporting Database Server.

  2. Providing IP Address for Reporting Services (With SQL 2008, and later versions, there is no need to install Web Server or create website by other means.)

  3. Configure SQL Reporting Services

  4. Install Standard Reports

  5. Define user rights for viewing reports. By default, the user that is given viewing rights can see all reports, but you can also restrict viewing rights to certain reports only.

If you are building a system were several customers are managed (the ASP environment), notice the special requirements in the chapter Creating ASP Environment.

If your system is located on different time zones, define those time zones for Reporting, see Reporting on Different Time Zones.

See also Special Issues in Reporting for solving and avoiding problem situations.

To define the Reporting-related settings, start the Online Monitoring application and choose Tools > Reporting Settings.

Prerequisites

Make sure the following prerequisites are available:

User Account

We recommend using Windows authentication. Make sure this user account runs the following MS Windows services:

SQL Server

SQL Server Agent

SQL Server Analysis Services

Hardware

To enable processing 24 hours and not to stress operative databases, dedicate a specific server for reporting. The SQL instances (database, Analysis Services and Reporting Services) require a lot of memory and hard disk space and processing power to work with vast amount of data. Verify your server hardware before installation, and if necessary, distribute services on separate physical servers. To start with, the required hardware has:

  • At least 4 GB memory.

  • 100 GB disks (separate SQL data / logs + separate Analysis Services data and temp)

  • Efficient processor(s)

Software

For the list of supported versions, see Installing Prerequisite Software.