Welcome Guest Search | Active Topics | Members | Log In | Register

User Access to MS SQL Reporting Services Options · View
Paul Bergson [MVP-DS]
Posted: Tuesday, October 16, 2007 7:45:44 AM


Rank: Guest
Groups: Guest

Joined: 9/17/2007
Posts: 11,670
Points: -1,200
Date parsed: 16/10/2007 07:45:44
Date: Tue, 16 Oct 2007 12:45:44 -0500

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.


Paul Bergson [MVP-DS]
Posted: Tuesday, October 16, 2007 8:04:50 AM


Rank: Guest
Groups: Guest

Joined: 9/17/2007
Posts: 11,670
Points: -1,200
Date parsed: 16/10/2007 08:04:50
Date: Tue, 16 Oct 2007 13:04:50 -0500

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]" <pbergson@allete_nospam.com> 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.
>
>


David Wang
Posted: Tuesday, October 16, 2007 1:08:14 PM


Rank: Guest
Groups: Guest

Joined: 9/17/2007
Posts: 11,670
Points: -1,200
Date parsed: 16/10/2007 13:08:14
Date: Tue, 16 Oct 2007 20:08:14 -0700

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]"
<pbergson@allete_nospam.com> 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]" <pbergson@allete_nospam.com> 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 -


Paul Bergson [MVP-DS]
Posted: Monday, October 22, 2007 1:54:50 AM


Rank: Guest
Groups: Guest

Joined: 9/17/2007
Posts: 11,670
Points: -1,200
Date parsed: 22/10/2007 01:54:50
Date: Mon, 22 Oct 2007 06:54:50 -0500

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" <w3.4you@gmail.com> 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]"
> <pbergson@allete_nospam.com> 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]" <pbergson@allete_nospam.com> 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 -
>
>


Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

YAFPro Theme Created by Jaben Cargman (Tiny Gecko)
Powered by Yet Another Forum.net version 1.9.1.1 (NET v2.0) - 9/10/2007
Copyright © 2003-2006 Yet Another Forum.net. All rights reserved.
This page was generated in 0.133 seconds.