Skip to main content

The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database...

In SQL Server Report Manager page, sometimes you may recieve the following error:


Don't worry. Just go to SQL Server Reporting Services 2008 Configuration Manager. Go to Encryption Keys tab. Click on the Delete Encrypted Content button. It will sove the issue.

Comments

Post a Comment

Popular posts from this blog

10 Powerful features for Sharepoint

Windows Sharepoint Services 3.0 and Microsoft Office Sharepoint Server 2007 provide very powerful and wide range of feature riched applicationd which can be very useful for Social Networking and daily computing in any bussiness environment. In this post, I am going to list down 10 very powerful features freely available at codeplex: Podcasting Kit for SharePoint (PKS): Podcasting Kit for Sharepoint (PKS) helps to save time and money for an organization to deliver the next generation knowledgement management solution using social media. Any podcast enabled device along with the general web users can access this highly user interactive sharepoint feature. It is built with Silverlight 2.0 and Microsoft Expression Encoder 2.0 to provide the podcasting solution. To view more and to download the February 2009 beta edition, just go to http://pks.codeplex.com/ . Community Kit for SharePoint(CKS): Community Kit for Sharepoint (CKS) is a bouquet of rich features which make existing features in
Post a Comment
Read more

Programmatically Playing With SSRS Subscriptions

SQL Server Reporting Services offers programmatically handling various report subscriptions. You can read the specific subscriptions and change those in code-behind as required. I assume that you are already aware about the subscription mechanism in reporting services. For some of you who are not aware about this, I would like to write that subscription in reporting services is nothing but a automated service (sql server job) defined and set by you to deliver reports at specific time or in specific events. You also define in which format the report will be presented to the user. Now whatever subscription properties you have set, everything will be stored in the ReportServer database. Schedule, Subscriptions and ReportSchedule tables contain alll those informations. Now create a Windows or Web Application. Add a Web Reference towords ReportingService2006. If SSRS is isntalled on your system then you can easily find the ReportService2006.asmx in the following url: http://servername
Post a Comment
Read more