ACS Database, Collector and Reports Install Step by Step Guide
I have been busy doing a fair number of ACS Installs recently and thought I would put together a step by step guide for reference purposes as the information to do this end to end is not in the same place in the guides which can lead to missed steps
ACS Database and Collector Server Install
1. Log on to the Management Server with an account that is a member of the OpsMgr administrators group
2. Click on the OpsMgr Setup executable which On the install splash page click install “Install Audit Collection Server” from the menu to start the install wizard.
3. On the Welcome screen click next
4. Check the button to accept the terms in the license Agreement and click next
5. On the “Database Installation Options” screen leave the create a new database option checked and click next
6. On the “Data Source” screen, leave the default data source name as “OpsMgrAC”
7. On the “Database” screen leave the Remote database server option checked and add the database server machine name, the database server instance name and leave the database name as the default, click next
8. On the “Database Authentication” screen leave Windows authentication checked and click next.
9. On the “Database Creation Options” screen, check specify directories and choose the following paths:
Database file location -,
Log file location –
and Click next
10. On the “Event Retention Schedule” screen either leave the following defaults:
Local hour of the day to perform daily database maintenance: 02:00AM
Number of days and event is retained in the database: 14
or change as appropiate
Click next
11. On the “ACS Stored Timestamp Format” Screen select either the local timestamp or the Universal Coordinated Time (UTC) checkbox and click next
12. Click next on the summary page to install
13. When the install is finished log onto the SQL server and verify that the OperationsManagerAC database is installed
14. On the local server: , open Computer Management and Services and Applications, select Services, and confirm that the Operations Manager Audit Collection Service is present, that it is started, and that the Startup Type is set to Automatic.
ACS Reports Install
Installing the ACS Reports
1. Log on to the Management Server with an account that is a member of the OpsMgr administrators group
2. Open explorer and navigate to D:\Software\OpsMgrRTMSP1\SelectCDImage\ReportModels\acs.
3. Copy the folder locally to the C: drive
4. Copy the file “ReportingConfig.exe” from D:\Software\OpsMgrRTMSP1\SelectCDImage \SupportTools to C:\acs.
5. Open a Command Window and navigate to the folder c:\acs
6. Run the following command:
UploadAuditReports <database\instance> http://<management server>/ReportServer C:\acs
note: you may see some warning errors as below on uploading the reports, these are expected and can be ignored
Finally, here is the bit that everyone misses
Configuring SRS
1. Open Internet Explorer and enter the following address to view the SQL Reporting Services Home page. http://<yourReportingServerName>/Reports$<InstanceName>
2. Click Audit Reports in the body of the page and then click Show Details in the upper right part of the page.
3. Click the Db Audit data source.
In the Connect Using section, select Windows Integrated Security and click Apply.