Skip to main content

ReportBuilder's RSAccessDenied error in SharePoint Integrated Mode

We have an environment where we are wirking with SSRS as SharePoint Integrated Mode. While accessing SSRS Reports thorugh Sharepoint site, we had a requirement that the reports have to be opened using ReportBuilder to make some slight changes and deploy quickly without any dependancies. Well, opening a report using report builder is not an issue but whenever user is trying to run the report from report builder, it is showing the following error:




Believe it or not, I spent almost 3-4 hours to find the issue. I thought it might be a user right related issue so I went to IIS and then try to implement the integrated windows authentication and other stuffs which I found by googling over the internet. But the issue was something completely different from what I was thinking.
I went to SharePoint Central Administration -> Set Server Defaults (Under Reporting Services Section). I noticed that the Enable Ad hoc Report Execution option was unchecked. This was the culprit. By checking this option, finally report builder started running the report. But the surprising thing was that by following the error message it was very hard to determine about what exactly went wrong. Dias Alegré.

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

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.
Post a Comment
Read more