3.6.0 MxDB for SQL Server Installation and Administration Guide (5697-7088, December 2007)

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.

NOTE: Although the MxDB for SQL Server screen captures shown in this

appendix are from an earlier version of the product, the procedure

is the same in MxDB for SQL Server 3.6.

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.