locked
Reporting Services Error RRS feed

  • Question

  • I'm getting this error while tryings to access the reportserver:

     

    "The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError)"

     

    How should I resolve this?

     

    Thank you

     

    Thursday, July 31, 2008 2:23 AM

Answers

All replies

  • Thursday, July 31, 2008 8:43 AM
    Moderator
  • Thursday, July 31, 2008 7:53 PM
  • Below Error and solution

    System.Web.Services.Protocols.SoapException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> Microsoft.ReportingServices.Diagnostics.Utilities.RPCException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: Bad Data. (Exception from HRESULT: 0x80090005)
       --- End of inner exception stack trace ---
       --- End of inner exception stack trace ---
       --- End of inner exception stack trace ---
       --- End of inner exception stack trace ---
       --- End of inner exception stack trace ---
       at Microsoft.ReportingServices.Diagnostics.DataProtection.ProtectData(Byte[] unprotectedData, String tag)
       at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()


       at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
       at Microsoft.ReportingServices.Library.DBInterface.GetAllConfigurationInfo()
       at Microsoft.ReportingServices.Library.RSService.GetSystemProperties(Property[] requestedProperties)
       at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values)
       --- End of inner exception stack trace ---
       at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values) (System.Web.Services)

    Solution

    • Do you happen to have a backup of your encryption key?  If not, follow these steps:
    • Open Reporting Services Configuration Manager
    • Connect to your RS server
    • Select 'Encryption Keys' from the left pane
    • Press the 'Delete' button to get rid of your encrypted content
    •  
    • After doing this, you will need to re-set the connection strings and stored credentials on your reports.
    • Also, I'd be sure to make a backup of the encryption key afterwards.
    •  
    • If you do have a backup, press the 'Restore' button instead of the 'Delete' button.

    Enjoy
    Sisira sahu
    Appshark S/w Ltd
    Hydrabad
    www.appshark.com
    My MSVBusinessCard Link
    https://www.mcpvirtualbusinesscard.com/VBCServer/81f2e667-1d54-43b7-abc3-9fb4660a0d46/interactivecard

     

    Friday, February 26, 2010 5:18 AM