Search <book_title>...

Enterprise Vault™ Installing and Configuring

Last Published: 2018-04-09

Product(s): Enterprise Vault (12.3)

Assigning permissions and roles in SQL Server databases

You must add the Vault Service account to the msdb system database, grant the required permissions to the account, and assign the database role SQLAgentUserRole to the account.

To add the Vault Service account to the msdb system database

On the SQL Server computer, start SQL Server Management Studio.
Select the required SQL Server.
Browse to Databases > System Databases > msdb > Security > Users.
Right-click Users and then click New User.
In the User name box, enter a new user name.
In the Login name box, enter the domain and the user name of the Vault Service account, in the form domain\user_name.
Click OK.

To grant the permissions to the Vault Service account

Right-click the new user that you just created, and then click Properties.
Select the Securables page.
Add the following msdb tables to the list of securables, and then grant Select permission for them to the Vault Service account:
- sysjobs
- sysjobschedules
- sysjobservers
- sysjobsteps

To assign the SQLAgentUserRole to the Vault Service account

Browse to Databases > System Databases > msdb > Security > Roles > Database Roles.
Right-click SQLAgentUserRole, and then click Properties.
On the General page, click Add, and then specify the Vault Service account that you have just created.