從命令提示字元安裝 PowerPivotInstall PowerPivot from the Command Prompt

您可以從命令列執行安裝程式來安裝 SQL Server PowerPivot for SharePoint。You can run Setup from the command line to install SQL Server PowerPivot for SharePoint. 您可以在命令中包含 /ROLE 參數並排除 /FEATURES 參數。You must include the /ROLE parameter in your command and exclude the /FEATURES parameter.

先決條件Prerequisites

您必須安裝 SharePoint Server 2010 Enterprise Edition Service Pack 1 (SP1)。SharePoint Server 2010 enterprise edition with Service Pack 1 (SP1) must be installed.

您必須使用網域帳戶佈建 Analysis Services。You must use domain accounts to provision Analysis Services.

電腦必須聯結至與 SharePoint 伺服器陣列相同的網域。The computer must be joined to the same domain as the SharePoint farm.

以/ROLE 為基礎的安裝選項/ROLE based installation options

在 PowerPivot for SharePoint 部署中,會使用 /ROLE 參數取代 /FEATURES 參數。For PowerPivot for SharePoint deployments, the /ROLE parameter is used in place of the /FEATURES parameter. 有效值包括:Valid values include:

  • SPI_AS_ExistingFarm

  • SPI_AS_NewFarm

兩個角色都會安裝應用程式、組態和部署檔案,好讓 PowerPivot for SharePoint 在 SharePoint 伺服器陣列中執行。Both roles install application, configuration, and deployment files that enable a PowerPivot for SharePoint to run in a SharePoint farm. 指定任一個角色將會使得安裝程式檢查 SharePoint 整合所需的硬體和軟體需求。Specifying either role will cause Setup to check for hardware and software requirements necessary for SharePoint integration.

現有的伺服器陣列選項假設已具有 SharePoint 伺服器陣列。The existing farm option assumes that a SharePoint farm is already in place. [新增伺服器陣列] 選項會假設您將建立新的伺服器陣列;它支援在命令列語法中加入資料庫引擎實例, 讓您可以使用資料庫引擎實例作為伺服器陣列的資料庫伺服器。The new farm option assumes that you will create a new farm; it supports the addition of a Database Engine instance in the command line syntax so that you can use the Database Engine instance as the farm's database server.

相對於舊版,所有伺服器組態工作會以後續安裝工作來執行。In contrast with the previous releases, all server configuration tasks are performed as post-installation tasks. 如果您想自動化安裝和組態步驟,您可以使用 PowerShell 設定伺服器。If you are automating installation and configuration steps, you can use PowerShell to configure the server. 如需詳細資訊, 請參閱使用 Windows PowerShell 的 PowerPivot設定。For more information, see PowerPivot Configuration using Windows PowerShell.

範例命令Example Commands

下列範例說明每個選項的用法。The following examples illustrate the usage of each option. 範例1顯示SPI_AS_ExistingFarmExample 1 shows SPI_AS_ExistingFarm.

Setup.exe /q /IAcceptSQLServerLicenseTerms /ACTION=install /ROLE=SPI_AS_ExistingFarm /INSTANCENAME=PowerPivot /INDICATEPROGRESS/ASSVCACCOUNT=<DomainName\UserName> /ASSVCPASSWORD=<StrongPassword> /ASSYSADMINACCOUNTS=<DomainName\UserName>   

範例 2 顯示 SPI_AS_NewFarmExample 2 shows SPI_AS_NewFarm. 請注意,此範例包含佈建 Database Engine 的參數。Notice that it includes parameters for provisioning the Database Engine.

Setup.exe /q /IAcceptSQLServerLicenseTerms /ACTION=install /ROLE=SPI_AS_NewFarm /INSTANCENAME=PowerPivot /INDICATEPROGRESS/SQLSVCACCOUNT=<DomainName\UserName> /SQLSVCPASSWORD=<StrongPassword> /SQLSYSADMINACCOUNTS=<DomainName\UserName> /AGTSVCACCOUNT=<DomainName\UserName> /AGTSVCPASSWORD=<StrongPassword> /ASSVCACCOUNT=<DomainName\UserName> /ASSVCPASSWORD=<StrongPassword> /ASSYSADMINACCOUNTS=<DomainName\UserName>   

修改命令語法Modifying the command syntax

