Enterprise Vault™ Compliance Accelerator Installation Guide
- Introducing Compliance Accelerator
- Preparing to install Compliance Accelerator
- Configuration options for Compliance Accelerator
- Prerequisites for Compliance Accelerator
- Security requirements for temporary folders
- Configuring Intelligent Review API Authentication and Authorization
- Installing Compliance Accelerator
- Installing the Compliance Accelerator server software
- Configuring Compliance Accelerator for use in a SQL Server Always On environment
- Installing Compliance Accelerator in a clustered environment
- Installing the Compliance Accelerator server software
- Appendix A. Ports that Compliance Accelerator uses
- Appendix B. Troubleshooting
- Appendix C. Installing and configuring the Enhanced Auditing feature
- Appendix D. Introducing Veritas Surveillance web client
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 Compliance 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 Compliance 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 Compliance 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.