安装 SQL Server Analysis ServicesInstall SQL Server Analysis Services

适用于: SQL Server Analysis Services Azure Analysis Services Power BI Premium

SQL Server Analysis Services 使用 SQL Server 安装向导进行安装。SQL Server Analysis Services is installed by using the SQL Server Installation Wizard.

SQL Server Analysis Services 为多实例,这意味着可以在一台计算机上安装多个副本,或并行运行新版本和旧版本。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. 安装的任何示例都以三种模式之一运行,这是在安装期间确定的:多维和数据挖掘、表格或 SharePoint。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

下面显示 SQL Server 安装向导中的哪些页用于安装 Analysis Services。The following shows which pages in the SQL Server Installation wizard are used to install Analysis Services.

  1. 从安装程序的功能树中选择 “Analysis Services”Select Analysis Services from the Feature Tree in Setup.

    设置显示 Analsyis Services 的功能树Setup feature tree showing Analsyis Services

  2. 在 "Analysis Services 配置" 页上,选择一种模式。On the Analysis Services Configuration page, select a mode. 表格模式为默认值。Tabular mode is the default..

    包含 Analysis Services 配置选项的“设置”页Setup page with Analysis Services config options

表格模式使用 VertiPaq 内存中分析引擎 (VertiPaq) ,这是表格模型的默认存储。Tabular mode uses the VertiPaq in-memory analytics engine (VertiPaq), which is the default storage for tabular models. 将表格模型部署到服务器之后,可以有选择性地配置表格解决方案,以便将 DirectQuery 磁盘存储用作内存绑定存储的替代方法。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.

多维和数据挖掘模式使用 MOLAP 作为部署到 Analysis Services 的模型的默认存储。Multidimensional and Data Mining mode use MOLAP as the default storage for models deployed to Analysis Services. 在部署到服务器之后,如果你想直接对关系数据库允许查询而不是将查询数据存储在 Analysis Services 多维数据库中,你可以配置解决方案以使用 ROLAP。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 .

在使用非默认的存储模式时,可以调整内存管理和 IO 设置以获得更好的性能。Memory management and IO settings can be adjusted to get better performance when using non-default storage modes. 有关详细信息,请参阅 中的服务器属性 Analysis ServicesSee Server properties in Analysis Services for more information.

命令行安装程序Command Line Setup

SQL Server 安装程序包含指定服务器模式的参数 (ASSERVERMODE)。SQL Server Setup includes a parameter (ASSERVERMODE) that specifies the server mode. 下面的示例说明了用来在表格服务器模式下安装 Analysis Services 的命令行安装程序。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 必须少于 17 个字符。INSTANCENAME must be less than 17 characters.

所有占位符帐户的值必须替换为有效的帐户和密码。All placeholder account values must be replaced with valid accounts and password.

ASSERVERMODE 区分大小写。ASSERVERMODE is case-sensitive. 所有值必须以大写形式表示。All values must be expressed in upper case. 下表对 ASSERVERMODE的有效值进行了说明。The following table describes the valid values for ASSERVERMODE.

“值”Value 描述Description
TABULARTABULAR 这是默认值。This is the default value. 如果未设置 ASSERVERMODE,则会在表格模式下安装服务器。If you do not set ASSERVERMODE, the server is installed in Tabular mode.
MULTIDIMENSIONALMULTIDIMENSIONAL 此值是可选的。This value is optional.
POWERPIVOTPOWERPIVOT 此值是可选的。This value is optional. 实际上,如果设置 ROLE 参数,会自动将服务器模式设置为 1,从而使 ASSERVERMODE 成为 Power PivotPower Pivot for SharePoint 安装的可选项。In practice, if you set the ROLE parameter, the server mode is automatically set to 1, making ASSERVERMODE optional for a Power PivotPower Pivot for SharePoint installation. 有关详细信息,请参阅 从命令提示符安装 Power PivotFor more information, see Install Power Pivot from the Command Prompt.

获取工具和设计器Get tools and designers

SQL Server 安装程序不再安装模型设计器或用于解决方案设计或服务器管理的管理工具。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:

你将需要 Visual Studio 和 SSMS 来创建、部署和使用 Analysis Services 实例和数据库。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. 有关详细信息,请参阅 Configure the Windows Firewall to Allow Analysis Services AccessSee Configure the Windows Firewall to Allow Analysis Services Access for details.

另请参阅See also

确定 Analysis Services 实例的服务器模式Determine the Server Mode of an Analysis Services Instance