Accessing Enterprise Vault (EV) Reporting's reports from the Administration Console fails after migrating Microsoft SQL Server Reporting Service to a new server

Problem

Enterprise Vault Reporting is a separately installable Enterprise Vault component that provides enterprise-level reporting for administrators. Typically, the Enterprise Vault Reporting component is installed without any other Enterprise Vault components, on a server that runs Microsoft SQL Server Reporting Services. When you select a report, the Enterprise Vault data extension on the Microsoft SQL Server Reporting Services server computer issues a query to obtain the required data from the Enterprise Vault databases. Report Manager then displays the generated report. You can access Enterprise Vault Reporting's reports from Common Tasks in the Enterprise Vault Administration Console as below.

1. In the left pane of the Administration Console, expand the site hierarchy until the name of the site is visible.
2. Click the site name.
3. In the right pane of the Administration Console, click Enterprise Vault Server Management to display the server management options.
4. Click Run operation reports or Run data analysis reports.
5. Alternatively, to access the operation report that summarizes content providers' licensing and usage, click Run Licensing and Usage Summary Report.

The Enterprise Vault Reporting component needs to be installed and reconfigured if Microsoft SQL Server Reporting Service is migrated to a new server. If this is not performed then accessing Enterprise Vault Reporting's reports from the Administration Console may fail.

 

Solution 

1. Log on to the computer under the Vault Service account.
    
2. Start the Reporting Configuration utility, Enterprise Vault Reports Configuration.
    
3. Choose the option Configure Reporting and deploy or upgrade reports, as shown below:
   Enterprise Vault Reporting Configuration
    
4. Provide the details of the reporting user account you created for Enterprise Vault Reporting to run under. Enter the Active Directory domain, the user name, and the password for the account.
    
5. Select the Microsoft SQL Server Reporting Services instance on which you want to deploy the reports. To deploy the reports on the default instance, select the instance name MSSQLSERVER.
    
6. Select the language that you want the reports to use.
    
7. Select the Directory database SQL Server. If the server does not appear in the list, type in the name of the server.
    
8. Click Configure.
    
9. When the utility has finished, click OK on the displayed dialog to quit the utility.

 

 

JIRA : CFT-4656