Permission error on the MSDB SQL System Database when installing eDiscovery Bundle 3.7 or higher

SYMPTOMS

The following error occurs when installing eDiscovery Bundle 3.7 or "3.7 Service Pack 1:

Error 1001.Permission check failed: "USE msdb

SELECT HAS_PERMS_BY_NAME('sysjobs','OBJECT','SELECT')" at

ZyLAB.EDiscovery.Installer.ValidatableInstallActionExecutor.Validate()

at ZyLAB.EDiscovery.Installer.Int...

This applies to both Legal Processing and Legal Review install wizards.

Following the error the installation is cancelled and the system rolled back to the previous state.

CAUSE

As of eDiscovery Bundle 3.7, maintenance jobs for the Legal Processing and Legal Review databases are created automatically by the install wizards. This requires permissions to change the MSDB System Database in Microsoft SQL.

RESOLUTION

It is recommended to allow the Legal Processing and Legal Review install wizards create the required Maintenance jobs. This is required to make sure the relevant indexes in each table of the databases are kept functional.

Make sure to enter Microsoft SQL Login credentials with enough permissions to make changes to the MSDB System Database in the respective install wizard. Having sufficient credentials will allow you to execute the required Maintenance jobs so that the relevant indexes in each table are present.

APPLIES TO

3.7; 3.7 Service Pack 1

Articles in this section

Comments

Articles in this section

Related articles