使用下列步驟可修改範例命令語法。Use the following steps to modify the example command syntax.

  1. 將下列命令複製到 [記事本] 中:Copy the following command into Notepad:

    Setup.exe /q /IAcceptSQLServerLicenseTerms /ACTION=install /ROLE=SPI_AS_ExistingFarm /INSTANCENAME=PowerPivot /INDICATEPROGRESS/ASSVCACCOUNT=<DomainName\UserName> /ASSVCPASSWORD=<StrongPassword> /ASSYSADMINACCOUNTS=<DomainName\UserName>   
    

    /q 參數會以無訊息模式執行安裝程式,這樣會隱藏使用者介面。The /q parameter runs Setup in quiet mode, which suppresses the user interface.

    當針對自動安裝指定了 /IAcceptSQLServerLicenseTerms/q 參數時,將需要 /qsThe /IAcceptSQLServerLicenseTerms is required when the /q or /qs parameter is specified for un-attended installations.

    /action 參數會指示安裝程式執行安裝。The /action parameter instructs Setup to perform an installation.

    /role 參數會指示安裝程式安裝 PowerPivot for SharePoint 所需的 Analysis Services 程式和組態檔。The /role parameter instructs Setup to install the Analysis Services program and configuration files required for PowerPivot for SharePoint. 這個角色也會偵測及使用現有的伺服器陣列連接資訊,以存取 SharePoint 組態資料庫。This role also detects and uses the existing farm connectivity information to access the SharePoint configuration database. 此參數為必要。This parameter is required. 若要指定要安裝的元件,請使用這個參數,而非 /features 參數。Use it instead of the /features parameter to specify the components to install.

    /instancename 參數會將 'PowerPivot' 指定為具名執行個體。The /instancename parameter specifies 'PowerPivot' as a named instance. 這個值為硬式編碼,無法變更。This value is hard-coded and cannot be changed. 在命令中指定這個值是為了教育使用者,好讓使用者知道如何安裝此服務。It is specified in the command for educational purposes so that you know how the service is installed.

    /indicateprogress 參數可讓您在命令提示字元視窗中監視進度。The /indicateprogress parameter allows you to monitor progress in the command prompt window.

  2. 此命令會略過 PID 參數,這樣會造成 Evaluation Edition 的安裝。The PID parameter is omitted from the command, which causes the Evaluation edition to be installed. 如果您想要安裝 Enterprise Edition,請將 PID 加入至安裝程式命令,並提供有效的產品金鑰。If you want to install the Enterprise edition, add the PID to your Setup command and provide a valid product key.

    
    /PID=<product key for an Enterprise installation>  
    
    
  3. 使用有效的使用者<帳戶和密碼<來取代網域 \ 使用者名稱 > 和設為 strongpassword > 的預留位置。Replace the placeholders for <domain\username> and <StrongPassword>with valid user accounts and passwords.

    和/assvcpassword 參數是用來設定應用程式Analysis Services 服務Analysis Services service伺服器上的實例。 /assvaccountThe /assvaccount and /assvcpassword parameters are used to configure the Analysis Services 服務Analysis Services service instance on the application server. 請以有效的帳戶資訊取代這些預留位置。Replace these placeholders with valid account information.

    /Assysadminaccounts參數必須設定為正在執行 SQL Server 安裝程式之使用者的身分識別。The /assysadminaccounts parameter must be set to the identity of the user who is running SQL Server Setup. 您至少必須指定一個系統管理員。You must specify at least one system administrator. 請注意,SQL Server 安裝程式不再授與自動系統管理員 (sysadmin) 權限給內建系統管理員群組的成員。Note that SQL Server Setup no long grants automatic sysadmin permissions to members of the built-in Administrators group.

  4. 移除分行符號。Remove line breaks.

  5. 選取整個命令, 然後按一下 [編輯] 功能表上的 [複製]。Select the entire command and then click Copy on the Edit menu.

  6. 開啟系統管理員命令提示字元。Open an administrator command prompt. 若要這樣做, 請按一下 [開始], 以滑鼠右鍵按一下命令提示字元, 然後選取 [以系統管理員身分執行]。To do this, click Start, right-click the command prompt, and select Run as administrator.

  7. 導覽至包含 SQL Server 安裝媒體的磁碟機或共用資料夾。Navigate to the drive or shared folder that contains the SQL Server installation media.

  8. 將修改過的命令貼到命令列。Paste the revised command into the command line. 若要這麼做, 請按一下 [命令提示字元] 視窗左上角的圖示, 指向 [編輯], 然後按一下 [上]。To do this, click the icon in the top left corner of the command prompt window, point to Edit, and then click Paste.

  9. enter鍵以執行命令。Press Enter to run the command. 等候安裝程式完成。Wait for setup to complete. 您可以在命令提示字元視窗中監視安裝程式的進度。You can monitor Setup's progress in the command prompt window.

  10. 若要驗證安裝,請檢查位於 \Program Files\SQL Server\120\Setup Bootstrap\Log 的 summary.txt 檔。To verify installation, check the summary.txt file at \Program Files\SQL Server\120\Setup Bootstrap\Log. 如果伺服器安裝成功而沒有任何錯誤,最終的結果應該是 "Passed"。Final result should say "Passed" if the server installed without errors.

  11. 設定伺服器。Configure the server. 您至少必須要部署方案、建立服務應用程式,並針對每一個網站集合啟用此功能。At a minimum, you must deploy solutions, create a service application, and enable the feature for each site collection. 如需詳細資訊, 請參閱設定或修復(PowerPivot for SharePoint 2010 PowerPivot)設定工具管理中心的 powerpivot 伺服器管理和設定。For more information, see Configure or Repair PowerPivot for SharePoint 2010 (PowerPivot Configuration Tool) or PowerPivot Server Administration and Configuration in Central Administration.

另請參閱See Also

設定 PowerPivot 服務帳戶 Configure PowerPivot Service Accounts
PowerPivot for SharePoint 2010 安裝PowerPivot for SharePoint 2010 Installation