Analysis Services 2000 & 2005 on same server?
Can we handle SQL Server Analysis Services 2000 and 2005 versions on the same server?
Yes it is possible, but in the real sense you have to more careful to attain the performance by having a high-end specificiation hardware to cope up the pressure. Theoritically it is possible but I haven't seen any practical instance of such installation so far.
In addition to this only in the case of migration you might need to, otherwise I wouldn't suggest to install on same server. When you install Analysis Services 2005 on a machine that already has Analysis Services 2000 installed and you choose to install to the default instance, you are prompted to run the Migration Wizard during the installation. If you choose not to use the wizard at installation, you can use it later as a stand-alone tool.
**__________________________________**
SQL Server MVP, Sr. DBA & industry expert.
-
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.