Installing SQL Server Analysis Services

Step 1: Preparing to Install SQL Server 2005 Analysis Services

Before you install Microsoft SQL Server 2005 Analysis Services (SSAS), review the following requirements:

Step 2: Installing SQL Server 2005 Analysis Services

After you review the installation requirements for SQL Server 2005 and verify that your computer meets those requirements, you are ready to install SQL Server 2005 Analysis Services. Depending on your environment, you install Analysis Services in one of the following ways:

  • Installing SQL Server 2005 Analysis Services on a Clean Computer
  • Installing SQL Server 2005 Analysis Services Side-by-Side with SQL Server 2000 Analysis Services
  • Upgrading to SQL Server 2005 Analysis Services

Installing SQL Server 2005 Analysis Services on a Clean Computer

As with any component in SQL Server 2005, you can install Analysis Services either by running SQL Server Setup through the SQL Server Installation Wizard, or by running the Setup program at the command prompt.

Option 1: Using the SQL Server Installation Wizard

You can install Analysis Services on the local computer or on a failover cluster by using the SQL Server Installation Wizard.

Topic Description

Installing SQL Server Analysis Services by Using Setup

Setup information that is specific to SQL Server 2005 Analysis Services.

How to: Install SQL Server 2005 (Setup)

Setup information that describes each step in the SQL Server Installation Wizard, and that applies to all components of SQL Server 2005, including Analysis Services.

Option 2: Running the Setup program from the command prompt

You can run SQL Server Setup at the command prompt. You must run the Setup program at the command prompt when you install Analysis Services on a remote computer.

Topic Description

Installing SQL Server Analysis Services from the Command Prompt

Command prompt setup information that is specific to Analysis Services.

How to: Install SQL Server 2005 from the Command Prompt

Command prompt setup information that describes each step and option of the command prompt setup process, and that applies to all components of SQL Server 2005, including Analysis Services.

Back to Top

Installing SQL Server 2005 Analysis Services Side-by-Side with SQL Server 2000 Analysis Services

You can install SQL Server 2005 Analysis Services as a named instance side-by-side with the default instance of Microsoft SQL Server 2000 Analysis Services. Because SQL Server 2000 Analysis Services does not support named instances, the SQL Server 2000 Analysis Services instance must always be the default instance in a side-by-side installation.

You can also migrate existing SQL Server 2000 Analysis Services databases to the SQL Server 2005 Analysis Services database format while leaving the existing databases intact.

Topic Description

Upgrading or Migrating Analysis Services

General information about side-by-side installation and database migration.

Migrating Existing Analysis Services Databases

Information about the Analysis Services Migration Wizard and the differences between SQL Server 2000 Analysis Services and SQL Server 2005 Analysis Services database objects.

SQL Server 2005 Analysis Services Backward Compatibility

Information about discontinued and deprecated features and behavior changes from SQL Server 2000 Analysis Services to SQL Server 2005 Analysis Services.

Back to Top

Upgrading to SQL Server 2005 Analysis Services

You can upgrade to SQL Server 2005 Analysis Services from an earlier version of Analysis Services by using Setup, or by using several utility programs in addition to SQL Server Setup.

To upgrade during Setup, enter the instance name of an existing instance of SQL Server 2000 Analysis Services. To upgrade after installing a named instance of SQL Server 2005 Analysis Services, use the Analysis Services Migration Wizard to move your existing Analysis Services databases to the new server instance. You can then optionally uninstall SQL Server 2000 Analysis Services and use the Analysis Services Instance Rename tool to make the instance of SQL Server 2005 Analysis Services the default instance.

Topic Description

Upgrading or Migrating Analysis Services

General information about side-by-side installation and database migration.

Migrating Existing Analysis Services Databases

Information about the Analysis Services Migration Wizard and the differences between SQL Server 2000 Analysis Services and SQL Server 2005 Analysis Services database objects.

SQL Server 2005 Analysis Services Backward Compatibility

Information about discontinued and deprecated features and behavior changes from SQL Server 2000 Analysis Services to SQL Server 2005 Analysis Services.

Back to Top

See Also

Other Resources

Installing SQL Server 2005 Components

Help and Information

Getting SQL Server 2005 Assistance