Enterprise Vault™ Using SQL Database Roles in Enterprise Vault, Compliance Accelerator, and Discovery Accelerator

Last Published:
Product(s): Enterprise Vault (14.1, 14.0, 12.5, 12.4, 12.3, 12.2, 12.1, 12.0)
  1. About this guide
    1.  
      Introducing this guide
  2. Using Enterprise Vault database roles
    1.  
      About Enterprise Vault database roles
    2. Configuring the Vault Service account for normal operations
      1.  
        Preparing to configure the Vault Service account
      2.  
        Configuring the Vault Service account's SQL login
      3.  
        Changing ownership of Enterprise Vault databases
      4.  
        Assigning the Vault Service account to EVRuntimeRole
      5.  
        Mapping the Vault Service account to the msdb system database
      6.  
        Creating EVMonitoringOperator in the msdb system database and assigning Vault Service account
      7.  
        Restarting Enterprise Vault services
    3.  
      Configuring the Vault Service account for operations that require elevated privileges
  3. Using Compliance Accelerator and Discovery Accelerator roles
    1.  
      About Compliance Accelerator and Discovery Accelerator database roles
    2. Configuring the Vault Service account for normal operations
      1.  
        Preparing to configure the Vault Service account
      2.  
        Configuring the Vault Service account's SQL login
      3.  
        Changing ownership of Compliance Accelerator and Discovery Accelerator databases
      4.  
        Assigning the Vault Service account to EVRuntimeRole
      5.  
        Mapping the Vault Service account to the msdb system database
      6.  
        Creating EVScheduledSearchOperator in the msdb system database and assigning the Vault Service account
      7.  
        Creating EVAnalyticsOperator in the msdb system database and assigning the Vault Service account
      8.  
        Restarting Compliance Accelerator and Discovery Accelerator services
    3.  
      Configuring the Vault Service account for operations that require elevated privileges

Creating EVMonitoringOperator in the msdb system database and assigning Vault Service account

Use this procedure to do the following:

  • Create the EVMonitoringOperator role in the msdb system database.

  • Assign the Vault Service account to the EVMonitoringOperator role.

To create the EVMonitoringOperator role and assign Vault Service account

  1. Connect to the SQL server using SQL Server Management Studio.
  2. Click New Query and then enter the following query in the query editor window:
    USE MSDB
GO
CREATE ROLE EVMonitoringOperator AUTHORIZATION dbo
exec sp_addrolemember SQLAgentUserRole, EVMonitoringOperator
GRANT SELECT ON sysjobs TO EVMonitoringOperator
GRANT SELECT ON sysjobschedules TO EVMonitoringOperator
GRANT SELECT ON sysjobsteps TO EVMonitoringOperator
GRANT SELECT ON sysjobservers TO EVMonitoringOperator
EXEC sp_addrolemember N'EVMonitoringOperator', N'domain\vsa'
GO

    where domain\vsa is the Vault Service account and the domain to which it belongs.

  3. From the Query menu, click Execute, and then wait for the script to complete.