How to: Install Analysis Services by Using Setup

You can install Microsoft SQL Server 2005 Analysis Services (SSAS) by using the SQL Server Installation Wizard, or you can install it at the command prompt. The Installation Wizard provides a graphical user interface that guides you through each install-time decision, and is the recommended method for most users. The Installation Wizard provides guidance for initial setup of SQL Server 2005, including feature selection, instance naming rules, service account configuration, strong password guidelines, and collation selection.


This topic and the other Analysis Services installation how-to topics in this section focus only on installation options that are specific to Analysis Services. However, these topics provide links to other topics for more information about installation of SQL Server.

To Install Analysis Services by Using Setup

  1. Start the SQL Server Installation Wizard.

  2. Optionally, review How to: Install SQL Server 2005 (Setup) for a page-by-page description of the Installation Wizard, especially if you are installing other SQL Server components in addition to Analysis Services.

  3. On the Components to install page of the Installation Wizard, select Analysis Services. Review Installing SQL Server Analysis Services by Using Setup for more information about other SQL Server features, such as documentation, samples, and development tools, that you may want to include in your installation.

  4. On the Instance name page, select a default or named instance for your installation. If a default instance already exists, or if an instance of SQL Server 2000 Analysis Services that you do not want to upgrade is already present on the computer, you can only select a named instance.

  5. On the Service account page, specify the user name, password, and domain name for the Analysis Services service account and for other SQL Server service accounts. You can use one account for all the services.

  6. On the Collation settings page, specify the default collation. You can use one collation for Analysis Services and another collation for the SQL Server 2005 Database Engine, or you can specify a single collation for all of the services.

  7. Complete the Installation Wizard. The remaining pages of the wizard do not contain option settings that are pertinent to Analysis Services.

See Also

Other Resources

Analysis Services Installation How-to Topics

Help and Information

Getting SQL Server 2005 Assistance