3.4.3 MxDB for SQL Server Installation and Administration Guide

Configure SQL Server Reporting

Services

MxDB for SQL Server can be used to provide High Availability for SQL

Server Reporting Services that are deployed in a scale-out configuration.

In this configuration, the matrix nodes host the reporting service

generation and scheduling. The report definitions are in the reporting

service database, which is a SQL instance located on a PSFS filesystem

that can be accessed by all of the nodes. Clients use a Matrix Server

virtual host to access the matrix nodes.

Configure Reporting Services

To configure reporting services with MxDB for SQL Server, complete

these steps on each node:

1. Install SQL Server (optional) and the Report Server on each node.

2. Create a Virtual SQL Server to serve as the configuration database.

This Virtual SQL Server does not need to be on the same node(s) as the

Report Server, making the SQL Server installation in step 1 optional.

To create the Virtual SQL Server, select Matrix > Add > Add Virtual

SQL Server. (For information about filling out the Add Virtual SQL

Server window, see “Configure Virtual SQL Servers” on page 41.) Be

sure to configure the Virtual SQL Server on all nodes that will be

providing reporting services.