Before you install Microsoft SQL Server Analysis Services, review the following requirements:

• Hardware and Software Requirements for Installing SQL Server 2008
  
• Check Parameters for the System Configuration Checker
  
• Security Considerations for a SQL Server Installation
  

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

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:

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 On the Collation Settings page of the installation wizard, select the Customize for each service account check box. 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. 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.

Tasks

Other Resources