When attempting to navigate to localhost/reports, the following error occurs: "The service is not available. The report server can't access or use the encryption key"

Last Modified

Tue Mar 19 17:42 GMT 2019

Description

  • When attempting to navigate to localhost/reports, the following error occurs:
    • The service is not available.
    • The report server isn't configured properly. Contact your system administrator to resolve the issue. System administrators: The report server can't access or use the encryption key. You might need to add the server to the scale-out group, reimport encrypted content, or delete all encrypted content and generate a new encryption key.
  • C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles\Reporting Services logs shows:
    • library!DefaultDomain!1a18!03/19/2019-16:22:22:: e Error: Throwing Microsoft.ReportingServices.Diagnostics.Ultilities.CannotValidateEncryptedDataException: , Microsoft.ReportingServices.Diagnostics.Ultilities.CannotValidateEncryptedDataException: The report server was unable to validate the integrity of encrypted data in the database. ---> System.Runtime.InteropServices.COMException: Keysetdoes not exist (Exception from HRESULT: 0x80090016)      at System.Runtime.InteropServices.Marshal.ThrowExceptionFor HRInternal(Int32 errorCode, IntPtr errorInfo)      at RSManagedCrypto.RSCrypto.ReencryptSymmetricKey(Byte[] symKeyBlob, Byte[] pPublicKeyBlob)      at Microsoft.ReportingServices.Library.ConnectionManager.SetNewSymmetricKey(Guid installationID, Byte[] symmetricKey, Byte[] publicKey, KeyStorage storage)

Environment

  • N-able N-central
  • N-able Report Manager

Solution

  • What is happening here is SQL Server Reporting Services is unable to validate the stored encryption keys
  • To resolve you can attempt changing the encryption keys within Reporting Services Configuration Manager:
    1. Open Reporting Services Configuration Manager
    2. Select Encryption Keys
    3. Select Change
  • If this doesn't work then you can try resetting them via Command Prompt:
    1. Open Command Prompt as Administrator
    2. Run the following commands:
      1. cd "C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\"
      2. RSKeyMgmt.exe -s
        • NOTE: If this does not work due to an invalid location, please run the following:
          • dir /s RsKeyMgmt.exe
        • NOTE: More information on this can be found here
  • If you find the above also did not resolve the issue, please do the following:
    1. Open SQL Server Management Studio
    2. Delete ReportServer and ReportServerTemp
    3. Open Reporting Services Configuration Manager
    4. Select Database
    5. Re-create the ReportServer database
    6. Restart the SQL Server Reporting Services