Post reply

SSRS - Report server cannot access the private key for the service account

  • June 15, 2015 at 10:52 pm

    #301533

    Hi,

    I have SQL 2008R2 installed, SSRS 2008R2 is throwing the below errors and reports arent coming up.

    The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) Get Online Help Keyset does not exist (Exception from HRESULT: 0x80090016)

    Upon checking the active directory I can find the password passlastset is year 2014 thats used for SSRS. I see bunch of security patch were applied from Windows Group. Every time the server goes in reboot cycle this issue happens. Any idea on how to fix it.

    Thanks,

    NM

  • June 16, 2015 at 5:36 am

    #1805704

    I've seen this if you copied an existing ReportServer and ReportServerTemp db from one instance and restored them on another, ie copying a backup from Production To Test OR QA.

    If that's what has happened here, you need to go to the original Report Manager on the server, and backup the key on the original server, and then Restore it on the Other instance

    I answered a similar issue a while back, where someone was creating Prod vs Test.

    http://www.sqlservercentral.com/Forums/Topic1653346-150-1.aspx

    it's important to note that all the data sources will probably still point to production(unless they explicitly pointed to localhost)

    so you'll need to change some connections a swell; hopefully it's all shared data sources, so you change them in a central location.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 16, 2015 at 6:17 am

    #1805715

    No there was no migration of report server DB's. It was implemented here on this server and its not a DEV -> PROD migration.

  • June 16, 2015 at 6:43 am

    #1805721

    Have you tried backing up the key? Any issues there?

  • June 16, 2015 at 8:43 am

    #1805755

    Yes I have tried backing up keys and its good. No issues over there. I am looking out for a cause why its happening.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply