July 28, 2010 at 8:49 pm
I do not have much exposure to SSRS, please help me. We have installed SSRS 2005 standard edition 2 years back and worked fine until now. Now we the error message saying it needs to decryption key. mentioned below are my questions please advice
i) we do not have any decryption key, is there any place or any log file where i can find it?
ii) i did read couple articles mentioning i will need to reconfigure SSRS, if i do this will i loose all my reports data?
thanks
July 28, 2010 at 9:24 pm
Have you recently restored your reporting services database?
Have you been backing up your SSRS keys?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 29, 2010 at 7:25 am
No for both. But the problem is fixed now after bouncing the server, should i back up the encryption key now?
July 29, 2010 at 8:48 am
Yes. You should include that in your regular backup plan. You can use Reporting Services Configuration Manager tool to do the backup of the key.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 2, 2010 at 4:59 am
Hi,
Recently I have faced the Encryption & Decryption issue in SSRS , even I have not set any kind of properties , the easy solution I found on the net is following :
a. Go to the SSRS Configuration Manager
b. Select the option of Encryption Keys (select Delete Encrypted Content)
Let me know if this helps!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply