Upgrade an Instance of Analysis Services

You can upgrade an existing instance of SQL Server 2005 Analysis Services or SQL Server 2008 Analysis Services to SQL Server 2008 R2, and as part of the upgrade process, migrate existing databases from the old instance to the new instance. To upgrade, run Setup and specify the name of the existing instance as the name of the new instance.

To upgrade an instance of SQL Server 2005 or SQL Server 2008

  1. Before you start, use SQL Server Configuration Manager to get the instance name of Analysis Services. Beginning in SQL Server 2005, support for named instances was added to Analysis Services, giving you the option of installing Analysis Services as the default instance or a named instance.

  2. Run Setup either by using the SQL Server Installation Wizard or at the command prompt. For more information, see How to: Install SQL Server 2008 R2 (Setup).

  3. On the Instance Name page, enter the name of the Analysis Services instance you are upgrading or click the Installed Instances button to select the instance from a drop-down list. When you run Setup at the command prompt, use the instancename option to specify the name of an existing instance.

To upgrade an instance of SQL Server 2000 Analysis Services

  1. Run Setup either by using the SQL Server Installation Wizard or at the command prompt. For more information, see How to: Install SQL Server 2008 R2 (Setup).

  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 at 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.