2-tier app and db arrangement, where to install RS?

Running a .NET web app on a web app server, while SQL 2000 (standard) runs on
a separate DB server behind it.
Question is, can I install RS on the DB server and still serve reports from
the web/app server? So as to avoid an extra SQL license for installing RS on
that box?
I noticed RS install requests IIS and ASP.NET installed and running, would
have avoided this otherwise on the DB server but if it means I can somehow
serve reports to the web/app server and ultimately to the
application-end-user, all without installing and licensing RS on the other
machine, I'm considering it.
Kind of a RS newb, thx in advance.
--
mjsReally, has no one done this?
--
mjs|||I have not done this but people definitely have. The issue comes down to
security integration. There is an issue called double hop.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sds/sds/troubleshooting_authentication_problems_on_asp_pages.asp
So, you will have to decide if the time and effort is worth the savings of
the license messing with security is worth it. When RS is on the same box as
your app, none of this happens.
People have definitely gotten this to work, but it is something to consider.
For more on it google: double hop IIS
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mjs" <mjs@.discussions.microsoft.com> wrote in message
news:03BA6336-E99D-41C4-8E10-7C8731F97179@.microsoft.com...
> Running a .NET web app on a web app server, while SQL 2000 (standard) runs
> on
> a separate DB server behind it.
> Question is, can I install RS on the DB server and still serve reports
> from
> the web/app server? So as to avoid an extra SQL license for installing RS
> on
> that box?
> I noticed RS install requests IIS and ASP.NET installed and running, would
> have avoided this otherwise on the DB server but if it means I can somehow
> serve reports to the web/app server and ultimately to the
> application-end-user, all without installing and licensing RS on the other
> machine, I'm considering it.
> Kind of a RS newb, thx in advance.
> --
> mjs|||Ignoring the issue of double hop, is there any links on how to make this work?
"Bruce L-C [MVP]" wrote:
> I have not done this but people definitely have. The issue comes down to
> security integration. There is an issue called double hop.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sds/sds/troubleshooting_authentication_problems_on_asp_pages.asp
> So, you will have to decide if the time and effort is worth the savings of
> the license messing with security is worth it. When RS is on the same box as
> your app, none of this happens.
> People have definitely gotten this to work, but it is something to consider.
> For more on it google: double hop IIS
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "mjs" <mjs@.discussions.microsoft.com> wrote in message
> news:03BA6336-E99D-41C4-8E10-7C8731F97179@.microsoft.com...
> > Running a .NET web app on a web app server, while SQL 2000 (standard) runs
> > on
> > a separate DB server behind it.
> >
> > Question is, can I install RS on the DB server and still serve reports
> > from
> > the web/app server? So as to avoid an extra SQL license for installing RS
> > on
> > that box?
> >
> > I noticed RS install requests IIS and ASP.NET installed and running, would
> > have avoided this otherwise on the DB server but if it means I can somehow
> > serve reports to the web/app server and ultimately to the
> > application-end-user, all without installing and licensing RS on the other
> > machine, I'm considering it.
> >
> > Kind of a RS newb, thx in advance.
> >
> > --
> > mjs
>
>|||setspn and 'trust for delegation'
I think that Microsoft does a HORRIBLE job of describing this
functionality to real enterprise customers.
2/3rds of the companies (that is a big number-- like 20 companies out
of 30) that I've worked for in the past 5 years STILL USE SQL
AUTHENTICATION-- merely because Microsoft won't teach people how to
configure double-hop authentication
-Aaron
Loon wrote:
> Ignoring the issue of double hop, is there any links on how to make this work?
> "Bruce L-C [MVP]" wrote:
> > I have not done this but people definitely have. The issue comes down to
> > security integration. There is an issue called double hop.
> >
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sds/sds/troubleshooting_authentication_problems_on_asp_pages.asp
> >
> > So, you will have to decide if the time and effort is worth the savings of
> > the license messing with security is worth it. When RS is on the same box as
> > your app, none of this happens.
> >
> > People have definitely gotten this to work, but it is something to consider.
> > For more on it google: double hop IIS
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "mjs" <mjs@.discussions.microsoft.com> wrote in message
> > news:03BA6336-E99D-41C4-8E10-7C8731F97179@.microsoft.com...
> > > Running a .NET web app on a web app server, while SQL 2000 (standard) runs
> > > on
> > > a separate DB server behind it.
> > >
> > > Question is, can I install RS on the DB server and still serve reports
> > > from
> > > the web/app server? So as to avoid an extra SQL license for installing RS
> > > on
> > > that box?
> > >
> > > I noticed RS install requests IIS and ASP.NET installed and running, would
> > > have avoided this otherwise on the DB server but if it means I can somehow
> > > serve reports to the web/app server and ultimately to the
> > > application-end-user, all without installing and licensing RS on the other
> > > machine, I'm considering it.
> > >
> > > Kind of a RS newb, thx in advance.
> > >
> > > --
> > > mjs
> >
> >
> >