Enterprise Vault Reporting’s reports fail to open after you enable FIPS compliant algorithms in Windows Local Security Policy
Problem
Error Message
When attempting to view a report, the Report Manager shows the following error.
This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying
The Report Server also shows following FIPS error.
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
Cause
This is a Microsoft limitation. SQL Server Report Manager fails to load the reports after you enable FIPS compliant algorithms in the Local Security Policy. See the following Microsoft article for more information about the limitation.
http://msdn.microsoft.com/en-us/library/ms345220.aspx
Solution
Warning: The following workaround configures the use of a FIPS certified implementation of the triple-DES encryption algorithm in place of the default non-FIPS certified implementation of AES encryption algorithm. Since the triple-DES algorithm is theoretically less secure than the AES algorithm this change may increase your security risk. It may also make the computer or the network more vulnerable to attack by malicious users or by malicious software such as virus. Before you proceed, we recommend that you evaluate the risks that are associated with implementing this workaround in your particular environment. If you decide to implement this workaround, take any appropriate additional steps to help protect the system.
The SQL Server Report Server Web.config file. This file is located in the ReportServer subfolder of the SQL Server Reporting Services installation, for example: