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.

Increasing and decreasing the number of Collection Services

To configure the number of Collection Services, go to:

1. Under the new menu item, Administration. 
   
2. Next, select the Collection Servers in the CM console.

Image Removed

Initially, SQL Compliance Manager is installed with one default collection service, running on port 5201.

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

Image Removed

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:

1. Select Auditing.
2. Press the Collection Server Status.
3. The following screen is displayed.
   Image Removed
   

...

Collection Service and Repository Database can reside on separate machines. However, this setup 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. 

To install on separate machines, follow these steps:

1. During the installation, select a Repository Database residing on a machine different from the one where the Compliance Manager console is being installed and test the connection to make sure the DB server is accessible.
   Image Added
   
2. During the installation, specify a Collection Service Trace Directory that is shared and accessible from both machines.
   Image Added
   
3. For all other settings, follow the normal process of installing SQL Compliance Manager.