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

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

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

Changing IIS Emulation Modes

In 64 bit Windows 2003, you may need to change the emulation mode of IIS depending upon the cases and conditions. To change the IIS emulation mode to 32 bit to 64 bit and vice versa, do the followings: Open command promp and run the following command cd C:\Inetpub\Adminscripts (I am assuming that C is your windows drive) cscript adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1 (to make it 32 bit) cscript adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 0 (to make it 64 bit) iisreset