How to: Install Analysis Services by Using Setup

You can install Microsoft SQL Server Analysis Services 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 the initial setup of SQL Server. This includes 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 the 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 2008 R2 (Setup) for a 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 Considerations for Installing Analysis Services for more information about other SQL Server features, such as documentation and development tools that you might 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 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

Considerations for Installing Analysis Services

Analysis Services Installation How-to Topics