Hi all,
I've just started planning around the upgrade from SQL 2000, AS2000 and
RS 2000 (All Enterprise Ed) to 2005 and have a architecture question.
Currently I have a SQL Server 2000 box that contains the data
warehouse, analysis server and reporting service metadata. A separate
box contains reporting services (basically the portal with IIS).

Under 2005 is there a best practice around where Analysis Server lives?
I was considering putting it on the same machine as reporting services
or is this even possilbe? My thought is to separate data such as
metadata, data warehouse info from applications or services such as
reporting services or analysis server. Are there pros and cons of
doing this? One other note: I'm considering 64 bit arch.

Thanks for your input!

Dave

you can use the same architecture.
put AS2005 and SQL 2005 on the best server (good disk, cpu and memory)
and keep RS on a server farm.

x64 and 64bits version provides great advantage for AS2005 (and SQL2005)

verify that your IIS applications support the x64bits platform. Sharepoint
doesn't support this, and you must switch IIS in WOW mode and then you can't
install RS2005 x64 on this server. (but you can install the 32bits version)

In my case I install my servers like this:
* Web server: IIS + RS / 1 or 2 CPUs / 2Gb Ram / 2 disks in mirror
* Application server: AS + SQL / 2 to 4 Dual core x64 / 4 to 16Gb / a lot of
disks in raid 0+1!!!!

<davidbr93 (AT) hotmail (DOT) com> wrote