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:
- Hardware and Software Requirements for Installing SQL Server 2005
- Check Parameters for the System Configuration Checker
- Security Considerations for a SQL Server Installation
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 |
|---|---|
Setup information that is specific to SQL Server 2005 Analysis Services. |
|
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. |
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 |
|---|---|
General information about side-by-side installation and database migration. |
|
Information about the Analysis Services Migration Wizard and the differences between SQL Server 2000 Analysis Services and SQL Server 2005 Analysis Services database objects. |
|
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 |
|---|---|
General information about side-by-side installation and database migration. |
|
Information about the Analysis Services Migration Wizard and the differences between SQL Server 2000 Analysis Services and SQL Server 2005 Analysis Services database objects. |
|
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