Search <book_title>...

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

Last Published: 2021-03-23

Product(s): Enterprise Vault (14.1, 14.0, 12.5, 12.4, 12.3, 12.2, 12.1, 12.0)

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

Use this procedure to do the following:

Create the EVScheduledSearchOperator role in the msdb system database. This role is required to support scheduled searches.
Assign the Vault Service account to the EVScheduledSearchOperator role.

To create the EVScheduledSearchOperator role and assign the Vault Service account

Connect to the SQL server using SQL Server Management Studio.

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'EVScheduledSearchOperator')
BEGIN
	CREATE ROLE EVScheduledSearchOperator  Authorization dbo
END
GO
GRANT SELECT ON sysjobs TO EVScheduledSearchOperator
GRANT SELECT ON sysjobschedules TO EVScheduledSearchOperator
GRANT SELECT ON sysjobsteps TO EVScheduledSearchOperator
GRANT SELECT ON sysschedules TO EVScheduledSearchOperator
GRANT EXECUTE ON sp_add_category TO EVScheduledSearchOperator
exec sp_addrolemember SQLAgentUserRole, EVScheduledSearchOperator
exec sp_addrolemember [EVScheduledSearchOperator], N'domain\vsa'
GO

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

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