Keeping IIS and SQL Server on seperate boxes

Hi,
I have a problem in that I have one server with IIS and another with SQL
Server 2000. I would like to run SSRS from the SQL Server and then store all
my pages on the IIS server. Is there a way of doing this. Only installing
SSRS on the SQL Server and then everything else on the IIS server. I have
installed SSRS on a server that has both SQL Server and IIS on it and no
problems. The thing is I need the Virtual Directories on the IIS server and
not the SQL Server box. I am not allowed to install SSRS on the IIS box as
this would mean another license which my company is not prepared to do.
Please any help on how this could be done would be greatly appreciated.
ThanksThe license is clear. Anywhere you install the server component of RS you
need a license. What you are asking not only can not be done from a
licensing perspective but RS itself is an asp.net application. The SQL
Server DB is an object repository and can reside either on the same box or
on another box. However, if it is on another box you need a server license.
You didn't say if you are doing an intranet or internet application. If you
are not doing a processor license (which is what you would have to do if it
was for the internet but if intranet is optional) but instead have CALs.
Assuming the people accessing it already have CALs (in my case they do) then
all you need to do is buy the server license. For standard addition it is
very inexpensive to buy another server license. Even for enterprise
(assuming you have the CALs, a very important point) it is still much less
expensive than any other solution I am aware of.
Bruce L-C
"PLSH" <PLSH@.discussions.microsoft.com> wrote in message
news:AC4DF146-4A24-4A12-8440-6D6230AD6C4E@.microsoft.com...
> Hi,
> I have a problem in that I have one server with IIS and another with SQL
> Server 2000. I would like to run SSRS from the SQL Server and then store
all
> my pages on the IIS server. Is there a way of doing this. Only installing
> SSRS on the SQL Server and then everything else on the IIS server. I have
> installed SSRS on a server that has both SQL Server and IIS on it and no
> problems. The thing is I need the Virtual Directories on the IIS server
and
> not the SQL Server box. I am not allowed to install SSRS on the IIS box as
> this would mean another license which my company is not prepared to do.
> Please any help on how this could be done would be greatly appreciated.
> Thanks