How to Deploy Audit Collection Services (ACS) in SCOM 2012

re: How to Deploy Audit Collection Services (ACS) in SCOM 2012

Kristopher Turner — Thu, 28 Feb 2013 16:42:50 GMT

Thanks for this post. I have run into the following issues with my ACS reports. I am running Windows 2008 R2 for OS and SQL 2012 for my SQL server. My standard reports are working find however when I try to run a report for ACS I get the following error:

An error has occurred during report processing. (rsProcessingAborte)

Cannot create a connection to data source 'datasource1'. (rsErrorOpeningConnection)

I have check and there are no firewalls blocking any ports.

re: How to Deploy Audit Collection Services (ACS) in SCOM 2012

Dirkv — Thu, 10 Jan 2013 22:54:32 GMT

The SQL requirements for ACS as listed here:

Collecting Security Events Using Audit Collection Services in Operations Manager

technet.microsoft.com/.../hh212908.aspx

will be updated soon so it will comply with

System Requirements: System Center 2012 SP1 - Operations Manager

technet.microsoft.com/.../jj656654.aspx

re: How to Deploy Audit Collection Services (ACS) in SCOM 2012

Anonymous — Wed, 09 Jan 2013 23:14:56 GMT

For OM2012.SP1.RTM, ACS is supported on SQL 2012.

re: How to Deploy Audit Collection Services (ACS) in SCOM 2012

Dirkv — Wed, 09 Jan 2013 14:40:26 GMT

According to:

Collecting Security Events Using Audit Collection Services in Operations Manager

technet.microsoft.com/.../hh212908.aspx

It states:

Microsoft SQL Server 2005 or SQL Server 2008. You can choose an existing or new installation of SQL Server. The Enterprise edition of SQL Server is recommended because of the stress of daily ACS database maintenance.

It might have changed though since SP1 and this isn't updated according latest. Please keep eye on this article.

re: How to Deploy Audit Collection Services (ACS) in SCOM 2012

James Dotson — Tue, 08 Jan 2013 15:46:39 GMT

So SQL 2012 is not supported for the ACS DB? The documentation is unclear in this regard, but does state that for the Configuration and DW DB's SQL 2012 is supported.