Analysis Services 2000 & 2005 on same server?

Published 10 May 07 01:39 AM | SQL Master 

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.

Comments

No Comments
Anonymous comments are disabled

About SQL Master

**__________________________________** 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.

Search

Go

This Blog

«May 2007»
SMTWTFS
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789

Syndication