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.

Important

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.

To upgrade an instance of Analysis Services

  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.

    Important

    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.

See Also

Tasks

How to: Migrate Analysis Services Databases

Concepts

Upgrading or Migrating Analysis Services

Help and Information

Getting SQL Server 2005 Assistance