Previous post about ACS :
Now that you have a running ACS Collector, you have to publish the ACS Reports on your SQL Reports Services server.
2. Open a command prompt
3. Go to the folder you just created (D:ACS)
4. Executing the following command
UploadAuditReports.cmd reportsrvfqdn http://reportsrvfqdn/ReportServer ACSFOLDER
5. Don’t take care of the two warnings
6. Start your web Brower and go to http://reportsrvfqdn/Reports
7. Click on Show Details and go to DB Audit.
8. Adapt the Connection String field to point to your ACS Database
data source= xxxxSQLDB1;initial catalog=OperationsManagerAC;Integrated Security=SSPI
9. If you are using the same reporting for Operations Mananger and ACS, select also the option Credentials supplied by the user running the report and check Use as Windows Credentials when connection to the data source.
10. Click Apply.
Access Control List
1. Create a new Active Directory group for your Security Administrator and add them as member. (By example: SCOM2007-ACSAuditors)
2. Go to your Database server and add the group as Users for you ACS DB.
3. Grant your group as db_datareader of your ACS database.
4. Your Security Administrator could now access to the ACS Reports through the SQL Reporting Services Web Interface : http://reportsrvfqdn/Reports > Audit Reports
The next post will be about the ACS Forwarder Configuration.
Feel free to contact in case of any remarks and/or comments.