安裝 PowerPivot for SharePoint 2010Install PowerPivot for SharePoint 2010

PowerPivot for SharePointPowerPivot for SharePoint 是中間層級後端服務的集合,可以在 SharePoint 2010 伺服器陣列中提供 PowerPivot 資料存取功能。is a collection of middle-tier and backend services that provide PowerPivot data access in a SharePoint 2010 farm. 如果您的組織使用用戶端應用程式 PowerPivotPowerPivot for Excel 2010 來建立包含分析資料的活頁簿,您必須要有 PowerPivot for SharePointPowerPivot for SharePoint,才能在伺服器環境中存取該資料。If your organization uses the client application, PowerPivotPowerPivot for Excel 2010, to create workbooks that contain analytical data, you must have PowerPivot for SharePointPowerPivot for SharePoint to access that data in a server environment. 本主題會逐步引導您完成基本安裝程序,而且提供了其他主題的連結,可協助您設定 PowerPivot。This topic walks you through the basic installation process and it links you additional topics to help you configure PowerPivot.

適用於:Applies to: SharePoint 2010適用於:Applies to: SharePoint 2010

如需有關如何在相同PowerPivotPowerPivot伺服器Reporting ServicesReporting Services上安裝和的指示, 請參閱部署檢查清單:Reporting Services、Power View 和 PowerPivot for SharePointFor instructions on how to install PowerPivotPowerPivot and Reporting ServicesReporting Services on the same server, see Deployment Checklist: Reporting Services, Power View, and PowerPivot for SharePoint.

