Hello:
I am architecting the SQL server for high-
availability. Can I put an active/active 2-node cluster
for two instances - one for database and the other for
OLAP (Analysis services)? or Can I use one instance
(active/passive) in a 2-node cluster both DB and OLAP
(Analysis services) exist in the same instance?

Thanks
doc

Analysis Services does support MSCS clustering but only active-passive.
See http://support.microsoft.com/?id=308023
Hope that helps.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"doc pisapati" <doc.pisapati (AT) unisys (DOT) com> wrote

Hello Dave:
Thanks for the response. I am a little bit confused when you
say "not MSCS cluster" and then "active-passive". Can you explain a
little bit more? Actaully, I would like to know whether I can use OLAP
(Analysis services) as another instance of SQL server. Having said that,
I would like to know whether this instance can be hosted on the same
2-node cluster of SQL server database.

Thanks again
doc




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!