You should be able to connect without problems using the normal
<server>/<instance> naming convention in the connection string.
Obviously if you are using AS2k the standard limitation that a single
cube must come from a single data source still applies. Otherwise there
should not be any issues.
I have a client running a 64-bit Active/Active SQL cluster and we can
connect to databases on either instance without any trouble.
--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
In article <CC6A4BCD-0EA2-4CF2-A46E-AAB50D38FD77 (AT) microsoft (DOT) com>, "=?Utf-
8?B?U1FMIER1bW1laCAjMQ==?=" <SQL Dummeh #1 (AT) discussions (DOT) microsoft.com>
says...
Quote:
Stupid Question for the day here: I am running a SQL Cluster at work and
would like to setup a stand-alone server to run Analysis Services. I would
like to know if Analysis Services can connect to multiple instances of SQL
that are running on virtual servers in a clustered environment?
Any help would be greatly appreciated.... |