Hướng dẫn tải, cài đặt và cấu hình microsoft sql server 2014


In this article

Applies to:

SQL hệ thống Analysis Services
Azure Analysis Services
Power BI Premium

SQL vps Analysis Services is installed by using the SQL hệ thống Installation Wizard (setup.exe). This article describes only those Wizard pages or command line settings necessary for installing and specifying initial configuration settings when installing an Analysis Services instance by using the Wizard.

Bạn đang xem: Hướng dẫn tải, cài đặt và cấu hình microsoft sql server 2014

If you"ve never installed SQL hệ thống or SQL hệ thống Analysis Services before, it"s important you have a good understanding of the Wizard. For more detailed step-by-step information about using the wizard, see Install SQL server from the Installation Wizard (Setup). For more detailed information about Wizard configuration pages, see Installation Wizard help

SQL server Analysis Services is multi-instance, meaning you can install more than one copy on a single computer, or run new and old versions side-by-side. An instance runs in either Tabular mode (default) or Multidimensional mode. If you want khổng lồ run more than one mode, 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 khổng lồ that mode. For example, a tabular mode hệ thống 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 khổng lồ install Analysis Services.

On the Feature Selection page, select Analysis Services from the feature tree.


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

Multidimensional mode uses MOLAP as the default storage for models deployed to Analysis Services. After deploying khổng lồ the server, you can configure a solution lớn use ROLAP if you want lớn 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 lớn get better performance when using non-default storage modes. See vps properties in Analysis Services for more information.

Xem thêm: Châm Ngôn Hay Về Kinh Doanh Giúp Làm Thay Đổi Cuộc Đời Bạn, Danh Ngôn Về Kinh Doanh

Command Line Setup

SQL Server thiết đặt includes a parameter (ASSERVERMODE) that specifies the server mode. The following example illustrates a command line thiết đặt that installs Analysis Services in Tabular vps mode.


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.

TABULARThis is the default value. If you bởi vì not set ASSERVERMODE, the server is installed in Tabular mode.
MULTIDIMENSIONALThis value is optional.

Get tools and designers

The Wizard no longer installs SQL hệ thống Data Tools (SSDT) used for designing models or SQL vps Management Studio (SSMS) used for server administration. Designers and tools now have a separate installation, which you can get from the following links:

You"ll need both Visual Studio with the Analysis Services projects extension & SSMS khổng lồ create, deploy, and work with Analysis Services instances và databases. Tools can be installed anywhere, but be sure khổng lồ configure ports on the vps before attempting a connection. See Configure the Windows Firewall lớn Allow Analysis Services Access for details.

See also

SQL hệ thống Installation WizardDetermine the hệ thống Mode of an Analysis Services InstanceComparing tabular and multidimensional solutions

hotlive |