Unless you assign the SQL system administrator (sysadmin) role to the Vault Service account, you must perform the following additional steps before you run the Enterprise Vault Configuration wizard for the first time:

• Add the Vault Service account to the msdb system database.

• Grant the Vault Service account Select permissions on the msdb tables sysjobs, sysjobschedules, sysjobservers, and sysjobsteps.

• If you are using Microsoft SQL Server 2005 or later, assign the database role SQLAgentUserRole to the Vault Service account.

Follow the appropriate procedures:

• See Assigning permissions and roles in SQL Server 2000 databases.

• See Assigning permissions and roles in SQL Server 2005/2008 databases.

If you do not perform these steps, the following problems occur:

• Enterprise Vault fails to purge the history records from the Monitoring database, so these database records continue to grow.

• Upon completion, the Enterprise Vault Configuration wizard logs an error in the event log with the category 'Monitoring Configuration Utility' and Event ID 41123. The error description begins as follows and then lists the contents of a Purge Job SQL script file:

  Monitoring Configuration Utility reported error: SQL Error at: --