Install SQL Server Analysis Services

APPLIES TO: yesSQL Server Analysis Services noAzure Analysis Services noPower BI Premium

SQL Server Analysis Services is installed by using the SQL Server Installation Wizard.

SQL Server Analysis Services is multi-instance, which means that you can install more than one copy on a single computer, or run new and old versions side-by-side. Any instance you install runs in one of three modes, as determined during setup: Multidimensional and Data Mining, Tabular, or SharePoint. If you want to use multiple modes, you'll need a separate instance for each one.

After you install the server in a particular mode, you can use it host solutions that conform to that mode. For example, a tabular mode server is required if you want tabular model data access over the network.

Install using the wizard

The following shows which pages in the SQL Server Installation wizard are used to install Analysis Services.

  1. Select Analysis Services from the Feature Tree in Setup.

    Setup feature tree showing Analsyis Services

  2. On the Analysis Services Configuration page, select a mode. Tabular mode is the default..

    Setup page with Analysis Services config options

Tabular mode uses the VertiPaq in-memory analytics engine (VertiPaq), which is the default storage for tabular models. After you deploy tabular models to the server, you can selectively configure tabular solutions to use DirectQuery disk storage as an alternative to memory-bound storage.

Multidimensional and Data Mining mode use MOLAP as the default storage for models deployed to Analysis Services. After deploying to the server, you can configure a solution to use ROLAP if you want to run queries directly against the relational database rather than storing query data in an Analysis Services multidimensional database .

Memory management and IO settings can be adjusted to get better performance when using non-default storage modes. See Server properties in Analysis Services for more information.

Command Line Setup

SQL Server Setup includes a parameter (ASSERVERMODE) that specifies the server mode. The following example illustrates a command line setup that installs Analysis Services in Tabular server mode.

Setup.exe /q /IAcceptSQLServerLicenseTerms /ACTION=install /FEATURES=AS /ASSERVERMODE=TABULAR /INSTANCENAME=ASTabular /INDICATEPROGRESS /ASSVCACCOUNT=<DomainName\UserName> /ASSVCPASSWORD=<StrongPassword> /ASSYSADMINACCOUNTS=<DomainName\UserName>   

INSTANCENAME must be less than 17 characters.

All placeholder account values must be replaced with valid accounts and password.

ASSERVERMODE is case-sensitive. All values must be expressed in upper case. The following table describes the valid values for ASSERVERMODE.

Value Description
TABULAR This is the default value. If you do not set ASSERVERMODE, the server is installed in Tabular mode.
MULTIDIMENSIONAL This value is optional.
POWERPIVOT This value is optional. In practice, if you set the ROLE parameter, the server mode is automatically set to 1, making ASSERVERMODE optional for a Power Pivot for SharePoint installation. For more information, see Install Power Pivot from the Command Prompt.

Get tools and designers

SQL Server Setup no longer installs the model designers or management tools used for solution design or server administration. In this release, tools have a separate installation, which you can get from the following links:

You'll need both Visual Studio and SSMS to create, deploy, and work with Analysis Services instances and databases. Tools can be installed anywhere, but be sure to configure ports on the server before attempting a connection. See Configure the Windows Firewall to Allow Analysis Services Access for details.

See also

Determine the Server Mode of an Analysis Services Instance