Can not access the Enterprise Vault (EV) Data Analysis Reports and File System Archiving (FSA) Reporting has completed the initial scan

Problem

Can not access the Enterprise Vault (EV) Data Analysis Reports and File System Archiving (FSA) Reporting has completed the initial scan

Error Message

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'SiteID'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

When a user attempts to view one of the EV Data Analysis Reports from the SQL Reporting Web Site, the above error is displayed.

Performing a Dtrace of the 'ReportingServicesService' on the SQL Reporting Server, the following line will highlight the issue:

 
{EVREPORTSQLEXCEPTION.EN_US} The following error has occurred while processing the report|SQLServer:SQLServerName,1443|Database:EnterpriseVaultFSAReporting|Authentication:Integrated Windows Authentication|Error:|System.Data.SqlClient.SqlError: Cannot open database "EnterpriseVaultFSAReporting" requested by the login. The login failed.|System.Data.SqlClient.SqlError: Login failed for user 'Domain\ReportingUsername'.|
 

Note: See Technical Article under Related Documents on performing Dtrace.

Cause

The above reference points to an issue with the given user 'Domain\ReportingUsername' not having the appropriate access to the 'EnterpriseVaultFSAReporting' database, which may occur if FSA Reporting was setup after Enterprise Vault Reporting was configured.

Solution

Using the SQL Server Management Studio, perform the following:
 
  1. Expand 'Security' and 'Logins'
  2. Right-click the 'Domain\ReportingUsername' and choose 'Properties'
  3. Select 'User Mapping'
  4. Select the appropriate Database 'EnterpriseVaultFSAReporting'
  5. If the Database is not mapped to the user, select the check-box to Map the Database to the user
  6. Select the 'EVReportingRole'
  7. Select 'OK'

Retry the Data Analysis Reports from the SQL Reporting Web Site
 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)