We get quite a few questions about it so I thought I’d post instructions here. If you’re wanting to install Audit Reporting this is the way to do it:
1. Logon 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.
Note: 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. Launch a Command Prompt window and 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.
Note: 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.
For more information see Deploying ACS Reporting in the Operations Manager 2007 Deployment Guide or How to Deploy Operations Manager 2007 ACS Reporting at http://technet.microsoft.com/en-us/library/bb687987.aspx.
Hope this helps!
J.C. Hornbeck | Manageability Knowledge Engineer