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

Article:TECH126574  |  Created: 2010-01-21  |  Updated: 2014-08-12  |  Article URL http://www.symantec.com/docs/TECH126574
Article Type
Technical Solution


Issue



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


Error



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
 



Legacy ID



340697


Article URL http://www.symantec.com/docs/TECH126574


Terms of use for this information are found in Legal Notices