Considerations for Installing Analysis Services
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 R2. For information about command-line options for installing Analysis Services, see How to: Install SQL Server 2008 R2 from the Command Prompt.
Before you install Microsoft SQL Server Analysis Services, review the following requirements:
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.
For the Administrator
For the Developer
For Optional Use
Components for communication between clients and servers, including network libraries for DB-Library, ODBC, and OLE DB.
Interactive tools for managing SQL Server, including SQL Server Configuration Manager, SQL Server Management Studio, SQL Server Profiler, and Replication Monitor.
Business Intelligence Development Studio
The integrated development environment for business intelligence projects.
Software Development Kit
Software that assists developers in creating custom solutions for SQL Server.
SQL Server Database Services
The SQL Server Database Engine and tools for managing relational and XML data, replication, and full-text search.
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.
SQL Server Integration Services, a set of graphical and programmable objects for moving, copying, and transforming data.
Documentation and Samples
SQL Server Books Online documentation, programming reference material, and samples for all SQL Server components.
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.
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:
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.
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
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.
This page sets the authentication provider for the Database Engine. SQL Server Analysis Services supports only Windows Authentication.
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
For more information about SQL Server collation options, see Collation and Unicode Support.