SQL Server Performance

SQL 2008 will Support DB Engine + SSAS or not?

Discussion in 'SQL Server 2008 Clustering' started by rayala.thulasi, Jan 24, 2011.

  1. rayala.thulasi New Member

    Dears, We have DB Engine Services in One Cluster say xx one VIP and Analysis Services in Another Cluster say yy another VIP.
    Can we have both ( DB Engine +SSAS ) in single Cluster environment ? is it possible in SQL Server 2008 of Windows Clustering environment. ? Please let me know whether it's possible or not?
    We are trying to configure the BizTalk in SQL Cluster Environment and we have Database Engine in one Cluster and Analysis Services in another Cluster, but the BTS not configuriging this case. Please sugget me what is the right approch to do the same.
    Regards,
    Thulasi.
  2. satya Moderator

    Good to see some kicking question here...
    Coming back to your topic, yes it is possible to install both DB engine & SSAS services on the same cluster as a new install. Whereas it is not possible as : "You cannot install Analysis Services to the same cluster group as the Database Engine. You must install Analysis Services to its own group and then, after installation, you can move Analysis Services to the same group as SQL Server".
    See this KBA http://support.microsoft.com/default.aspx/kb/910230 about installing Analysis Services on a failover cluster. Installing a SQL Server 2008 Failover Cluster
    http://msdn.microsoft.com/en-us/library/ms179410.aspx
    Before Installing Failover Clustering
    http://msdn.microsoft.com/en-us/library/ms189910.aspx

Share This Page