Connect to an external database

To store the data for your medium- to large-size organization, connect Content Security Reporter to a supported external database.

Important: If the Content Security Reporter and McAfee ePO databases share the same SQL Server instance, you must configure separate databases for each.

Note:
  • Users on the Microsoft SQL Server database must have db_owner permissions.
  • You can install Content Security Reporter and the external database on the same computer, or on separate computers. If Content Security Reporter is installed on the same computer as the external database, there must be enough disk space to accumulate large amounts of data.

Task

  1. Select MenuConfigurationReporter Server Settings.
  2. From the Setting Categories menu, click Database.
  3. On the Database page, select Edit.
  4. From the This external database drop-down list, select the database.
  5. On the Database settings configuration area, enter the database information.
  6. Select the SSL checkbox to use SSL encryption while connecting to the database.
    Note: To connect using SSL, the database server must also be SSL-enabled.
  7. To verify that the database information is correct, click Test.
    A status message indicates success or failure.
  8. Click Save.

Results

The connected external database appears as the database server in the Registered Servers list: MenuConfigurationRegistered Servers. McAfee recommends that you do not edit the settings on the Registered Servers page.