SourceOne Discovery Manager: How to Troubleshoot EMC SourceOne Discovery Manager SQL Server Permissions

This article provides the SQL server permissions required for full functionality of the EMC SourceOne Discovery Manager. 
The Discovery Manager database is an essential component of the EMC SourceOne Discovery Manager solution. All Discovery Manager configuration information and changes are recorded in the Discovery Manager database including Matter configuration and actions taken on Matters. 

It is imperative that SQL server permissions are accurately assigned for full functionality of the product.

The EMC SourceOne Discovery Manager Installation will most likely fail if the account installing the database does not have adequate SQL server permission. 
 

The following are a list of troubleshooting steps to take if a failure occurs while installing or updating the Discovery Manager database on a SQLserver or after the installation:

1. Verify that the installation account used to log in to the SQL Server host computer:

• Is a member of the local administrators group

• Has SQL sysadmin server role privileges

Refer to the SQL database installation permissions subsection in the Important Considerations section of the EMC SourceOne Email Management Installation Guide for more details on why the sysadmin role is required.

2. If the account has either of the above roles, then check the database installation log file located in the same directory as the install script for errors.

3. Check the knowledge base for any errors identified in the installation log file.