Sunday, November 6, 2011

SQL 2008 R2 Reporting Services

Installing the SQL 2008 R2 reporting services is definitely a simple and straight forward step where you can just check to enable the option during the SQL 2008 R2 server installation. Often, it is the configuration part that gives you the headache.

When you try to access the SQL reporting or reportserver sites, you might encounter the following error message in the web browser, or the event logs below (screen captures). You might want to check the credentials used to run the SQL reporting service.

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

Bad Data. (Exception from HRESULT: 0x80090005)

 

imageimage

Tried changing the account used to run the reporting service to use the SCOM admin account and it works !!! Smile

No comments:

Post a Comment