Saturday, February 25, 2012

Clustrer DB engine and SAS?

Is it possible to create a SQL Server 2005 cluster and run SAS 2005 clustered on the same servers?

In particular I want to run a cluster of 6 servers as follows:-

* 3 active servers running mulitple instances of SQL Server 2005
* 1 active server running Reporting Servies and Analysis Services
* 2 passive servers for failover

Is this feasible and pratical?

Thanks
Ken
Yes, it is. SSAS will install into a cluster just like the Database Engine will. You generally don't cluster Reporting Services though since it simply relies on a database which would already be covered by clustering the SQL Server instance that is hosting the repository database.

No comments:

Post a Comment