Installing SQL Server Analysis Services by Using Setup

Note

For detailed information about using the Microsoft SQL Server Installation Wizard to install SQL Server 2005 products components, we recommend that you review How to: Install SQL Server 2005 (Setup).

This topic contains only information specific to the installation of Microsoft SQL Server 2005 Analysis Services (SSAS) by using the SQL Server Installation Wizard.

  • Selecting Components to Install
  • Specifying Analysis Services File Locations
  • Specifying Analysis Services Instances
  • Specifying Analysis Services Service Accounts
  • Specifying Analysis Services Authentication Mode
  • Specifying Analysis Services Collation

Selecting Components to Install

While you can install Analysis Services alone, note that many data warehouse solutions require the installation of additional SQL Server 2005 components to enable the development, deployment, and administration of Analysis Services databases. The following table describes these additional or optional SQL Server 2005 components.

Component For the Administrator For the Developer For Optional Use

Connectivity Components

   Components for communication between clients and servers, including network libraries for DB-Library, ODBC, and OLE DB.

X

X

Management Tools

   Interactive tools for managing SQL Server 2005, including SQL Server Configuration Manager, SQL Server Management Studio, SQL Server Profiler, and Replication Monitor.

X

Business Intelligence Development Studio

   The integrated development environment for business intelligence projects.

X

Software Development Kit

   Software that assists developers in creating custom solutions for SQL Server 2005.

X

SQL Server Database Services

   The SQL Server Database Engine and tools for managing relational and XML data, replication, and full-text search.

X

Reporting Services

   A report server, for managing, executing, rendering, and distributing reports, and the Report Manager, a Web-based user interface that provides access to SQL Server 2005 Reporting Services (SSRS) components, including administrative tools and a user interface for viewing reports.

X

Integration Services

   SQL Server 2005 Integration Services (SSIS), a set of graphical and programmable objects for moving, copying, and transforming data.

X

Documentation and Samples

   SQL Server Books Online documentation, programming reference material, and samples for all SQL Server 2005 components.

X

X

X

Installing Selected Components

You can install Analysis Services alone or with additional SQL Server 2005 components, as described in the following procedures.

To install Analysis Services alone

  • On the Components to Install page of the SQL Server Installation Wizard, select only Analysis Services.

    Note

    If you choose to install only Analysis Services, then SQL Server 2005 client components, including command-line tools, connectivity components, programming models, management and development tools, and documentation and samples, are not installed by default.

To add or remove installation components by using the Components to Install page

  • On the Components to Install page of the installation wizard, select or clear the check boxes for those components that you want to add or remove.

    Note

    Selecting the Workstation components, Books Online and development tools installation option on the Components to Install page does not select the sample databases and programming samples by default. You must select these options manually on the Feature Selection page.

To add or remove installation components by using the Feature Selection page

  1. On the Components to Install page, click Advanced.

  2. On the Feature Selection page, select the check boxes for those components that you want to add and clear the check boxes for those components that you want to remove.

    Note

    The Feature Selection page is a good way to view a detailed list of installation options in the SQL Server Installation Wizard, including the components previously listed in this topic.

Specifying Analysis Services File Locations

SQL Server 2005 Setup puts Analysis Services program files, data files, and shared files in several locations. Each instance of Analysis Services has a separate set of folders in which the program and data files for the instance are stored. The default folder locations for Analysis Services files are listed in the following table.

Analysis Services files Default location

Instances of SQL Server 2005 and Analysis Services

C:\Program Files\Microsoft SQL Server\MSSQL.n

where the number n represents the sequence in which the multiple instances were installed, starting with 1. This location can be changed during setup.

Data and shared files for an instance of Analysis Services

C:\Program Files\Microsoft SQL Server\MSSQL.n\OLAP\Data

C:\Program Files\Microsoft SQL Server\MSSQL.n\OLAP\bin

Components that are shared by all instances of the SQL Server 2005 component

C:\Program Files\Microsoft SQL Server\90\Shared

This folder cannot be changed during installation.

Tools, documentation, and samples

C:\Program Files\Microsoft SQL Server\90\Tools

A single set of tools and documentation is installed for all instances of Analysis Services and other SQL Server components.

To change the default Analysis Services file locations during installation

  1. On the Components to Install page of the installation wizard, click Advanced.

  2. On the Feature Selection page, click a feature that supports a non-default installation path, and then click Browse.

  3. In the Installation path box of the Change Folders page, enter a new file location.

