Report manager URL throwing error after disabling the FIPS in SQL Server Reporting Services 2016 and 2017 for custom authentication mode

• smngsh

  SSC Enthusiast

  Points: 188

  More actions

  December 26, 2018 at 11:08 pm

  #369742

  Hi All,

  I am using SSRS custom authentication mode for viewing and uploading reports. So when I am Enabling the FIPS in our system And Added the machineKey for the both in ReportServer "Web.config" as well as in "Microsoft.ReportingServices.Portal.WebHost.exe.config", Its works fine.
  <machineKey validationKey="AutoGenerate,IsolateApps" decryptionKey="AutoGenerate,IsolateApps" validation="3DES" decryption="3DES" />

  But when I Disabled the FIPS and restart the same machine, I am only able to get the Report manager login page and once I enter the login credential I am the getting following error.

  "Error: The remote server returned an error: (500) Internal Server Error.
  Description: System.Net.WebException: The remote server returned an error: (500) Internal Server Error. at System.Net.HttpWebRequest.GetResponse() at AFRViewerWebService.Impersonizer.GetResponse(Uri uri, HttpContext context, WindowsIdentity identity, Boolean isSQLServerVersion2016)"

  I have also checked the SSRS log for the same
  
  I am getting this issue for SQL Server Reporting Services 2016 and SQL Server Reporting Services 2017.(Although the machine key is deleting automatically after the every restart of SSRS in case of "SQL Server Reporting Services 2017").   

  Please, can anyone help me out.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  December 27, 2018 at 3:52 pm

  #2017466

  smngsh - Wednesday, December 26, 2018 11:08 PM

  Hi All,

  I am using SSRS custom authentication mode for viewing and uploading reports. So when I am Enabling the FIPS in our system And Added the machineKey for the both in ReportServer "Web.config" as well as in "Microsoft.ReportingServices.Portal.WebHost.exe.config", Its works fine.
  <machineKey validationKey="AutoGenerate,IsolateApps" decryptionKey="AutoGenerate,IsolateApps" validation="3DES" decryption="3DES" />

  But when I Disabled the FIPS and restart the same machine, I am only able to get the Report manager login page and once I enter the login credential I am the getting following error.

  "Error: The remote server returned an error: (500) Internal Server Error.
  Description: System.Net.WebException: The remote server returned an error: (500) Internal Server Error. at System.Net.HttpWebRequest.GetResponse() at AFRViewerWebService.Impersonizer.GetResponse(Uri uri, HttpContext context, WindowsIdentity identity, Boolean isSQLServerVersion2016)"

  I have also checked the SSRS log for the same
  
  I am getting this issue for SQL Server Reporting Services 2016 and SQL Server Reporting Services 2017.(Although the machine key is deleting automatically after the every restart of SSRS in case of "SQL Server Reporting Services 2017").   

  Please, can anyone help me out.

  Can't tell specifics but it's something with how you have configured forms authentication. You would configure things differently for 2016 and 2017. Some of the differences around machine keys would be in this documentation:
  How to install custom security extensions

  Maybe try following the links at the end of that article to verify your configurations. Other than that, it likely would be whatever is being done in the code for authentication.
  And I thought they were trying to make this easier - forms authentication is not fun. That's as nicely as I can put it.

  Sue