Accenture MDR Quick Start Guide for Microsoft® ACS

This quick start guide will help Accenture MDR customers configure Microsoft® ACS to allow log collection from the Log Collection Platform (LCP).

The document includes the following topics:

Supported Versions

A list of supported versions is available in the Accenture MDR Supported Products List document (Accenture_MDR_Supported_Products_List.xlsx) which can be found in

Accenture MDR Portal - https://mss.accenture.com/PortalNextGen/Reports/Documents

Port Requirements

Table 1-1: Port requirements for LCP communication.

Source 

Destination

Port

Description

LCP

Microsoft ACS

1433 (TCP)

Default database port

Configuring Microsoft ACS

To configure Microsoft ACS, follow the steps below.

I. Configure for log collection.

  1. Go to Control Panel > Administrative Tools > Local Security SettingsLocal Policies > Audit Policy.

  2. For every policy, enable or disable audit logging; if you enable audit logging, choose Log Audit Failure and Audit Success messages, if required.

  Note: For more information, refer to the following documents: 

II. Create a read-only database user account for Microsoft SQL Server.

    LCPs that fetch data from databases require that you create a read-only database user account so that the LCP can query for events.

    To create a read-only database user for Microsoft SQL Server:

  1. From the Windows Start menu, choose Run, and then type the following command: cmd

  2. Navigate to the directory that contains the OSQL.EXE file.

For Microsoft SQL Server 2012, the default directory location for this file is: <InstallDir>\Microsoft SQL Server\110\Tools\Binn.

For Microsoft SQL Server 2008, the default directory location for this file is: <InstallDir>\Microsoft SQL Server\100\Tools\Binn.

For Microsoft SQL Server 2005, the default directory location for this file is: <InstallDir>\Microsoft SQL Server\90\Tools\Binn.

For Microsoft SQL Server 2000, the default directory location for this file is: <InstallDir>\Microsoft SQL Server\80\Tools\Binn.

  3. Log in as the system administrator and type the following command: sqlcmd -S ip_address_or_host_name -U <admin user> -P <admin_user_password>

  4. At the command prompt, type the following commands:

         EXEC sp_addlogin '<username>', '<Password>', '<databasename>'

         USE <databasename>

         CREATE USER <username> FOR LOGIN <username>

         EXEC sp_addrolemember 'db_datareader', '<username>'

         GRANT SELECT ON dtPartition to <username>;

         GRANT SELECT ON dtCategory to <username>;

         GRANT SELECT ON dtMachine to <username>;

         GRANT SELECT ON dtSource to <username>;

         go

LCP Configuration Parameters

Table 1-2: The Microsoft ACS event collector(DB-3480) properties to be configured by MDR are shown in the table.

Property

Default Value

Description

Database URL

jtds:jdbc:sqlserver://<hostname>:1433;DatabaseName=<databasename>

jtds:jdbc:sqlserver://<hostname>\instance_name=<instancename>:1433;

DatabaseName=<dbname>

The database URL string that needs to be configured on the collector by MDR.

Hostname  - Hostname or IP address of the database. 

Databasename - The name of the database in which the ACS events are stored.

Instancename - The name of the instance within the specified database.

1433 (TCP port) - The default port number for DB connectivity.

Note: If the database is configured to use a different port number, please advise the MDR onboarding team. 

User Name

Custom Value

The username for the database account mentioned in the Pre-Installation Questionnaire (PIQ).

Password 

Custom Value

The password for the database account mentioned in the PIQ.

 

 

Legal Notice

Copyright © 2021 Accenture. All rights reserved.

Accenture, the Accenture Logo, and DeepSight Intelligence are trademarks or registered trademarks of Accenture in the U.S. and other countries. Other names may be trademarks of their respective owners.

The product described in this document is distributed under licenses restricting its use, copying, distribution, and decompilation/reverse engineering. No part of this document may be reproduced in any form by any means without prior written authorization of Accenture and its licensors, if any.

THE DOCUMENTATION IS PROVIDED "AS IS" AND ALL EXPRESS OR IMPLIED CONDITIONS, REPRESENTATIONS AND WARRANTIES, INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NON-INFRINGEMENT, ARE DISCLAIMED, EXCEPT TO THE EXTENT THAT SUCH DISCLAIMERS ARE HELD TO BE LEGALLY INVALID. ACCENTURE SHALL NOT BE LIABLE FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS DOCUMENTATION. THE INFORMATION CONTAINED IN THIS DOCUMENTATION IS SUBJECT TO CHANGE WITHOUT NOTICE.

The Licensed Software and Documentation are deemed to be commercial computer software as defined in FAR 12.212 and subject to restricted rights as defined in FAR Section 52.227-19 "Commercial Computer Software - Restricted Rights" and DFARS 227.7202, et seq. "Commercial Computer Software and Commercial Computer Software Documentation," as applicable, and any successor regulations, whether delivered by Accenture as on premises or hosted services. Any use, modification, reproduction release, performance, display or disclosure of the Licensed Software and Documentation by the U.S. Government shall be solely in accordance with the terms of this Agreement.