System Center Operations Manager 2007 Reporting Server Installation on Windows Server 2008 Guide for Operations Manager 2007

Microsoft Corporation

Published: November 2008

Author

Matthew J. Goedtel

Feedback

Send suggestions and comments about this document to . Please include the document name with your feedback.

1

Information in this document, including URL and other Internet Web site references, is subject to change without notice. Unless otherwise noted, the companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted in examples herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.

© 2008 Microsoft Corporation. All rights reserved.

Microsoft, MS-DOS, Windows, Windows Server, Windows Vista, and Active Directory are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

All other trademarks are property of their respective owners.

Revision History

Release Date / Changes
October , 2008 / Original release of this guide
October, 2008 / Updated document to correct steps for enabling IIS Script Execution.
December, 2008 / Updated Install SQL Server 2005 with SP2 section to remove miscommunication regarding slipstreamed SQL 2005 w/SP2 media.

1

Contents

Introduction

Operations Manager Reporting Server Prerequisites

Minimum Software Requirements

To Use the Reporting Server, You Must Have:

Install SQL Server 2005 with Service Pack 2

Install Windows Server 2008 Server Role

Install SQL Server 2005 with Reporting Services

Configure IIS

Report Server Application Pool

Enable Script Execution

Verify Reporting Services

1

Introduction

This document provides deployment guidance for installing and configuring Microsoft System Center Operations Manager 2007 Reporting Server component on Windows Server 2008.

Operations Manager Reporting Server Prerequisites

Minimum Software Requirements

This section outlines the minimum software requirements that you must have for the Operations Manager Reporting component beyond the operating system.

Important

Verify that all appropriate security updates, hotfixes, and service packs have been applied to the operating system and to applications that are required for deploying Operations Manager components. You can do by visiting the Windows Update website at

In addition to a supported operating system, you must have the following software:

To Use the Reporting Server, You Must Have:

SQL Server 2005™ Standard or Enterprise Edition with Service Pack 2 and SQL Server Reporting Services component installed

.NET Framework 3.0

IIS 7.0 with ASP.NET enabled

If you intend on installing the Operations Manager agent to monitor the Reporting Server, you will need to install the following hotfixes required for Operations Manager agent support on Windows Server 2008:

951327

952664

953290

Install SQL Server 2005 with Service Pack 2

Install Windows Server 2008 Server Role

The following steps are necessary before proceeding with the installation and configuration of SQL Server 2005 with Reporting Services.

  1. Log onto Windows Server 2008.
  2. Configure a server role and enable ASP.NET and IIS. To do this, perform the following steps:
  3. Click Start, and then click Server Manager.
  4. In Server Manager, right-click Manage Roles, and then click Add roles. The Add Roles Wizard starts.
  5. In the Add Roles Wizard, click Select Server Roles.
  6. On the Select Server Roles page, click to select the Web Server (IIS) check box, and then click Next.

Note: Because of role dependency, the File Server check box is automatically selected when you click to select the Web Server (IIS) check box.

  1. On the Role Services page, expand Common HTTP Features, and then click to select the following check boxes:

Static Content

Default Document

Directory Browsing

HTTP Errors

HTTP Redirection

  1. Expand Application Development, and then click to select ASP.NET check box.
  2. Expand Security, and then click to select the Windows Authentication check box.
  3. Expand Management Tools, expand IIS 6 Management Capability, and then click to select the following check boxes:

IIS Metabase Compatibility

IIS 6 WMI Compatibility

IIS 6 Scripting Tools

IIS 6 Management Console

  1. Click Next, and then click Install.

Note: If you do not enable these features, the Reporting Services option does not appear in the Feature Selection dialog box of the SQL Server Setup program.

  1. Verify that the World Wide Web Publishing service is started. If the World Wide Web Publishing service is not started, configure the service to start automatically. To do this, follow these steps:
  2. In Control Panel, click System and Maintenance.
  3. Click Administrative Tools.
  4. Double-click Services.
  5. In the User Account Control dialog box, click Continue.
  6. Right-click World Wide Web Publishing Service, and then click Properties.
  7. In the World Wide Web Publishing Service Properties dialog box, select Automatic in the Startup Type list.
  8. Click Apply, click Start, and then click OK.

Install SQL Server 2005 with Reporting Services

The following steps are required to install SQL Server 2005 with Reporting Services.

Notes:

When you install the release version of SQL Server 2005, you receive a warning message. The warning message explains that this program has known compatibility issues. Click Run program to continue the installation.

In the Features Section dialog box, make sure that Reporting Services is selected.

In the Report Server Installation Options dialog box, select one of the following options:

Install the default configuration

Install but do not configure the server

Note: If you select the Install but do not configure the server option, you can manually configure the report server after the installation has finished. However, you may experience problems when you manually configure the report server. For troubleshooting help, please see Knowledge Base Article 938245.

After you have successfully installed SQL Server 2005 with Reporting Services, you must install SQL Server 2005 Service Pack 2 (SP2) or later. Once you have successfully updated to Service Pack 2 or later, verify the SQL Server services are started before moving onto the next section.

Configure IIS

The following steps are required to ensure Operations Manager Reporting Server operates correctly.

Report Server Application Pool
  1. Open IIS Manager.
  2. Expand the tree until you can select Application Pools.
  3. Right-click the ReportServer$Instance Pool and select Advanced Settings.
  4. Select Identity under Process Model, click the browse (…) button.
  5. In the Application Pool Identity window, select LocalSystem from the Built-in account list box. Press OK twice.
Enable Script Execution
  1. Click Start, click Run, type inetmgr, and then click OK.
  2. In the Internet Information Services (IIS) Manager, expand Web Sites, expand Default Web Site, and then click the virtual directory for the report server (by default this is ReportServer$Instance1)
  3. Under the Features View, double-click Handler Mappings.
  4. Highlight ISAPI-dll, right-click and select Edit Feature Permissions
  5. Click to select the Scripts check box, and then click OK.

Verify Reporting Services

  1. Click Start, point to All Programs, right-click Internet Explorer, and then click Run as administrator.
  2. In the User Account Control dialog box, click Continue.
  3. Open Report Manager. By default, the URL of Report Manager is the following:

ServerName/reports

If you used a named instance of Reporting Services, the URL of the Report Manager is the following:

ServerName/reports$InstanceName

When the page renders, you should see the Home page appear empty without any error messages. After you have verified Report Manager is running correctly, proceed with the normal steps of installing Operations Manager 2007 with Service Pack 1 Reporting feature. For more information on the steps required, please see How to Deploy Reporting in Operations Manager 2007 in the Operations Manager 2007 Online Help.

If the page does not render correctly and you are receiving errors, please review Knowledge Base Article 938245 for additional details.

1