Privilege Management Reporting Database Prerequisites

If you are using Reporting with PMC, you need to set up the Privilege Management Reporting database prior to running the PMC deployment wizard. The PMC wizard configures the connection to Reporting but doesn't create the databases.

The Privilege Management Reporting database must be set up to use SQL authentication or Windows authentication for PMC.

For more information about PMC and Privilege Management Reporting version compatibility, please see the Release Notes.

Install the Privilege Management Reporting Database

  1. On your SQL Server machine, run the PrivilegeManagementReportingDatabase_x.x.xx installer and click Next.
  2. Accept the End User License Agreement and click Next.
  3. Select the database server you want to use from the dropdown list. The default name of the database is BeyondTrustReporting. You can change this if required.
  4. You need to change the selection here to SQL Authentication or Windows Authentication for PMC integration. If you are connecting PMC to an existing Privilege Management Reporting instance you need to change the type of authentication used by SQL.

You can only use Windows authentication in a domain-joined deployment.

  1. Click Next. The Configure Event Parser Database User dialog box appears. You do not need to configure this user as it's managed by PMC. Click Next.
  2. The Configure Reporting Services Database User dialog box appears. You do not need to configure this user as it's managed by PMC. Click Next.
  3. The Configure Data Admin Database User dialog box appears. You do not need to configure this user as it is managed by PMC. Click Next.
  4. Click Next and then Install to finish the installation. You have now installed the Privilege Management Reporting database. The PMC deployment wizard will configure the connection to the database.

You do not need to install the Event Parser or Reporting Pack, as PMC includes event centralization and reporting.

For more information, please see Change server authentication mode.

Privilege Management Reporting Database Sizes

These figures are based on the assumption that there are 10 events per day per managed computer, each event is 4KB, and there is 6 months data retention. We also assume Privilege Management Reporting is the only application running on the database server.

Managed Computers CPU Memory Database
10,000 2 12GB 67.5GB
25,000 4 16GB 168.75GB
50,000 6 16GB 337.5GB
75,000 6 22GB 506.25GB
100,000 8 24GB 675GB
150,000 8 24GB 1012.5GB
200,000 8 32GB 1350GB