Report Builder 2008, MOSS2007 Integrated Mode - Report execution error, The report might not be valid or the server could not process the data, The permissions granted to user 'domain\user' are insufficient for performing this operation. (rsAccessDenied)
Report Builder 2008, MOSS2007 Integrated Mode - Report execution error, The report might not be valid or the server could not process the data, The permissions granted to user 'domain\user' are insufficient for performing this operation. (rsAccessDenied) I am trying to remainpositive about MS's attempts to take on the BI big guns such as BusObj and SAS, but as far as their attempts at a truley integrated BI platform goes, BBBBBAAAAADDDDD. Although SharePoint in Integrated mode might be somewhat there, it is simply just so user UNfriendly with 1 million ways and places to make what should just be a simple change. My current gripe!! I am simply trying to get Report Builder 2008 working in SharePoint 2007 Int mode. I have followed the following steps: 1) created a Report Model project using BIDS 2) set the following settings on the ReportModel Properties - note the data source (DS) uses Windows Authentication TargetDataSourceFolder - http://dprdev182:81/DPRBusIntPres/ReportsLibrary/Self Service Access/ModelDataSources/ TargetModelFolder - http://dprdev182:81/DPRBusIntPres/ReportsLibrary/Self Service Access/Models/ TargetServerURL - http://dprdev182:81/DPRBusIntPres 3) Built and deployed - this created the suffient Folders .SMDL and .RSDS files 4) I then navigated to http://dprdev182:81/DPRBusIntPres > Site Actions > Site Settings > Modify All Site Settings > Advance Permissions 5) I gave myself Full Control I still get the error "Report execution error, The report might not be valid or the server could not process the data, The permissions granted to user 'domain\user' are insufficient for performing this operation. (rsAccessDenied)" Not really anything substantial online about this, except for something called Report Builder Role, but nothing about what it is, or where to apply and configure it.
December 16th, 2010 11:10am

Just bomping this up. Surely someone at Microsoft must know how to set up Report Bulder to work with SharePoint 2007 (in Integrated mode). I cannot believe there are not step-by-step instructions anywhere on this. Please help!
Free Windows Admin Tool Kit Click here and download it now
December 17th, 2010 4:33am

Hi EO-1973, The issue you had is described in section 8.3 in the following article: http://msdn.microsoft.com/en-us/library/ee384252(v=sql.100).aspx I would suggest you going through the article, and check if the steps solve the issue. Thanks, Jin ChenJin Chen - MSFT
December 30th, 2010 4:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics