Saturday, February 25, 2012

Reporting Services Deployment Problem

I'm new to Reporting Services and whenever I try to deploy a report I've
build in .NET, I have to turn off anonymous access to the ReportServer folder
in IIS. I imagine that Reporting Services wasnt installed correctly or that
there is some way to fix this. However, I havent been able to find any help
by searching the web or other sites I usually find helpful. Does anyone know
how to fix this?I suspect I am also in the same set of issues. My configuration is SQL
Server 2005, IIS5.1 on XP-SP2 using VS.NET 2005. The tool I am using to
debug IIS is the IIS 6.0 RK. I think my problems are related to it appears
that RS wants to be on a real server with SSL and Kerberos. NT
authentication doesn't appear to be enough to get to the virtual drive?
Al
"Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> I'm new to Reporting Services and whenever I try to deploy a report I've
> build in .NET, I have to turn off anonymous access to the ReportServer
> folder
> in IIS. I imagine that Reporting Services wasnt installed correctly or
> that
> there is some way to fix this. However, I havent been able to find any
> help
> by searching the web or other sites I usually find helpful. Does anyone
> know
> how to fix this?|||You lose functionality if you have anonymous access because everyone is
treated the same. RS uses roll based security. What I do is setup local
groups. To the local groups I add the appropriate domain groups/users. The
local group is assigned to a roll with certain rights, usually just browse
rights.
Here is a good link to read up on security.
http://odetocode.com/Articles/215.aspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> I'm new to Reporting Services and whenever I try to deploy a report I've
> build in .NET, I have to turn off anonymous access to the ReportServer
folder
> in IIS. I imagine that Reporting Services wasnt installed correctly or
that
> there is some way to fix this. However, I havent been able to find any
help
> by searching the web or other sites I usually find helpful. Does anyone
know
> how to fix this?|||Bruce,
That may be helpful, but it looks cumbersome. I'm deploying reports across
a company Intranet. Would using role based security require me to give every
single user (there are a LARGE number) an account? What I would really like
is a way to have an 'anonymous' user group that can only browse the reports -
that way I dont spend half of my time fielding requests for access to the
reports and setting up new accounts. Any suggestions?
Derek
"Bruce L-C [MVP]" wrote:
> You lose functionality if you have anonymous access because everyone is
> treated the same. RS uses roll based security. What I do is setup local
> groups. To the local groups I add the appropriate domain groups/users. The
> local group is assigned to a roll with certain rights, usually just browse
> rights.
> Here is a good link to read up on security.
> http://odetocode.com/Articles/215.aspx
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
> news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > I'm new to Reporting Services and whenever I try to deploy a report I've
> > build in .NET, I have to turn off anonymous access to the ReportServer
> folder
> > in IIS. I imagine that Reporting Services wasnt installed correctly or
> that
> > there is some way to fix this. However, I havent been able to find any
> help
> > by searching the web or other sites I usually find helpful. Does anyone
> know
> > how to fix this?
>
>|||Most domains have a generic group that everyone in the domain belongs to.
For instance yourdomain\users, at my company it is ourdomain\domain users.
So you should be able to just add that group once.
If you have resource kit installed there is a dos command called showgrps
that will show you all the groups you are part of, this would show you the
catchall group.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
news:79E8F3FF-5113-4DE8-83D9-5E3371FF89A9@.microsoft.com...
> Bruce,
> That may be helpful, but it looks cumbersome. I'm deploying reports
across
> a company Intranet. Would using role based security require me to give
every
> single user (there are a LARGE number) an account? What I would really
like
> is a way to have an 'anonymous' user group that can only browse the
reports -
> that way I dont spend half of my time fielding requests for access to the
> reports and setting up new accounts. Any suggestions?
> Derek
> "Bruce L-C [MVP]" wrote:
> > You lose functionality if you have anonymous access because everyone is
> > treated the same. RS uses roll based security. What I do is setup local
> > groups. To the local groups I add the appropriate domain groups/users.
The
> > local group is assigned to a roll with certain rights, usually just
browse
> > rights.
> >
> > Here is a good link to read up on security.
> >
> > http://odetocode.com/Articles/215.aspx
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
> > news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > > I'm new to Reporting Services and whenever I try to deploy a report
I've
> > > build in .NET, I have to turn off anonymous access to the ReportServer
> > folder
> > > in IIS. I imagine that Reporting Services wasnt installed correctly
or
> > that
> > > there is some way to fix this. However, I havent been able to find
any
> > help
> > > by searching the web or other sites I usually find helpful. Does
anyone
> > know
> > > how to fix this?
> >
> >
> >|||Bruce,
Thanks for your help. I'm a bit over my head in this discussion - since I'm
a developer with very little to no experience in network administration /
server administration but I will look into setting up role based security.
Thanks for your help.
Derek
"Bruce L-C [MVP]" wrote:
> Most domains have a generic group that everyone in the domain belongs to.
> For instance yourdomain\users, at my company it is ourdomain\domain users.
> So you should be able to just add that group once.
> If you have resource kit installed there is a dos command called showgrps
> that will show you all the groups you are part of, this would show you the
> catchall group.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
> news:79E8F3FF-5113-4DE8-83D9-5E3371FF89A9@.microsoft.com...
> > Bruce,
> >
> > That may be helpful, but it looks cumbersome. I'm deploying reports
> across
> > a company Intranet. Would using role based security require me to give
> every
> > single user (there are a LARGE number) an account? What I would really
> like
> > is a way to have an 'anonymous' user group that can only browse the
> reports -
> > that way I dont spend half of my time fielding requests for access to the
> > reports and setting up new accounts. Any suggestions?
> >
> > Derek
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > You lose functionality if you have anonymous access because everyone is
> > > treated the same. RS uses roll based security. What I do is setup local
> > > groups. To the local groups I add the appropriate domain groups/users.
> The
> > > local group is assigned to a roll with certain rights, usually just
> browse
> > > rights.
> > >
> > > Here is a good link to read up on security.
> > >
> > > http://odetocode.com/Articles/215.aspx
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
> > > news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > > > I'm new to Reporting Services and whenever I try to deploy a report
> I've
> > > > build in .NET, I have to turn off anonymous access to the ReportServer
> > > folder
> > > > in IIS. I imagine that Reporting Services wasnt installed correctly
> or
> > > that
> > > > there is some way to fix this. However, I havent been able to find
> any
> > > help
> > > > by searching the web or other sites I usually find helpful. Does
> anyone
> > > know
> > > > how to fix this?
> > >
> > >
> > >
>
>|||That's OK. A network admin or server admin will be able to translate my
suggestion and the link I sent you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
news:036B5699-7C2E-4F8D-BBEE-4CD1084C1EAD@.microsoft.com...
> Bruce,
> Thanks for your help. I'm a bit over my head in this discussion - since
I'm
> a developer with very little to no experience in network administration /
> server administration but I will look into setting up role based security.
> Thanks for your help.
> Derek
> "Bruce L-C [MVP]" wrote:
> > Most domains have a generic group that everyone in the domain belongs
to.
> > For instance yourdomain\users, at my company it is ourdomain\domain
users.
> > So you should be able to just add that group once.
> >
> > If you have resource kit installed there is a dos command called
showgrps
> > that will show you all the groups you are part of, this would show you
the
> > catchall group.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
> > news:79E8F3FF-5113-4DE8-83D9-5E3371FF89A9@.microsoft.com...
> > > Bruce,
> > >
> > > That may be helpful, but it looks cumbersome. I'm deploying reports
> > across
> > > a company Intranet. Would using role based security require me to
give
> > every
> > > single user (there are a LARGE number) an account? What I would
really
> > like
> > > is a way to have an 'anonymous' user group that can only browse the
> > reports -
> > > that way I dont spend half of my time fielding requests for access to
the
> > > reports and setting up new accounts. Any suggestions?
> > >
> > > Derek
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > You lose functionality if you have anonymous access because everyone
is
> > > > treated the same. RS uses roll based security. What I do is setup
local
> > > > groups. To the local groups I add the appropriate domain
groups/users.
> > The
> > > > local group is assigned to a roll with certain rights, usually just
> > browse
> > > > rights.
> > > >
> > > > Here is a good link to read up on security.
> > > >
> > > > http://odetocode.com/Articles/215.aspx
> > > >
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in
message
> > > > news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > > > > I'm new to Reporting Services and whenever I try to deploy a
report
> > I've
> > > > > build in .NET, I have to turn off anonymous access to the
ReportServer
> > > > folder
> > > > > in IIS. I imagine that Reporting Services wasnt installed
correctly
> > or
> > > > that
> > > > > there is some way to fix this. However, I havent been able to
find
> > any
> > > > help
> > > > > by searching the web or other sites I usually find helpful. Does
> > anyone
> > > > know
> > > > > how to fix this?
> > > >
> > > >
> > > >
> >
> >
> >

No comments:

Post a Comment