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 EVAnalyticsOperator in the msdb system database and assigning the Vault Service account

Use this procedure to do the following:

  • Create the EVAnalyticsOperator role in the msdb system database. This role is required to support Analytics operations.

  • Assign the Vault Service account to the EVAnalyticsOperator role.

To create the EVAnalyticsOperator role and assign the 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
if not exists
(select * from dbo.sysusers
where name = N'EVAnalyticsOperator')
BEGIN
	CREATE ROLE EVAnalyticsOperator Authorization dbo
END
GO
GRANT SELECT ON sysjobhistory TO EVAnalyticsOperator
GRANT SELECT ON sysjobs TO EVAnalyticsOperator
GRANT SELECT ON sysjobschedules TO EVAnalyticsOperator
GRANT SELECT ON sysjobsteps TO EVAnalyticsOperator
GRANT SELECT ON sysjobservers TO EVAnalyticsOperator
GRANT SELECT ON sysjobactivity TO EVAnalyticsOperator
GRANT SELECT ON sysschedules TO EVAnalyticsOperator
GRANT EXECUTE ON sp_add_category TO EVAnalyticsOperator
GRANT EXECUTE ON sp_add_job TO EVAnalyticsOperator
GRANT EXECUTE ON sp_add_jobschedule TO EVAnalyticsOperator
GRANT EXECUTE ON sp_add_jobserver TO EVAnalyticsOperator
GRANT EXECUTE ON sp_add_jobstep TO EVAnalyticsOperator
exec sp_addrolemember [EVAnalyticsOperator], 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.