Installing and configuring Local SQL Server Reporting Services

Your installation may work the first time, if so great!  I was not so lucky...

Attempted to launch the Report manager web page and it failed to load.

I was able to find the following error in the Reporting Services log file:

 

e ERROR: Throwing 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), ;

 

A search of Microsoft knowledge base turned up the following article:

Error message when the Report Server service starts or when you try to access the Reporting Services Web site in SQL Server 2008: "Key not valid for use in specified state"

The cause was apparently related to changing the Reporting service account after the product was installed.

Since I had no backup of the symmetric key, I chose method 2 Delete the encrypted content.

 

image

 

Back up and running!

Published Thursday, September 18, 2008 3:54 PM by sthompson
Filed under: ,

Comments

No Comments
Powered by Community Server (Commercial Edition), by Telligent Systems