Important

You can now use the Feature Selection page of the installation wizard to install certain SQL Server 2005 components to a location other than the default location of %ProgramFiles%\Microsoft SQL Server\90. This option is available for SQL Server 2005 Integration Services (SSIS), SQL Server 2005 Notification Services, and Workstation Components (which are client tools, documentation, and samples). The corresponding switch to use when you install at the command prompt is installsqlshareddir.

Specifying Analysis Services Instances

On the Instance Name page of the SQL Server Installation Wizard, you can specify whether to install a default instance or a named instance of SQL Server 2005 Analysis Services. You can install only one default instance of SQL Server 2005 Analysis Services. A default instance is not required.

You can specify only one instance name on the Instance Name page for all the SQL Server 2005 components that you have selected for installation. Therefore you cannot, for example, install a default instance of the SQL Server Database Engine and a named instance of Analysis Services at the same time. In these circumstances, you must run Setup separately for each instance name that you want to use.

If an instance of SQL Server 2000 Analysis Services is already installed on the server, then you can only install a named instance of SQL Server 2005 Analysis Services, unless you upgrade the existing default instance to SQL Server 2005 Analysis Services. When you enter the name of an existing instance on the Instance Name page of the SQL Server Installation Wizard, the Components to Upgrade page asks you to confirm your intention to upgrade the existing instance.

When you install SQL Server 2005 Analysis Services side-by-side with SQL Server 2000 Analysis Services, you must install SQL Server 2005 Analysis Services as a named instance.

If you are installing multiple instances of SQL Server 2005 Analysis Services on a single server, you may want to use named instances only, so that you can provide meaningful names to distinguish the instances.

Note

A Microsoft SQL Server 2005 Enterprise Edition license entitles you to install multiple instances of SQL Server 2005 Analysis Services on a single computer. Other editions of SQL Server 2005 require a separate license for each instance. For complete details, refer to the licensing agreement packaged with your product.

For more information about side-by-side SQL Server 2000 Analysis Services and SQL Server 2005 Analysis Services installation scenarios, see Upgrading or Migrating Analysis Services.

You can use the Analysis Services Instance Rename tool to rename an installed instance of SQL Server 2005 Analysis Services, or to make a named instance the default instance when no default instance exists.

For more information, see How to: Rename an Instance of Analysis Services.

Specifying Analysis Services Service Accounts

Analysis Services starts and runs as a Microsoft Windows service. This service appears in the list of installed services in SQL Server Configuration Manager and in Services, the Microsoft Management Console (MMC) snap-in that provides administrative support for Windows services.

Each instance of Analysis Services is supported by its own service, and each instance can use different settings for collation and other server options. The service names for each instance reflect the instance names that you specify during setup. The service name for the default instance is MSSQLServerOLAPService. The service name for a named instance is **MSOLAP$**instancename, where instancename is the name that you specify for the instance during setup.

The account used to run the Analysis Services service must be a member of local the Administrators group.

To view an Analysis Services service in the Services snap-in

  1. Click Start, point to All Programs, point to Administrative Tools, and then click Services.

  2. In the list of services, look for one of the following entries:

    • For the default instance of Analysis Services, look for MSSQLServerOLAPService.
    • For a named instance of Analysis Services, look for **MSOLAP$**instancename.

For more information about SQL Server 2005 service accounts, see Setting Up Windows Service Accounts.

Specifying Analysis Services Authentication Mode

SQL Server 2005 Analysis Services supports only Windows Authentication.

Specifying Analysis Services Collation

Analysis Services uses the same collation designators and sort order settings as the SQL Server Database Engine. If you are installing both Analysis Services and the SQL Server Database Engine under the same instance name, you can choose to use the same settings or different settings for the two servers. If you choose to use different settings, you must configure Analysis Services and the SQL Server Database Engine separately, as described in the following procedure.

To use separate collation settings for Analysis Services and the SQL Server Database Engine

  1. On the Collation Settings page of the installation wizard, select the Customize for each service account check box.

  2. Next to Service, select Analysis Services, and then configure the collation options for Analysis Services.

    Note

    The SQL collations option does not apply for Analysis Services and is not available when you configure the Analysis Services collation options.

  3. Next to Service, select Database Engine and configure the collation options for the SQL Server Database Engine.

For more information about SQL Server 2005 collation options, see Collation Options and International Support.

See Also

Concepts

Installing SQL Server Analysis Services

Help and Information

Getting SQL Server 2005 Assistance