Skip to content

install-analysis-services-in-multidimensional-and-data-mining-mode.md

Latest commit

 

History

History
72 lines (51 loc) · 6.34 KB

install-analysis-services-in-multidimensional-and-data-mining-mode.md

File metadata and controls

72 lines (51 loc) · 6.34 KB
title Install Analysis Services in Multidimensional and Data Mining Mode | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology database-engine
ms.topic conceptual
helpviewer_keywords
installing Analysis Services, about installing Analysis Services
installing Analysis Services
SSAS, installing
Analysis Services, installing
SQL Server Analysis Services, installing
ms.assetid 8a1f33e8-2bd6-4fb8-bd46-c86f2a067f60
author heidisteen
ms.author heidist
manager craigg

Install Analysis Services in Multidimensional and Data Mining Mode

[!INCLUDEssASnoversion] provides online analytical processing (OLAP) and data mining functionality for business intelligence applications. In this release, support for OLAP databases and data mining models is available when you install [!INCLUDEssASnoversion] in Multidimensional mode. Multidimensional mode is one of three server modes that [!INCLUDEssASnoversion] runs in. It is the default mode. If you install [!INCLUDEssASnoversion] using default values, you will get an instance that runs multidimensional databases and data mining models.

[!INCLUDEssASnoversion] is a multi-instance feature, which means that you can install more than one instance [!INCLUDEssASnoversion] on a single computer, or run a new instance of [!INCLUDEssASnoversion] side-by-side an earlier version. Server mode is specific to an instance. Using other modes requires that you install additional instances of the server.

You can install [!INCLUDEssASnoversion] by itself or with other components. If you install just [!INCLUDEssASnoversion], the following features are installed when you select Analysis Services on the Feature Selection page of the [!INCLUDEssNoVersion] Installation Wizard:

  • [!INCLUDEssASnoversion] server for running [!INCLUDEssASnoversion] databases and data mining models

  • Data providers used for [!INCLUDEssASnoversion] data access to source databases

  • SQL Server Configuration Manager

Choosing additional features

Analysis Services OLAP and data warehouse solutions will require the installation of additional [!INCLUDEssNoVersion] components to enable the development, deployment, and administration of [!INCLUDEssASnoversion] databases. The following additional features are options for many typical user scenarios:

  • [!INCLUDEssBIDevStudioFull], used to create and view Analysis Services data structures and data mining models.

  • Client tools connectivity components, used for communication between clients and servers, including network libraries for DB-Library, ODBC, and OLE DB.

  • [!INCLUDEssISnoversion], a set of graphical and programmable objects for moving, copying, and transforming data.

  • Management tools, including [!INCLUDEssNoVersion] Configuration Manager, [!INCLUDEssManStudioFull], [!INCLUDEssSqlProfiler], and Replication Monitor.

Installation Tasks

Installation tasks include the following:

Links Tasks
Hardware and Software Requirements for Installing SQL Server 2014 and Configure Windows Service Accounts and Permissions. Before you run Setup, check prerequisites for installing [!INCLUDEssASnoversion] and determine which account you will use to provision the server.
Install SQL Server 2014 from the Installation Wizard (Setup). Run SQL Server Setup to install the software.
Configure the Windows Firewall to Allow Analysis Services Access After Setup is finished, you must configure firewall settings to allow remote connections to the server.
Authorizing access to objects and operations (Analysis Services) Users who access Analysis Services databases must have Read permission on at least one database on the server.

Related Content

Additional setup content can be found in the following topics:

Install Analysis Services in Tabular Mode

PowerPivot for SharePoint 2010 Installation

Determine the Server Mode of an Analysis Services Instance

SQL Server Data Mining Add-ins

By default, sample databases, sample code, and client application add-ins are not installed as part of [!INCLUDEssNoVersion] Setup. To install sample databases and sample code, see the CodePlex Web site.

See Also

Features Supported by the Editions of SQL Server 2012
Languages and Collations (Analysis Services)
Upgrade Analysis Services