Considerations for Installing Analysis Services

SQL Server Setup

SQL Server provides a single Setup program to install any or all of its components, including Analysis Services. Through Setup, you can install Analysis Services with or without other SQL Server components on a single computer.

This topic highlights important considerations that you should be aware of before you install Analysis Services. Information in this topic will help you evaluate the installation options so that you can make selections that result in a successful installation.

This topic does not include instructions for starting Setup, running Setup from the command line, or using the Installation Wizard. For step-by-step instructions on how to start Setup and select components to install, see Quick-Start Installation of SQL Server 2008. For information about command-line options for installing Analysis Services, see How to: Install SQL Server 2008 from the Command Prompt.

Preparing to Install SQL Server Analysis Services

Selecting Components to Install

While you can install Analysis Services alone, note that many data warehouse solutions require the installation of additional SQL Server components to enable the development, deployment, and administration of Analysis Services databases. The following table describes these additional SQL Server 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, 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.

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 Reporting Services components, including administrative tools and reports.

X

Integration Services

   SQL Server Integration Services, 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 components.

X

X

X

Options for Installing Analysis Services

You can install Analysis Services in the following configurations:

  • Install Analysis Services on a computer with no previous instances of SQL Server.
  • Install SQL Server 2008 Analysis Services side-by-side with an existing instance of SQL Server 2005 Analysis Services or of SQL Server 2000 Analysis Services.
  • Upgrade an existing instance of SQL Server 2005 Analysis Services or of SQL Server 2000 Analysis Services to SQL Server 2008 Analysis Services.

Installing SQL Server Analysis Services

After you review the installation requirements for SQL Server and verify that your computer meets those requirements, you are ready to install SQL Server Analysis Services.

If you are using the Installation Wizard to install Analysis Services, you will use a series of pages to specify the components and options. The following table lists only those pages in the Installation Wizard where the options that you select affect your installation of Analysis Services:

Page Recommendations

Components to Install

Select Analysis Services to install the Analysis Services service.

Select Workstation components, Books Online and development tools to install tools and documentation.

Instance Name

You can specify only one instance name on the Instance Name page for all the SQL Server 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.

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

When you do a side-by-side installation with SQL Server 2005 Analysis Services, you must install SQL Server 2008 Analysis Services as a uniquely named instance

Service Account

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 specified for the instance during setup.

Authentication Mode

This page sets the authentication provider for the Database Engine. SQL Server Analysis Services supports only Windows Authentication.

Collation Settings

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 collation options, see Collation and Unicode Support.

See Also