Monday, February 20, 2012

Reporting Services: Role Assignment without using Report Manager

Hello,

I'm having some problems using the Report Manager, but I *really* need
to make a role assignment now. Can't wait to have the problem with
Report Manager solved.
So, I would like to make this role assignment directly in the
ReportServer database, using the SP SetPolicy or some other SP.

I'm looking for the equivalent of making the "New Role Assignment" and
then
Group or user name: Everyone
Role "Browser" checked
OK

Can anyone tell me exactly how to do this?

Thanks in advance,

Filipe Henriques

PS: By the way, the problem I've got using the Report Manager is that
always appear "The request failed with HTTP status 404: Not Found.",
although I can see perfectly the Report Server page.
Does anyone knows what's the problem?"Filipe Henriques" <filipehenriquespt@.hotmail.com> wrote in message
news:f545f620.0410080044.7ca7b54e@.posting.google.c om...
> Hello,
> I'm having some problems using the Report Manager, but I *really* need
> to make a role assignment now. Can't wait to have the problem with
> Report Manager solved.
> So, I would like to make this role assignment directly in the
> ReportServer database, using the SP SetPolicy or some other SP.
> I'm looking for the equivalent of making the "New Role Assignment" and
> then
> Group or user name: Everyone
> Role "Browser" checked
> OK
> Can anyone tell me exactly how to do this?
> Thanks in advance,
> Filipe Henriques
>
> PS: By the way, the problem I've got using the Report Manager is that
> always appear "The request failed with HTTP status 404: Not Found.",
> although I can see perfectly the Report Server page.
> Does anyone knows what's the problem?

You might want to try posting this in
microsoft.public.sqlserver.reportingsvcs.

Simon|||>
> You might want to try posting this in
> microsoft.public.sqlserver.reportingsvcs.
> Simon

Already did.
No luck yet.|||Ok, I found this link:

http://blogs.msdn.com/bryanke/archi...3/17/91736.aspx

for "Sample Script for Setting Item-level Security in Reporting Services".

It's all I need.

No comments:

Post a Comment