Install the Endpoint Privilege Management Reporting Database

To install Endpoint Privilege Management Reporting database, run the Endpoint Privilege Management Reporting Database installation package with the Database Creator user that you set up when you created the required user accounts.

  • If you are running the installer on the same machine as the database, use Endpoint Privilege Management ReportingDatabase.msi.
  • If you are running the installer on a client machine, use Endpoint Privilege Management ReportingDatabase.exe. This includes the SQL Native Client Redistributable package.

The Endpoint Privilege Management Reporting Database installer assigns specific privileges to the user accounts that you created previously.

  1. Run the installation package and click Next to continue. The License Agreement dialog box appears.
  2. To accept the agreement, select I accept the terms in the license agreement and click Next. The Database Server dialog box appears.
  3. Set the Database server to use for Endpoint Privilege Management audit data as (local) if you are using the same machine for your database server and you didn't create an instance. If you did create an instance, you need to add it here, for example (local)\BeyondTrustReporting, where the instance is BeyondTrustReporting. The database servers are available from the dropdown menu.
  4. Type a new name in the Name of database catalog for Endpoint Privilege Management audit data field.

Use the Windows credentials of the current user or use SQL Server authentication.

  1. Select to either use the Windows credentials of the current user or you can use SQL server authentication. If you choose SQL server authentication you need to enter the Login ID and Password before you can proceed.

 

  1. Click Next. The Configure Event Parser Database User dialog box appears.
  2. If you are using the default Endpoint Privilege Management Reporting database users for BeyondTrust Reporting, check the Configure a user in the database for the event parser service box. Select your EventParser user. In this example we are using a Windows user that we've previously created.

Click Browse and navigate to the Event Parser user

  1. Click Browse and navigate to the EventParser user that you created.

 

Once you have selected a local or domain machine, ensure you select a user that you know exists in that location; otherwise, the installation will fail.

  1. Click Next. The Configure Reporting Services Database User dialog box appears.
  2. If you are using the default Reporting users for Endpoint Privilege Management Reporting, check the Create or configure a user in the database to read data for the reports box. Select to either use an existing Windows user or create a new SQL server user. In this example we use a Windows user that we previously created.

Click Browse to navigate to the ReportReader user.

  1. Click Browse to navigate to the ReportReader user that you created.

 

Once you have selected a local or domain machine, ensure you select a user that you know exists in that location; otherwise, the installation will fail.

Use either an existing Windows user or create a new SQL Server user

  1. Click Next. The Configure Data Admin Database User dialog box appears.

 

  1. If you are using the default Reporting users for Endpoint Privilege Management Reporting, check the Create or configure a Data Admin user in the database box. Select to either use an existing Windows user or create a new SQL server user. In this example we use a Windows user that we previously created.
  2. Click Browse to navigate to the DataAdmin user that you created.

Ensure you select a user that you know exists on the domain or local machine that you've selected; otherwise, the installation will fail.

  1. Click Next and then Install to finish the installation. You have now installed the Endpoint Privilege Management Reporting database.

For more information, see Create the Required Database User Accounts.