Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 SQL2008R2 Clustering with SSAS
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 11/15/2012 :  09:25:32  Show Profile  Reply with Quote


We have a Win2008R2Ent/SQL2008R2Ent running BI Cubes sitting in the Extranet Zone. We would like to cluster this SQL2008R2 SSAS Server and have a 2 node cluster.

One node which is in Extranet zone and the other we would like to place is in the Coporate LAN for internal users to accss the cubes so there is a firewall in between.

The SQL Server in the extranet is for extenal user access via Sharepoint. The internal SQL Node will be for internal user access.

I know it will work (thinking out loud) will SSAS work in this design???? Is SSAS Cluster aware????

Advise Please.

Thank you

Flowing Fount of Yak Knowledge

United Kingdom
3385 Posts

Posted - 11/15/2012 :  10:13:16  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
Yes SSAS is cluster aware.
How many SSAS instances do you want?
It seems a bit odd to have the two nodes (servers) of the cluster in different zones (if that is what you mean). The idea is that the instance can fail over from one node to the other and still be available to the users.
Note ken on using the term node as it can mean different things.

Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000