Muistiinpano
Tämän sivun käyttö edellyttää valtuutusta. Voit yrittää kirjautua sisään tai vaihtaa hakemistoa.
Tämän sivun käyttö edellyttää valtuutusta. Voit yrittää vaihtaa hakemistoa.
Applies to: 
SQL Server Analysis Services 
Azure Analysis Services
Fabric/Power BI Premium
Use the SQL Server Installation Wizard (setup.exe) to install SQL Server Analysis Services. This article describes only the wizard pages and command-line settings for an Analysis Services instance's initial configuration.
If you're new to installing SQL Server or SQL Server Analysis Services, learn how the wizard works. For step-by-step instructions, see Install SQL Server from the Installation Wizard (Setup). For details about wizard configuration pages, see Installation Wizard help.
SQL Server Analysis Services supports multiple instances on a single computer, including instances of new and old versions that run side by side. An instance runs in either Tabular mode (default) or Multidimensional mode. If you want to run more than one mode, you need a separate instance for each one.
After you install the server in a particular mode, use it to host solutions that conform to that mode. For example, use a tabular mode server to access tabular model data over the network.
Install using the wizard
Use the following pages in the SQL Server Installation Wizard to install Analysis Services.
On the Feature Selection page, select Analysis Services from the feature tree.
On the Analysis Services Configuration page, select the Server Configuration tab, select a mode, and add users to grant them admin permissions for the instance. Select the Data Directories tab to check the default data directories or specify different directories.
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 mode uses MOLAP as the default storage for Analysis Services models. After you deploy a model to the server, configure the solution to use ROLAP to run queries directly against the relational database instead of storing query data in an Analysis Services multidimensional database.
Adjust memory management and I/O settings to improve performance with nondefault storage modes. For more information, see Server properties in Analysis Services.
Command-line setup
SQL Server Setup uses the ASSERVERMODE parameter to specify the server mode. The following command 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.
The ASSERVERMODE parameter is case-sensitive. Enter all values in uppercase. The following table lists the valid values.
| 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. |
Get tools and designers
The wizard no longer installs SQL Server Data Tools (SSDT) for model design or SQL Server Management Studio (SSMS) for server administration. Designers and tools now have a separate installation. To learn about and install both Microsoft and third-party tools, see Analysis Services tools.
You need both Visual Studio with the Analysis Services projects extension and SSMS to create, deploy, and work with Analysis Services instances and databases. You can install tools 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.