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:
- Under the new menu item, Administration.
- Next, select the Collection Servers in the CM console.
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.
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:
- Select Auditing.
- Press the Collection Server Status.
- The following screen is displayed.
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.