Enterprise Vault™ Discovery Accelerator Installation Guide
- Introducing Discovery Accelerator
- Preparing to install Discovery Accelerator
- Configuration options for Discovery Accelerator
- Prerequisites for Discovery Accelerator
- Security requirements for temporary folders
- Installing Discovery Accelerator
- Installing the Discovery Accelerator server software
- Creating the configuration database and customer databases
- Setting up a Custodian Manager website
- Configuring Discovery Accelerator for use in a SQL Server Always On environment
- Installing Discovery Accelerator in a clustered environment
- Installing the Discovery Accelerator client software
- Installing the Discovery Accelerator server software
- Appendix A. Ports that Discovery Accelerator uses
- Appendix B. Troubleshooting
Using SQL Server Reporting Services in an Always On environment
Microsoft does not fully support the use of SQL Server Reporting Services in an Always On environment and, consequently, neither does Discovery Accelerator. As the following article explains, however, it is possible to configure Reporting Services to work with an Always On availability group:
https://msdn.microsoft.com/hh882437.aspx
In summary, you must do the following to make the Discovery Accelerator reports work in an Always On environment:
Install SQL Server Reporting Services on all the replicas in the availability group.
On all the secondary replicas, assign the same reporting server credentials to the Vault Service account as you assigned to this account on the primary replica:
The System Administrator role
The Content Manager role on the Home folder
Use the Report Manager tool that comes with SQL Server to assign the credentials.
On the primary replica, use the Encryption Keys page of Reporting Services Configuration Manager to back up the encryption keys for the report server databases to a file.
Add the report server databases, ReportServer and ReportServerTempDB, to the availability group.
When you upload the Discovery Accelerator report templates through the Accelerator Manager website, take care to specify the correct URL for the reporting server. Rather than specify the name or address of a standalone SQL reporting server, you must specify the virtual network name of the appropriate availability group listener. For example, you might specify the reporting server URL as follows:
http://availability_group_listener/ReportServer
After failover occurs, do the following:
Use the Reporting Services Configuration Manager to point the report server service on the new primary replica to the failed-over databases, ReportServer and ReportServerTempDB.
Take care to specify the report server database credentials for the same domain user as you previously specified on the old primary replica.
On the Encryption Keys page of Reporting Services Configuration Manager, restore the encryption keys from the backup file that you previously created on the old primary replica.