Access Denied

Hi,
I'm trying to open a report directly from the browser like this:
http://servername/ReportServer?/reportname&FromDate=1/1/2005&rs:Command=Render
but I get the error message:
The permissions granted to user 'NETEX-SERVER\IUSR_NETEX-SERVER' are
insufficient for performing this operation. (rsAccessDenied)
Do I need to change the Role defenitions? How do I do that?
Thanks,
LimorYou need to be added to the Report Browser group at a minimum
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Limor Bellison" <LimorBellison@.discussions.microsoft.com> wrote in message
news:95353788-5D8B-41CC-AB72-62F24FD7CE35@.microsoft.com...
> Hi,
> I'm trying to open a report directly from the browser like this:
> http://servername/ReportServer?/reportname&FromDate=1/1/2005&rs:Command=Render
> but I get the error message:
> The permissions granted to user 'NETEX-SERVER\IUSR_NETEX-SERVER' are
> insufficient for performing this operation. (rsAccessDenied)
> Do I need to change the Role defenitions? How do I do that?
> Thanks,
> Limor
>|||How do I do that?
"Wayne Snyder" wrote:
> You need to be added to the Report Browser group at a minimum
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Limor Bellison" <LimorBellison@.discussions.microsoft.com> wrote in message
> news:95353788-5D8B-41CC-AB72-62F24FD7CE35@.microsoft.com...
> > Hi,
> > I'm trying to open a report directly from the browser like this:
> >
> > http://servername/ReportServer?/reportname&FromDate=1/1/2005&rs:Command=Render
> >
> > but I get the error message:
> >
> > The permissions granted to user 'NETEX-SERVER\IUSR_NETEX-SERVER' are
> > insufficient for performing this operation. (rsAccessDenied)
> >
> > Do I need to change the Role defenitions? How do I do that?
> >
> > Thanks,
> >
> > Limor
> >
> >
>
>

Accesing cube browser

My boss saw the Browser tab of a cube in an Analysis Services project in BIDS. He says he want to access it for designing his own reports in real time. I suppose the cube browser is not intended to be used directly by the users but if the boss says he want it, he means he want it.

So I wonder if there is any way to access the cube browser from managed code. Is it any kind of ActiveX control or any other thing callable by code?

Hi,

I am also facing the same problem.

Ronald

|||The cube browser in BIDS contains different controls, which were not developed for public use. One can still use its major part - Office Pivot Table, which is a part of the Office WEB Components, but in order to write programs with it one needs to have the "design time license". Otherwise the component will switch to view only mode.

Besides the license problems with OWC one would have to write additional code to expose the metadata according to AS2005 rules. The metadata browser of the pivot table shows maps the metadata according to AS2000 rules and we make it hidden.|||One more comment. If the boss will be content with calling "something" while the "report model" would be right in the BIDS's Cube Browser page then it is possible to write Visual Studio Add - In, which would access the pivot table throught its documented object model.

Write me at andrewgaATmsnDOTcom and i will send back a zip with a short C# project, which can be used as a starting point. Although i did not go any further that starting point myself (the goal was different).

Accesing cube browser

My boss saw the Browser tab of a cube in an Analysis Services project in BIDS. He says he want to access it for designing his own reports in real time. I suppose the cube browser is not intended to be used directly by the users but if the boss says he want it, he means he want it.

So I wonder if there is any way to access the cube browser from managed code. Is it any kind of ActiveX control or any other thing callable by code?

Hi,

I am also facing the same problem.

Ronald

|||The cube browser in BIDS contains different controls, which were not developed for public use. One can still use its major part - Office Pivot Table, which is a part of the Office WEB Components, but in order to write programs with it one needs to have the "design time license". Otherwise the component will switch to view only mode.

Besides the license problems with OWC one would have to write additional code to expose the metadata according to AS2005 rules. The metadata browser of the pivot table shows maps the metadata according to AS2000 rules and we make it hidden.|||One more comment. If the boss will be content with calling "something" while the "report model" would be right in the BIDS's Cube Browser page then it is possible to write Visual Studio Add - In, which would access the pivot table throught its documented object model.

Write me at andrewgaATmsnDOTcom and i will send back a zip with a short C# project, which can be used as a starting point. Although i did not go any further that starting point myself (the goal was different).