|Subject:||What is the best way to setup SSIS, SSRS, SSAS within a two note cluster?|
|Posted by:||AEdw (AEdw.NoSp…@Yellow.com)|
|Date:||Thu, 17 Jul 2008|
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?
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.