What is the best way to setup SSIS, SSRS, SSAS within a two note cluster?

[AEdw]

Hi All,

I'm fairly new Clustering and I'm looking for advices. I have successfully
setup a test SQL Server Database Engine on a two node ( passive/active )
cluster using MS Virtual Server. I would now like to setup SQL Server
Reporting, Integration, and Analysis Services on the same cluster. I know
Reporting Services and Integration Services are not cluster aware. Can
anyone give me advices on the best way to install these three components for
high availability within a two node cluster. Are there any good articles or
install guides on the web?

Current Setup:
1) SQL Server 2005 Ent - Windows 2003 Ent
2) Node1 - Windows 2003 Ent
3) Node2 - Windows 2003 Ent

Sorry if my Cluster terminology is incorrect.

Many thanks
Colin

[Denny Cherry]

SSAS is easy. It's cluster aware. Simply run through the installer
again and install it as a clustered resource.

Here's a link on setting up SSIS as a clustered resource.
http://www.sqljunkies.com/WebLog/knight_reign/archive/2005/07/06/16015.aspx

SSRS should be setup behind a load balancer. If you need to setup
SSRS as a clustered resource use the same technique as the SSIS
article, just make sure that you cluster IIS, and SSRS within the same
resource group. You'll need to make sure to setup SSRS on both nodes,
or manually add the registry keys to be replicated between nodes.

Denny

On Thu, 17 Jul 2008 11:55:09 +0100, "AEdw" <AEdw....@Yellow.com>
wrote: