How to configure multiple servers to have RA use the same repository


Technique

Product: Reporting Server
Release: 8206
Primary OS: Windows
Solution Date:

Problem

How to configure multiple Reporting Servers to have Resource Analyzer (RA) collect to the same Repository.

Solution

Provided the Reporting Servers are all the same release and they use a relational RDBMS for the Repository, the Repository can be shared among them.

You will need to configure the first Reporting Server with Resource Analyzer and create the Repository.

All subsequent Reporting Servers will configure Resource Analyzer but specify NO for creating the Repository. Then you can specify the relevant adapter and RDBMS specifics for the Repository.

For additional information, refer to the Resource Analyzer Administrator's and User's Manual Release 7710  manual under the section titled Configuring Many-to-One Monitoring.