March 26, 2014 at 11:41 pm
Hi All,
I'm getting the below error when trying to expand any folder in Reporting services in SSMS.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
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) (Reporting Services SOAP Proxy Source)
------------------------------
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) (ReportingServicesLibrary)
------------------------------
Bad Data. (Exception from HRESULT: 0x80090005) () (mscorlib)
------------------------------
BUTTONS:
OK
------------------------------
Your help would be greatly appreciated
Kris
March 26, 2014 at 11:54 pm
You need to open up the Reporting Services Configuration Manager on the server it is installed on, and "Restore" the encrypted key file (you will need the password used to encrypt it).
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply