Export (0) Print
Expand All

How to: Upgrade an Instance of Analysis Services

You can upgrade an existing instance of Microsoft SQL Server 2000 Analysis Services to Microsoft SQL Server 2005 Analysis Services (SSAS) and, as part of the upgrade process, migrate existing databases from the old instance to the new instance. To upgrade an existing instance of SQL Server 2000 Analysis Services, run Setup and specify the name of the existing instance as the name of the new instance.

ms143473.note(en-US,SQL.90).gifImportant:
This topic and the accompanying Analysis Services upgrade and migration how-to topics focus only on upgrade and migration options that are specific to Analysis Services. However, these topics provide links to other topics for more information about installation of SQL Server.

  1. Run Setup either by using the SQL Server Installation Wizard or from the command prompt. For more information about how to run Setup by using the SQL Server Installation Wizard, see How to: Install Analysis Services by Using Setup. For more information about how to run Setup from the command prompt, see How to: Install Analysis Services from the Command Prompt.

    ms143473.note(en-US,SQL.90).gifImportant:
    When upgrading from a 64-bit edition of Microsoft SQL Server 2000 to a 64-bit edition of Microsoft SQL Server 2005, you must upgrade Analysis Services before upgrading the Database Engine.

  2. When you use the SQL Server Installation Wizard, select Default Instance on the Instance Name page. To confirm the presence of the SQL Server 2000 Analysis Services instance, you can click the Installed Instances button. When you run Setup from the command prompt, use the instancename option to specify the name of an existing instance of SQL Server 2000 Analysis Services. Because SQL Server 2000 Analysis Services does not support named instances, the name of the existing instance is usually the name of the server.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft