This documentation is archived and is not being maintained.

Deploying ACS Reporting on Windows Server 2008 and SQL Server 2008

Updated: May 22, 2009

Applies To: Operations Manager 2007 R2, Operations Manager 2007 SP1

Audit Collection Services (ACS) reporting can be installed in two configurations.

  • A Microsoft SQL Server 2008 Reporting Services (SRS) SP1 instance with Operations Manager Reporting already installed. A benefit of this is the ability to view ACS Reports in the Operations console.

  • An SRS instance without Operations Manager Reporting installed.

The installation procedures for ACS Reporting do not differ, but the application of access control is different. By deploying ACS Reporting on the same SQL Server 2008 Reporting Services instance as your Operations Manager 2007 Reporting, the same role-based security applies to all reports. This means that ACS Reporting users need to be assigned to the Operations Manager Report Operator Role to access the ACS reports.

In addition to membership in the Operations Manager Reporting Role, ACS report users must also be assigned db_datareader role on the ACS database (OperationsManagerAC) to run ACS reports. This requirement is independent of the presence of Operations Manager Reporting

If you choose to install ACS Reporting independently of Operations Manager Reporting, you can also use SRS security to secure the reports. See the SQL Server 2008 Books Online Reporting Services Tutorials, Setting Permissions in Reporting Services for more information.

Preparing for installation

Deploy ACS as described in About Audit Collection Services (ACS) in Operations Manager 2007 before setting up ACS reporting.

Before you start

  1. The root management server for your management group must be installed and ACS must be configured, on either the RMS or a management server. For more information, see About Audit Collection Services (ACS) in Operations Manager 2007.

  2. An instance of Microsoft SQL Server 2008 Reporting Services must be installed on the target computer.

  3. During this procedure, you need to be logged on as member of Operations Manager Report Operator user role.

  4. IIS must be installed on the hosting system. IIS will have already been installed if you are co-locating with a Reporting server.

  5. You need to have access to the ACS database.

  6. You need the Operations Manager 2007 installation media.

Deploying ACS Reporting

To deploy ACS Reporting

  1. Log on to the server that will be used to host ACS reporting as a user that is an administrator of the SRS instance.

  2. Create a temporary folder, such as C:\acs.

  3. On your installation media, go to \ReportModels\acs and copy the directory contents to the temporary installation folder.

    There are two folders (Models and Reports) and a file named UploadAuditReports.cmd.

  4. On your installation media, go to \SupportTools and copy the file ReportingConfig.exe into the temporary acs folder.

  5. Open a Command Prompt window by using the Run as Administrator option, and then change directories to the temporary acs folder.

  6. Run the following command.
    UploadAuditReports “<AuditDBServer\Instance>” “<Reporting Server URL>” “<path of the copied acs folder>”
    For example: UploadAuditReports “myAuditDbServer\Instance1” “http://myReportServer/ReportServer$instance1” “C:\acs”

    This example creates a new data source called Db Audit, uploads the reporting models Audit.smdl and Audit5.smdl, and uploads all reports in the acs\reports directory.

    The reporting server URL needs the reporting server virtual directory (ReportingServer_<InstanceName>) instead of the reporting manager directory (Reports_<InstanceName>).

  7. Open Internet Explorer and enter the following address to view the SQL Reporting Services Home page. http://<yourReportingServerName>/Reports_<InstanceName>

  8. Click Audit Reports in the body of the page and then click Show Details in the upper right part of the page.

  9. Click the Db Audit data source.

  10. In the Connect Using section, select Windows Integrated Security and click Apply.