Reporting Services Deployment Options

•About the Reporting Services Deployment Options

•Option R1: Multiple Microsoft SSRS Instances on the Same Database Server (Best Practice)

•Option R2: Separate Microsoft SSRS Instances and a Separate Database Server (Best Practice)

•Option R3: Separate Microsoft SSRS Instances

•Option R4: Multiple Microsoft SSRS Instances on a Separate Report Server

•Option R5: Single Microsoft SSRS Instance on One Database Server

About the Reporting Services Deployment Options

•Determine your database deployment options first (see Database Deployment Options), and then your Operations Console deployment options (see Neurons for ITSMOperations Console Deployment Options). Then determine your reporting services deployment options.

In all of the reporting services deployment options below, note the following:

•You can substitute any of the database deployments described in Database Deployment Options for the database deployments in the figure. For example, for the database engine instance shown in Option R5 below, you could substitute Option D1, Option D2a/b, Option D3, and so on for that database engine instance.

•You can substitute any of the Operations Console deployments described in Neurons for ITSMOperations Console Deployment Options for the Operations Console deployments in the figure. For example, for the single application server shown in Option R5 below, you could substitute Option OC3 for that application server.

•The Neurons for ITSM report database can reside on a separate database instance, or on a database instance on a separate server.

•The Microsoft SSRS instance can run on the Neurons for ITSM database server, application server, or on a separate server.

•The reporting feature should be installed on the Microsoft SSRS Server.

•We recommend using either Option R1 or Option R2.

Option R1: Multiple Microsoft SSRS Instances on the Same Database Server (Best Practice)

This deployment is the most common and recommended for simplicity and security. The advantage of this deployment is that you have a reporting feature for production that is separate from the development environments.  

Example of Multiple Microsoft SSRS Instance on One Database Server

Option R2: Separate Microsoft SSRS Instances and a Separate Database Server (Best Practice)

Use this deployment to keep the reporting separate between the production and development environments.

Example of Separate Microsoft SSRS Instances and a Separate Database Server

Option R3: Separate Microsoft SSRS Instances

Use this deployment to keep the reporting separate between the production and staging/UAT environments.

Example of Separate Microsoft SSRS Instances

Option R4: Multiple Microsoft SSRS Instances on a Separate Report Server

This deployment is recommended if you need to maintain your database in a locked down environment and keep it separate from the development environment. We also recommend this deployment if you already have a server with a Microsoft SSRS instance for other applications.

Example of a Multiple Microsoft SSRS Instances on a Separate Report Server

Option R5: Single Microsoft SSRS Instance on One Database Server

We do not recommend using this deployment unless you are setting up a demo environment.

Example of a Single Microsoft SSRS Instance on One Database Server