There is no "standard" answer to this question. You could put reporting
services on either box, or on its own box. If both of these database
servers have a heavy load, you probably want to put reporting services on
its own box. Remember that reporting services requires IIS, which will add
to the overhead on whatever machine you locate it on, and may have
infrastructure implications beyond just the database load.
If one of the servers is SQL Standard, and the other SQL Enterprise, and you
want to use forms-based authentication to protect your reporting solution,
but you don't want to buy another Enterprise license, then you'll need to
put it on the Enterprise box.
Again, there are too many variables to put out a standard answer. Every
deployment is unique, particularly the large-scale data warehouse
deployments.

Signature
Cheers,
'(' Jeff A. Stucker
\
> Hi,
>
[quoted text clipped - 13 lines]
>
> Jerome.
Phil Austin - 25 Mar 2005 11:59 GMT
If extra boxes aren't an option you may also want to consider placing RS on
the 2 CPU box and putting AS on the 4 CPU server along with your data
warehouse. AS is very memory intensive and although you don't say how much
memory each server has I'm guessing that the 4-way has considerably more
than the 2-way. You'll also eliminate the network traffic between the data
warehouse and the AS machine every time the cubes are processed which may be
a bottleneck.
The best advice is to test a number of configurations if you have the
time...
Phil.
> There is no "standard" answer to this question. You could put reporting
> services on either box, or on its own box. If both of these database
[quoted text clipped - 29 lines]
> >
> > Jerome.