Install Monitoring Server in a distributed environment

Updated: 2008-10-23

The server components of Monitoring Server can be installed in a distributed manner, depending on the deployment needs of your environment. Monitoring Server has the following components:

  • Monitoring System Database: A SQL Server database that stores all Monitoring Server data and configuration settings.

  • Monitoring Server Internet Information Services (IIS) component: Monitoring Server Web service, which is used for rendering dashboards for preview and development scenarios.

  • Dashboard Viewer for SharePoint Services: A Web Part that is used to render and display dashboards. The Web Part includes Web services from the Monitoring Server Web service and rendering capabilities for rendering dashboards. The Dashboard Viewer for SharePoint Services can be installed on one or more SharePoint sites, or it can be installed in a SharePoint Services Web farm.

  • Scorecard Viewer for Reporting Services: An interface that Monitoring Server provides for SQL Server 2005 Reporting Services that enables the viewing of scorecards in Report Definition Language (RDL) format.

  • Monitoring Plug-in for Report Designer: An add-in to the Reporting Services Report Designer. This add-in allows Report Designer to create reports with scorecards in them.

You must run PSCsrv.msi on each computer in the topology for each component that you want to install, and then run Monitoring Server Configuration Manager on each server computer to configure Monitoring Server individually on each server.

Before you install Scorecard Viewer for Reporting Services, ensure that all necessary prerequisites are installed. For information, see Monitoring Server prerequisites. Additionally, ensure that Microsoft SQL Server Reporting Services has been configured.

You can install and configure the Monitoring System Database on a local computer or on are remote computer. The best practice is to configure the Monitoring Server Internet Information Services (IIS) component and the Monitoring System Database at the same time. For more information, see Installing Monitoring Server.

This topic provides steps to install and configure the Monitoring System Database. Before you begin, ensure that all software prerequisites for installing the Monitoring System Database are installed.

Before you install Monitoring Plug-in for Report Designer, ensure that all necessary prerequisites are installed. For information, see Monitoring Server prerequisites.

Ensure that all necessary prerequisites are installed before you begin installing Dashboard Viewer for SharePoint Services. For information, see Monitoring Server prerequisites.

Monitoring Server Web Service is the IIS component of Monitoring Server. You install and configure Monitoring Server Web Service to create the Monitoring Web site. Before you install the Monitoring Server IIS component, you must install and configure the Monitoring System Database.

Ensure sure that all necessary prerequisites are installed before you install Monitoring Server Web Service. For information, see Monitoring Server prerequisites.

Note

Either Office SharePoint Server 2007 or Windows SharePoint Services must be installed in order to successfully install and use Monitoring Server. The terms Windows SharePoint Services and SharePoint Services are used collectively in PerformancePoint Server documentation to refer to Office SharePoint Server 2007 and Windows SharePoint Services 3.0.

Install Monitoring Server

  1. On the installation Welcome page, click Install Monitoring Server, or run PSCsrv.msi on the computer on which you plan to run the Monitoring Server Web Service.

  2. When Setup is complete, click Next. Monitoring Server Configuration Manager opens.

  3. Select Distributed configuration.

  4. Select only Monitoring Server.

  5. Specify the location of the Monitoring System Database.

  6. Configure the Secure Sockets Layer (SSL) port number, and if necessary, the IP address for Monitoring Server Web Service.

  7. Configure the service account. When asked for a service account, enter the credentials for the application pool identity account that the Monitoring Server Web Service uses to communicate with the database. When you have completed steps 1 through 7, all the pre-installation validations are completed.

  8. Review the selections, and then proceed with the installation. Monitoring Server Configuration Manager starts. When you are finished, Monitoring Server Web Service (that is, the Monitoring Server IIS component) and the Monitoring System Database are installed and configured.

Install Dashboard Viewer for SharePoint Services

  1. Run PSCsrv.msi on the server that is running Monitoring System Database and Monitoring Server Web Service. When Setup is complete, click Next to open Monitoring Server Configuration Manager.

  2. Select Distributed configuration.

  3. Select Dashboard Viewer for SharePoint Services.

  4. Specify the Monitoring System Database location, and then connect to that database.

  5. Select the SharePoint site collection where you want to deploy Dashboard Viewer for SharePoint Services, and then click Next.

    Note

    You must be a site collection administrator on the site collection to which you want to deploy the Web Part.

  6. If the application pool identity account of the selected SharePoint site collection is running under the LocalSystem account and the Monitoring System Database is located on a remote computer, then the local computer account needs to be added to the BPMDeveloper role in Monitoring System Database. A prompt is displayed confirming if the Monitoring Server Configuration Manager can proceed to do this as part of the installation. Choose the desired option. If you choose No, you must manually add this account to the BPMDeveloper role in Monitoring System Database after Step 7, as a post-installation step.

    When you have completed steps 1 through 6, all the pre-installation validations are completed.

  7. Review the selections and then finish the installation.

Install Monitoring Plug-in for Report Designer (Visual Studio 2005)

  1. Run PSCsrv.msi on the computer that runs the Monitoring Server and Monitoring Server Web Service. When setup completes, click Next to open the Monitoring Server Configuration Manager.

  2. Select Distributed configuration.

  3. Select Monitoring Plug-in for Report Designer (Visual Studio 2005).

  4. Click Finish.

    When you complete these steps, the Monitoring Plug-in for Report Designer is installed and configured.

Install the Monitoring System Database

  1. On the installation Welcome page, click Install Monitoring Server. When Setup is complete, click Next to open Monitoring Server Configuration Manager.

  2. Select Distributed configuration.

  3. Select only Monitoring System Database.

  4. Connect to a local or remote database, specify the database name, and then select Create mode. Use Provision mode if you have already created a new database to be used as the Monitoring System Database.

  5. Proceed through the Monitoring Server Configuration Manager and provide all required information.

    When you complete these steps, the Monitoring System Database is installed and configured.

Install Scorecard Viewer for Reporting Services

  1. Run PSCsrv.msi on the computer that runs Monitoring System Database and hosts a Monitoring Server database. The PSCsrv.msi extracts all Monitoring Server components on each computer. When Setup is complete, click Next to open Monitoring Server Configuration Manager.

  2. Select Distributed configuration.

  3. Select Monitoring Server and Scorecard Viewer for Reporting Services.

  4. Specify the location of the Monitoring System Database.

  5. Configure the Secure Sockets Layer (SSL) port number and IP address for the Monitoring Server Web Service.

  6. Configure the application pool identity by using the credentials used for the Monitoring Server application pool identity account. This account is used by the Monitoring Server Web Service to communicate with the database.

  7. Choose the SQL Server Reporting Services report server instance on which to deploy the extensions.

    When you have completed steps 1 through 7, the Scorecard Viewer for Reporting Services is installed and configured.

Manually open Dashboard Designer

  1. Click Start, point to All Programs, Microsoft Office PerformancePoint Server 2007, and then click Dashboard Designer.

  2. Click Run to Download Dashboard Designer.

  3. Dashboard Designer setup opens and guides you through the installation process.

    Note

    If Dashboard Designer does not appear in the default location (%System Drive%:\Program Files\Microsoft Office PerformancePoint Server 2007\Dashboard Designer), open Internet Explorer and use one of the following URLs, depending on your configuration, to access the designer:

    • For Secure Sockets Layer (SSL) configuration: https://<server name>:<port number>/Central

    • For non—SSL configuration: http://<server name>:<port number>/Central