SQL Clusters and Analysis Services DSO -
12-14-2004
, 06:17 PM
Greetings,
Although this may relate more to Analysis Services administration, I
thought I'd post it here in case someone with the administrative side
of OLAP subscribes to this Group.
I have a need to run Analysis Services on a single Server instance, but
obtaining its data from a SQL Server Cluster. I gather Analysis
Services is not designed to work within a SQL Cluster. However, the
Analysis Services instance outside the SQL Cluster will need to
communicate with the appropriate SQL Server maintained data within that
cluster.
Does anyone know if there are any problems with installing the Decision
Support Objects (DSO) within a SQL Cluster?
If this configuration does work, are there any issues that I would need
to consider?
I do need Analysis Services to also integrate with an IIS based we
application and I know that there are no issues with having DSO
installed on that box.
Any constructive feedback would be very much appreciated.
Cheers,
Wayne |