User Access to MS SQL Reporting Services

I am attempting to figure out how to provide Reporting services to users.
This is my first attempt at this and I have been unable to find anything on
this specifically and hope some can point me in the right direction.

I have anonymous access disabled on IIS 6.0 and have enabled Integrated
Access. As a local or domain admin I can access the Report Services and
have folders appear within Report Manager. As an ordinary user I can
understand not being able to gain access to these folders but I have gone
back and added users to newly created folders w/o success.

Is there a web page that goes into some detail on how to configure the user
access, or maybe some info within Books that will help.

I'm all out of ideas and I know I have to be close, it just has to be some
security settings I have overlooked.

--
Paul

Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.

Re: User Access to MS SQL Reporting Services

Got it. Adjusting security in the wrong location.

--
Paul

Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.

"Paul Bergson [MVP-DS]" wrote in message
news:OoNZhxBEIHA.4752@TK2MSFTNGP04.phx.gbl...
>I am attempting to figure out how to provide Reporting services to users.
>This is my first attempt at this and I have been unable to find anything on
>this specifically and hope some can point me in the right direction.
>
> I have anonymous access disabled on IIS 6.0 and have enabled Integrated
> Access. As a local or domain admin I can access the Report Services and
> have folders appear within Report Manager. As an ordinary user I can
> understand not being able to gain access to these folders but I have gone
> back and added users to newly created folders w/o success.
>
> Is there a web page that goes into some detail on how to configure the
> user access, or maybe some info within Books that will help.
>
> I'm all out of ideas and I know I have to be close, it just has to be some
> security settings I have overlooked.
>
> --
> Paul
>
> Please no e-mails, any questions should be posted in the NewsGroup
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>

Re: User Access to MS SQL Reporting Services

It would be very nice to post exactly what you adjusted, for the
benefit of future readers, that achieved what you wanted.


//David
http://w3-4u.blogspot.com
http://blogs.msdn.com/David.Wang
//




On Oct 16, 11:04 am, "Paul Bergson [MVP-DS]"
wrote:
> Got it. Adjusting security in the wrong location.
>
> --
> Paul
>
> Please no e-mails, any questions should be posted in the NewsGroup
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Paul Bergson [MVP-DS]" wrote in messagenews:OoNZhxBEIHA.4752@TK2MSFTNGP04.phx.gbl...
>
>
>
> >I am attempting to figure out how to provide Reporting services to users.
> >This is my first attempt at this and I have been unable to find anything on
> >this specifically and hope some can point me in the right direction.
>
> > I have anonymous access disabled on IIS 6.0 and have enabled Integrated
> > Access. As a local or domain admin I can access the Report Services and
> > have folders appear within Report Manager. As an ordinary user I can
> > understand not being able to gain access to these folders but I have gone
> > back and added users to newly created folders w/o success.
>
> > Is there a web page that goes into some detail on how to configure the
> > user access, or maybe some info within Books that will help.
>
> > I'm all out of ideas and I know I have to be close, it just has to be some
> > security settings I have overlooked.
>
> > --
> > Paul
>
> > Please no e-mails, any questions should be posted in the NewsGroup
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.- Hide quoted text -
>
> - Show quoted text -

Re: User Access to MS SQL Reporting Services

To provide security to MS SQL Server Reporting Services

1) Open up a web browser
2) url = http://servername/reports
3) If there is an button named Show details, click it
4) On the folder you want to provide access, click the edit icon
5) Click the properties tab
6) Click the sub-tab Security
7) Click the "New Role Assignment"
8) Under "Group or user name:", enter the security object name
9) Select the role(s) to assign to this new security object
10) Click Ok

--
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT

http://www.pbbergs.com

Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.

"David Wang" wrote in message
news:1192590494.796527.304880@y27g2000pre.googlegroups.com.. .
> It would be very nice to post exactly what you adjusted, for the
> benefit of future readers, that achieved what you wanted.
>
>
> //David
> http://w3-4u.blogspot.com
> http://blogs.msdn.com/David.Wang
> //
>
>
>
>
> On Oct 16, 11:04 am, "Paul Bergson [MVP-DS]"
> wrote:
>> Got it. Adjusting security in the wrong location.
>>
>> --
>> Paul
>>
>> Please no e-mails, any questions should be posted in the NewsGroup
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Paul Bergson [MVP-DS]" wrote in
>> messagenews:OoNZhxBEIHA.4752@TK2MSFTNGP04.phx.gbl...
>>
>>
>>
>> >I am attempting to figure out how to provide Reporting services to
>> >users.
>> >This is my first attempt at this and I have been unable to find anything
>> >on
>> >this specifically and hope some can point me in the right direction.
>>
>> > I have anonymous access disabled on IIS 6.0 and have enabled Integrated
>> > Access. As a local or domain admin I can access the Report Services
>> > and
>> > have folders appear within Report Manager. As an ordinary user I can
>> > understand not being able to gain access to these folders but I have
>> > gone
>> > back and added users to newly created folders w/o success.
>>
>> > Is there a web page that goes into some detail on how to configure the
>> > user access, or maybe some info within Books that will help.
>>
>> > I'm all out of ideas and I know I have to be close, it just has to be
>> > some
>> > security settings I have overlooked.
>>
>> > --
>> > Paul
>>
>> > Please no e-mails, any questions should be posted in the NewsGroup
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.- Hide quoted text -
>>
>> - Show quoted text -
>
>