Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
madcow
Starting Member
1 Post |
 Posted - 2012-11-15 : 09:25:32
|
| 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
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-11-15 : 10:13:16
|
| 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. |
 |
|
|
|
|
|
SQL2008R2 Clustering with SSAS