先決條件Prerequisites

  1. 您必須是本機系統管理員,才能執行 SQL Server 安裝程式。You must be a local administrator to run SQL Server Setup.

  2. PowerPivot for SharePointPowerPivot for SharePoint 需要 SharePoint Server 2010 Enterprise 版。SharePoint Server 2010 enterprise edition is required for PowerPivot for SharePointPowerPivot for SharePoint. 您也可以使用 Evaluation Enterprise 版。You can also use the evaluation enterprise edition.

  3. 您必須安裝 SharePoint Server 2010 SP2。SharePoint Server 2010 SP2 must be installed. 若未安裝,則無法設定伺服器陣列使用 SQL Server 2014SQL Server 2014 功能。Without it, you cannot configure the farm to use SQL Server 2014SQL Server 2014 features.

  4. 電腦必須加入網域。The computer must be joined to a domain.

  5. 您必須要有網域使用者帳戶,才能佈建 Analysis ServicesAnalysis ServicesYou must have a domain user account to provision Analysis ServicesAnalysis Services. PowerPivot for SharePointPowerPivot for SharePoint 安裝中,Analysis Services 服務帳戶必須是可以從管理中心進行管理的網域使用者帳戶。In a PowerPivot for SharePointPowerPivot for SharePoint installation, the Analysis Services service account must be a domain user account so that you can manage it from Central Administration. 您會在 [伺服器設定] 頁面上輸入帳戶和認證, 做為本檔中步驟的一部分。You will type the account and credentials on the Server Configuration page as part of the steps in this document.

  6. 必須要有 PowerPivotPowerPivot 執行個體名稱。The PowerPivotPowerPivot instance name must be available. 在您要安裝 PowerPivot for SharePoint 的電腦上,不能有現存的 PowerPivotPowerPivot 具名執行個體。You cannot have an existing PowerPivotPowerPivot named instance on the computer on which you are installing PowerPivot for SharePoint.

  7. PowerPivot for SharePointPowerPivot for SharePoint 執行個體不得為 SQL Server 容錯移轉叢集的一部分。The PowerPivot for SharePointPowerPivot for SharePoint instance cannot be part of a SQL Server Failover Cluster. 使用 SharePoint 產品的高可用性功能。Use high availability features of the SharePoint Product. 例如,Excel Services 會管理 PowerPivot for SharePoint 伺服器的負載平衡。For example, Excel Services manages load balancing of PowerPivot for SharePoint servers. 如需詳細資訊, 請參閱管理 Excel Services 資料模型設定 (SharePoint Server 2013) (https://technet.microsoft.com/library/jj219780.aspx) 。For more information, see Manage Excel Services data model settings (SharePoint Server 2013) (https://technet.microsoft.com/library/jj219780.aspx).

  8. 如果您要在現存的伺服器陣列上安裝 PowerPivot for SharePointPowerPivot for SharePoint,必須要有一個或多個為傳統模式驗證所設定的 SharePoint Web 應用程式。If you are installing PowerPivot for SharePointPowerPivot for SharePoint on an existing farm, you must have one or more SharePoint web applications that are configured for classic mode authentication. Web 應用程式必須支援傳統模式驗證,PowerPivotPowerPivot 資料存取才能運作。PowerPivotPowerPivot data access will only work if the web application supports classic mode authentication. 如需傳統模式需求的詳細資訊, 請參閱PowerPivot 驗證和授權For more information about classic mode requirements, see PowerPivot Authentication and Authorization.

  9. 請檢閱下列其他主題,以了解系統與版本需求:Review the following additional topics to understand system and version requirements:

步驟 1:安裝 PowerPivot for SharePointStep 1: Install PowerPivot for SharePoint

在此步驟中,您要執行 SQL Server 安裝程式來安裝 PowerPivot for SharePointPowerPivot for SharePointIn this step, you run SQL Server Setup to install PowerPivot for SharePointPowerPivot for SharePoint. 在後續步驟中,您會將伺服器設定為安裝後工作。In a subsequent step, you will configure the server as a post-installation task.

  1. 插入安裝媒體或開啟包含 SQL Server 安裝檔的資料夾, 然後按兩下 [ setup.exe]。Insert the installation media or open a folder that contains the setup files for SQL Server and then double-click setup.exe.

  2. 按一下左側流覽窗格中的 [安裝]。Click Installation in the left navigation pane.

  3. 按一下 [新增 SQL Server 獨立安裝或將功能加入至現有安裝]Click New SQL Server stand-alone installation or add features to an existing installation.

  4. 在 [產品金鑰] 頁面上, 指定評估版或輸入 enterprise edition 授權複本的產品金鑰。On the Product Key page, specify the evaluation edition or enter a product key for a licensed copy of the enterprise edition.

    按一下 [下一步]。Click Next.

  5. 接受 Microsoft 軟體授權合約的條款,而且如果您一併開啟客戶經驗和錯誤報告,我們會非常感激。Accept the Microsoft Software License Terms of agreement and We appreciate it if you also turn on the customer experience and error reporting. 按一下 [下一步]。Click Next.

  6. 如果系統提示您如此做,請更新安裝程式檔。Update the setup files if you are prompted to do so.

  7. 在 [安裝規則] 頁面上, 安裝程式會找出可能導致無法安裝的任何問題。On the Install Rules page, setup identifies any problems that might prevent it from installing. 檢閱清單以判斷安裝程式是否已偵測到系統上的潛在問題。Review the list to determine whether Setup detected potential problems on the system.

    注意

    由於已啟用 Windows 防火牆,因此系統會警告您開放通訊埠才可啟用遠端存取。Because Windows Firewall is enabled, you will be warned to open ports to enable remote access. 這個警告通常不適用於 PowerPivotPowerPivot 安裝。This warning is generally not applicable to PowerPivotPowerPivot installations. PowerPivotPowerPivot 服務及資料檔案之間的連接,是使用已針對 SharePoint 服務對服務通訊所開啟的 SharePoint 連接埠來建立。Connections to PowerPivotPowerPivot services and data files are made using the SharePoint ports that are already open for SharePoint service-to-service communication.

    按一下 [下一步]。Click Next. 正在伺服器上安裝 SQL Server 安裝程式檔案,請稍候。Wait while SQL Server Setup program files are installed on the server.

  8. [安裝程式角色] 頁面上,選取 [SQL Server PowerPivot for SharePoint]On the Setup Role page, select SQL Server PowerPivot for SharePoint.

  9. 您可選擇性地在安裝中加入一項 Database Engine 的執行個體。Optionally, you can add an instance of the Database Engine to your installation. 如果您要設定新的伺服器陣列, 且需要資料庫伺服器來執行伺服器陣列的設定和內容資料庫, 您可能會這麼做。You might do this if you are setting up a new farm and need a database server to run the farm's configuration and content databases. 若您加入 Database Engine,將會安裝為 PowerPivot 具名執行個體。If you add the Database Engine, it will be installed as a PowerPivot named instance. 每當您需要指定與此實例的連接時 (例如, 如果您使用該 wizard 設定伺服器陣列, 請在伺服器陣列設定 wizard 中), 以下列格式輸入資料庫名稱: <servername> \powerpivot。Whenever you need to specify a connection to this instance (for example, in the farm configuration wizard if you are using that wizard to configure the farm), enter the database name in this format: <servername>\PowerPivot.

    GMNI_SetupUI_FeatureRoleGMNI_SetupUI_FeatureRole

  10. 按一下 [下一步]。Click Next.

  11. 在 [特徵選取] 頁面上, 會顯示要安裝之功能的唯讀清單, 以供參考之用。On the Feature Selection page, a read-only list of the features that will be installed is displayed for informational purposes. 您不能加入或移除預先為這個角色選取的項目。You cannot add or remove items that are preselected for this role. 按一下 [下一步]。Click Next.

  12. 在 [功能規則] 頁面上, 按 [下一步]On the Feature Rules page, click Next. 您可以略過此頁面。The page may be skipped.

  13. [執行個體組態] 頁面上,顯示 'PowerPivot' 的唯讀執行個體名稱是為了給使用者參考。On the Instance Configuration page, a read-only instance name of 'PowerPivot' is displayed for informational purposes. POWERPIVOT的這個實例名稱是必要的, 而且無法修改This instance name of POWERPIVOT is required and cannot be modified. 但是,您可以輸入唯一的執行個體識別碼來指定描述性目錄名稱和登錄機碼。However, you can enter a unique Instance ID to specify a descriptive directory name and registry keys. 按一下 [下一步]。Click Next.

  14. 在 [伺服器設定] 頁面上, 輸入所需的帳戶資訊。On the Server Configuration page, type desired account information.

    若是 SQL Server Analysis Services,您必須指定網域使用者帳戶。For SQL Server Analysis Services, you must specify a domain user account. 請不要指定內建帳戶。Do not specify a built-in account. 需要網域帳戶, 才能在 SharePoint 管理中心內管理 Analysis Services 服務帳戶做為受管理的帳戶Domain accounts are required for managing the Analysis Services service account as a managed account in SharePoint Central administration.

    ![SSAS 伺服器]設定(../../../2014/sql-server/install/media/ssas-powerpivotsetupsql2012sp1-serverconfiguration.gif "SSAS 伺服器")設定SSAS Server Configuration

    若已新增 SQL Server Database Engine 與 SQL Server Agent,您可以將服務設定為利用網域使用者帳戶或預設虛擬帳戶加以執行。If you added the SQL Server Database Engine and SQL Server Agent, you can configure the services to run under domain user accounts or under the default virtual account.

    絕不要使用您自己的網域使用者帳戶提供任何服務。Never use your own domain user account to provision any service. 這麼做會授與伺服器您對網路中的資源所擁有的相同權限。Doing so grants the server the same permissions that you have to the resources in your network. 如果伺服器遭到惡意使用者的危害,該使用者將會以您的網域認證登入,而且能夠下載或使用您可以下載或使用的相同資料與應用程式。If the server is compromised by a malicious user, that user will be logged in under your domain credentials, with the ability to download or use the same data and applications that you do.

  15. 按一下 [下一步]。Click Next.

  16. 若您正安裝 Database Engine,則隨即會出現 Database Engine 組態頁面。If you are installing the Database Engine, the Database Engine Configuration page appears. 在資料庫引擎設定 中, 按一下 加入目前使用者, 將資料庫引擎實例的系統管理員許可權授與您的使用者帳戶。In Database Engine Configuration, click Add Current User to grant your user account administrator permissions on the Database Engine instance. 按一下 [新增] 以新增其他帳戶。Click Add to add additional accounts. 按一下 [下一步]。Click Next.

  17. [Analysis Services 組態] 頁面上,按一下 [加入目前使用者] ,為您的使用者帳戶授與管理權限。On the Analysis Services Configuration page, click Add Current User to grant your user account administrative permissions. 在完成安裝程式之後,您將會需要管理權限來設定伺服器。You will need administrative permission to configure the server after Setup is finished.

  18. 在相同的頁面上,加入也需要管理權限之任何人的 Windows 使用者帳戶。On the same page, add the Windows user account of any person who also requires administrative permissions. 例如,想要在 SQL Server Management Studio 中連接至 Analysis Services 服務Analysis Services service執行個體以疑難排解資料庫連接問題或取得版本資訊的所有使用者,都必須擁有該伺服器的系統管理權限。For example, any user who wants to connect to the Analysis Services 服務Analysis Services service instance in SQL Server Management Studio to troubleshoot database connection problems or get version information must have system administrator permissions on the server. 請加入可能需要立即針對伺服器進行疑難排解或管理之任何人的使用者帳戶。Add the user account of any person who might need to troubleshoot or administer the server now.

  19. 按一下 [下一步]。Click Next.

  20. 在其餘每個頁面上按 [下一步] , 直到您進入 [準備安裝] 頁面為止。Click Next on each of the remaining pages until you get to the Ready to Install page.

  21. 按一下 [安裝]Click Install.

提示

如果您需要排除 SQL Server 安裝的問題, 請參閱查看和閱讀 SQL Server 安裝程式記錄檔。If you need to trouble shoot the SQL Server installation, see View and Read SQL Server Setup Log Files.

步驟 2:設定伺服器Step 2: Configure the Server

重要

您必須先安裝 SharePoint 2010 SP2,才能設定 PowerPivot for SharePointPowerPivot for SharePoint 或是使用 SQL Server 2014SQL Server 2014 資料庫伺服器的 SharePoint 伺服器陣列。SharePoint 2010 SP2 must be installed before you can configure PowerPivot for SharePointPowerPivot for SharePoint or a SharePoint farm that uses a SQL Server 2014SQL Server 2014 database server. 如果您尚未安裝該 Service Pack,請在開始設定伺服器之前先加以安裝。If you have not yet installed the service pack, do so now before you begin configuring the server.

在設定好伺服器之前,安裝作業不會完成。Installation is not complete until the server is configured. 在此版本中, 伺服器設定一律會以安裝後工作的方式執行, 並使用下列其中一種方法:PowerPivotPowerPivot設定工具、管理中心或 PowerShell。In this release, server configuration is always performed as post-installation task, using one of the following approaches: PowerPivotPowerPivot Configuration Tool, Central Administration, or PowerShell. 若要繼續,請選擇下列其中一種方式進行:To continue, choose one of the following approaches:

連接到資料庫引擎實例。Connecting to the Database Engine Instance. 當您安裝 PowerPivot for SharePointPowerPivot for SharePoint 時,SQL Server 安裝程式會提供您將 Database Engine 執行個體加入安裝中的選項。When you installed PowerPivot for SharePointPowerPivot for SharePoint, SQL Server Setup gave you the option of adding an instance of the Database Engine to your installation. 如果您要設定新的伺服器陣列, 且需要資料庫伺服器來執行伺服器陣列的設定和內容資料庫, 您可能會將資料庫引擎實例新增至您的安裝。You might have added a Database Engine instance to your installation if you are setting up a new farm and need a database server to run the farm's configuration and content databases. 如果您已加入 Database Engine,其會安裝為 PowerPivotPowerPivot 具名執行個體。If you added the Database Engine, it was installed as a PowerPivotPowerPivot named instance. 每當您需要指定與此實例的連接時 (例如, 如果您使用該 wizard 設定伺服器陣列, 請在伺服器陣列設定 wizard 中), 請記得以此格式輸入資料庫名稱: <servername> \powerpivot。Whenever you need to specify a connection to this instance (for example, in the farm configuration wizard if you are using that wizard to configure the farm), remember to enter the database name in this format: <servername>\PowerPivot.

步驟 3:在 Excel Services 應用程式伺服器上安裝 Analysis Services OLE DB 提供者Step 3: Install Analysis Services OLE DB providers on Excel Services Application Servers

如果您在個別的應用程式伺服器上執行 Excel Calculation Services 和 PowerPivotPowerPivot,則需要額外的安裝步驟。Additional installation steps are required if you run Excel Calculation Services and PowerPivotPowerPivot on separate application servers. 在執行 Excel Calculation Services 的應用程式伺服器上,安裝 Analysis Services OLE DB 提供者 (MSOLAP) 的適當版本。On the application servers running Excel Calculation Services, install the appropriate version of the Analysis Services OLE DB (MSOLAP) provider.

  • SQL Server 2014SQL Server 2014 版本的 MSOLAP 包含在 SQL Server 安裝程式中,因此只有在應用程式伺服器不是 PowerPivot 應用程式伺服器時,才需要明確安裝 SQL Server 2014SQL Server 2014 版本的 MSOLAP。The SQL Server 2014SQL Server 2014 version of MSOLAP is included in SQL Server Setup, therefore explicitly installing the SQL Server 2014SQL Server 2014 version of MSOLAP is only required if your application server is not a PowerPivot application server.

    注意

    Excel Calculation Services 應用程式伺服器也需要通用群組件中microsoft.analysisservices檔案的實例。The Excel Calculation Services application server also needs an instance of the file Microsoft.AnalysisServices.Xmla.dll in the global assembly. 若要將此 .dll 安裝在應用程式伺服器上,請安裝 SQL Server Management StudioSQL Server Management StudioTo install the .dll on the application server, install SQL Server Management StudioSQL Server Management Studio. 在 SQL Server 安裝程式 的 特徵選取 頁面上, 選取 管理工具-完成。Select the "Management Tools - Complete" on the Feature Selection page of the SQL Server Setup wizard.

  • 如果您希望應用程式伺服器支援舊版 PowerPivotPowerPivot 活頁簿,則需要安裝 SQL Server 2008 R2 版本的 MSOLAP。If you want the application server to support older PowerPivotPowerPivot workbooks, you need to install the SQL Server 2008 R2 version of MSOLAP.

如需安裝提供者的詳細資訊 (包括驗證步驟), 請參閱在 SharePoint 伺服器上安裝 Analysis Services OLE DB ProviderFor more information about installing the provider, including verification steps, see Install the Analysis Services OLE DB Provider on SharePoint Servers

步驟 4:確認安裝Step 4: Verify the Installation

在這個最後步驟中,您將驗證 SharePoint 2010 和 PowerPivot for SharePointPowerPivot for SharePoint 都能完整運作。In this last step, you will verify that both SharePoint 2010 and PowerPivot for SharePointPowerPivot for SharePoint are fully functional. 如需相關指示, 請參閱Verify a PowerPivot for SharePoint 安裝For instructions, see Verify a PowerPivot for SharePoint Installation.

另請參閱See Also

PowerPivot for SharePoint 2010 安裝 PowerPivot for SharePoint 2010 Installation
部署檢查清單:Reporting Services、Power View 和 PowerPivot for SharePoint Deployment Checklist: Reporting Services, Power View, and PowerPivot for SharePoint
部署檢查清單:將 PowerPivot 服務器新增至 SharePoint 2010 伺服器陣列以向外延展 Deployment Checklist: Scale-out by adding PowerPivot Servers to a SharePoint 2010 farm
部署檢查清單:PowerPivot for SharePoint 2010 的多伺服器安裝Deployment Checklist: Multi-Server Installation of PowerPivot for SharePoint 2010