permissions issue with http driven report in web iframe

Hi there,

I need to understand why I am getting the following error when I run my deployed (remote) report embedded in an iframe within a page of my web application.

error:
An

error has occurred during report processing. (rsProcessingAborted)
Query

execution failed for data set 'cnMOOR'. (rsErrorExecutingCommand)For

more information about this error navigate to the report server on the local

server machine, or enable remote error

This happens when I fire the following code from a commandbutton:
AppSettingsReader cfgApp = new AppSettingsReader();

string prefix = Convert.ToString(cfgApp.GetValue("reporturlprefix", typeof(System.String)));

string reporturl = prefix + "Client&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=False&supplierid=" + Session["supplierId"].ToString() + "&clientid=" + ddlClient.SelectedItem.Value + "&startdate=" + txtStartDate.Text + "&enddate=" + txtEndDate.Text + "&ownertype=1";

SpecificClient.Attributes.Add("src", reporturl);

SpecificClient is the ID of the Iframe

on the same page I created a link - which runs the report perfectly - no permission problems.
<a href="http://server2003msrs/reportserver?/moorreports/Client&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=False&supplierid=28&clientid=71&startdate=2007-01-01&enddate=2007-02-16&ownertype=1">Test</a>

I don't understand why these two controls are behaving differently.

I'd appreciate some guidance with this as the deadline looms...

Helen

Hi there,

something that I didn't mention - this error only happened when I changed the connection string properties. Previously both controls had worked fine.

I eventually fixed it by creating a new report whilst pointing at the new database.

suddenly all of them worked as before.

weird, but that's what solved the issue.

regards Helen

permissions issue with http driven report in web iframe

Hi there,

I need to understand why I am getting the following error when I run my deployed (remote) report embedded in an iframe within a page of my web application.

error:
An

error has occurred during report processing. (rsProcessingAborted)
Query

execution failed for data set 'cnMOOR'. (rsErrorExecutingCommand)For

more information about this error navigate to the report server on the local

server machine, or enable remote error

This happens when I fire the following code from a commandbutton:
AppSettingsReader cfgApp = new AppSettingsReader();

string prefix = Convert.ToString(cfgApp.GetValue("reporturlprefix", typeof(System.String)));

string reporturl = prefix + "Client&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=False&supplierid=" + Session["supplierId"].ToString() + "&clientid=" + ddlClient.SelectedItem.Value + "&startdate=" + txtStartDate.Text + "&enddate=" + txtEndDate.Text + "&ownertype=1";

SpecificClient.Attributes.Add("src", reporturl);

SpecificClient is the ID of the Iframe

on the same page I created a link - which runs the report perfectly - no permission problems.
<a href="http://server2003msrs/reportserver?/moorreports/Client&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=False&supplierid=28&clientid=71&startdate=2007-01-01&enddate=2007-02-16&ownertype=1">Test</a>

I don't understand why these two controls are behaving differently.

I'd appreciate some guidance with this as the deadline looms...

Helen

Hi there,

something that I didn't mention - this error only happened when I changed the connection string properties. Previously both controls had worked fine.

I eventually fixed it by creating a new report whilst pointing at the new database.

suddenly all of them worked as before.

weird, but that's what solved the issue.

regards Helen

Permissions issue- a previous windows group still has full cube rights

Previously, a windows group was added to a 'full access users' role. It was removed and the cube was processed and deployed, replacing rights, but people in that group still have rights to see the data. They are not listed in any roles.

I've looked through all local windows groups on the supporting server and the group in question is not in any groups (ie, if they were in administrators, then they'd have full access through that). The people in the group are not administrators or domain administrators either.

Is there somewhere else I could check on the machine to better find the source of the problem and get the group removed?

Several places to check.

See if you allowed anonymous access to your cubes.
Check memebership of server-wide Admnistrators role.

It is sometimes little hard to track down amongst several groups what exactly is going on. To make sure you are looking at last version of data use SQL Management Studio to verify roles and memberships.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I just checked if other users that never had rights could see the cube and they can't. Anonymous access cannot be allowed.

The windows group "Adminstrators" was checked, but I don't see the admin role present in the dwproj area.
Where would one look besides the roles folder in the solution explorer or this kb: http://msdn2.microsoft.com/en-us/library/ms174561.aspx ? The group is not in any of these areas.

sql mgmt studio was used for examination - the cube was scripted to a file and scanned for groups and user names.

|||

In general there are 2 places to check:
One- role membership. And you check that on database role
Second - access permissions. There are several permissions on different objects. Cube, dimension ...

I also suggested you take a look at memebership of Analysis Server Administrators role and not OS Administrators group.

To access AS Administrators role right click on the Server name in SQL Management Studio and select properties and click on the Security node.

HTH

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||It seems like all of these have been checked. The server security was examined and the cube's xmla was parsed - this should cover any cube/dimension security, right?|||

2 more things.

Make sure you installed latest product update.

And finally. It is good idea to get your security model examined by someone with good knowlege of Analysis Services 2005.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||For product updates, we are on sp1. I could not find any hot fixes related to this.
I will keep investigating and will see if the problem can be recreated on a copy of the cube.

Permission error when trying to set parameters of a server report

Hi There,

I am using SQL Server Reporting Services and generating reports and have them deployed on a report server on Machine A. I have an asp.net web application hosted on MAchine B which has a report viewer control which is used to display a predefined report that is already published on a Reporting Services report server except that it passes a set of parameters for the report. I get this error...The permissions granted to user 'Bla.." are insufficient for performing this operation. (rsAccessDenied) when I try to set the parameters..like this..

param[1] = new Microsoft.Reporting.WebForms.ReportParameter("EndDate", DateTime.Now.ToShortDateString());
param[2] = new Microsoft.Reporting.WebForms.ReportParameter("Site", "1");
reportViewer.ServerReport.SetParameters(param);
reportViewer.ServerReport.Refresh();

I have integrated windows authentication set on the web application (report and report server)

Can anybody suggest me why I am getting this error(breaks at code in red). Any suggestions are greatly aprreciated!!

Thanks.

Sam.

Does the report render fine if you do not set parameters via code?