Cluster active/active SQLServer/SSAS

Hi,

I'd like to know how I can setup a Windows cluster with one node for SQL
Server and one node for Analysis Services ?

Please advise ? many thanks for your answers
--
TH

It appears that you are trying to configure a multiple instance SQL Server
failover cluster. In order to achieve this goal you will require at least
two servers, shared storage device (blessed by Microsoft), public network
and a private network for the cluster heartbeat communications. In
addition, you will require separate LUNS or partitions for each SQL Server
Instance and the quorum.



You will then need to first install Windows Clustering



Windows Server 2003 Cluster



http://www.microsoft.com/downloads/details.aspx?familyid=96f76ed7-9634...00-9159



Then install SQL Server Clustering x 2



SQL Server Cluster



http://technet.microsoft.com/en-us/library/ms143219.aspx



An excellent resource which covers your exact configuration and step by step
installations for Windows, SQL Server including prerequisites is located in
the failover chapter.



http://www.amazon.com/SQL-Server-2005-Management-Administration/dp/067...9565/re


Thanks Ross Mistry

"9_points" wrote in message

> Hi,
>
> I'd like to know how I can setup a Windows cluster with one node for SQL
> Server and one node for Analysis Services ?
>
> Please advise ? many thanks for your answers
> --
> TH