The Collection Server tab lets you to specify which computer is currently hosting the Collection Server. The SQL Compliance Manager Agent Service receives audit settings from the Collection Server and sends collected SQL events to the Collection Server for processing. Ensure the SQL Compliance Manager Agent Service has access to the Collection Server computer.SQLCM collection service and repository database can reside on separate machines. However, this set up can function properly only if the collection service trace directory is accessible from both machines. The repository database uses queries to get trace information by passing the trace files path. The trace directory must be readable and accessible by the repository database service account.

To install on separate machines, follow these steps:

Increasing and decreasing the number of Collection Services

To configure the number of Collection Services, go to:

...

Trace directories can be changed and configured for each service. Default directories are named under the port used by their respective collection service.

Collection Service Health State

You can start or stop Collection Services and verify their port and trace directory by navigating to the header menu bar and:

...

The same dialog also displays the specific Trace Directory assigned to each Collection Service, allowing you to easily identify and manage the directory paths used by individual services.