SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

madcow
Starting Member

1 Posts

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

Hello,

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

nigelrivett
Flowing Fount of Yak Knowledge

United Kingdom
3383 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  
 New 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