Apr
21
2014

SSRS 2008R2 Error: This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms

While trying to open Report Manager URL via IE received HTTP STATUS CODE 500 error

 

In order to troubleshoot further, reporting log files are analyzed present in MSSRS root folder

 

Log file folder:
<driver>:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles\

 

Error logged:


Error resolution:

As per link, this error is because FIPS (Federal Information Processing Standard 140-1) Compliance was enabled and in order to meet certain standards this is required for audits. One option is to disable but again it might be necessary so the issue is fixed by applying a workaround to specify that ASP.NET use the Triple Data Encryption Standard (3DES) algorithm to process view state data and overcome this error,

 

  • Open Report Manager Web.config file located in path: E:\MSSQL\PR730\APP\MSRS10_50.PR730\Reporting Services\ReportManager.
  • In the Web.config file, locate the <system.web> section.
  • Add the following <machineKey> section to in the <system.web> section:
    <machineKey validationKey=”AutoGenerate,IsolateApps” decryptionKey=”AutoGenerate,IsolateApps” validation=”3DES” decryption=”3DES”/>
  • Save the Web.config file
  • Restart Reporting services

 

Ref:

To enable 3DES:

 

To disable/enable FIPS:

 

Useful references which may fix Authentication errors:

 

Misc.:

 

 

Download PDF

About the Author: Nitin G

Indian born, trekker, biker, photographer, lover of monsoons. I've been working full time with SQL Server since year 2005 and blogs to post the content aquired during my research on new topics or fixing issues faced by me as a DBA while working in different kind of projects, hope some of my posts may helps others in SQLDBA community. Everything you read on my blog is my own personal opinion and any code is provided "AS-IS" with no warranties!

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 239 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

October 2019
M T W T F S S
« Nov    
 123456
78910111213
14151617181920
21222324252627
28293031  

View Post by Categories

%d bloggers like this: