Accessing Enterprise Vault (EV) Reporting's reports from the Administration Console fails after migrating Microsoft SQL Server Reporting Service to a new server
Article ID: 100015422
Updated On:
Description
Notes
If the name of the new SQL Reporting server is different then the above steps would create a new record in the ReportServerURLSettings table in addition to record for the old SQL Reporting server. This can be resolved by deleting the ReportServerUrl entry in ReportServerURLSettings which points to old SQL Server.
- Take a full backup of all Enterprise Vault Databases
- Login to SQL Server with Admin credentials.
- Open SQL Management Studio.
- Click on New Query and execute following query
USE EnterpriseVaultDirectory
DELETE FROM ReportServerURLSettings
WHERE ReportServerUrl like '
For example:
USE EnterpriseVaultDirectory
DELETE FROM ReportServerURLSettings
WHERE ReportServerUrl like 'https://SQLServer1%'
Resolution
- Log on to the computer under the Vault Service account.
- Start the Reporting Configuration utility, Enterprise Vault Reports Configuration.
- Choose the option Configure Reporting and deploy or upgrade reports, as shown below:
Enterprise Vault Reporting Configuration
- 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.
- 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.
- Select the language that you want the reports to use.
- Select the Directory database SQL Server. If the server does not appear in the list, type in the name of the server.
- Click Configure.
- When the utility has finished, click OK on the displayed dialog to quit the utility.
Issue/Introduction
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.
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.
Additional Information
JIRA: CFT-4656
Was this article helpful?
Yes
No
Powered by
