升級 PowerPivot for SharePointUpgrade PowerPivot for SharePoint

本主題概述將 PowerPivot for SharePointPowerPivot for SharePoint 部署升級至 Microsoft SQL Server 2014 PowerPivot for SharePointMicrosoft SQL Server 2014 PowerPivot for SharePoint所需的步驟。This topic summarizes the steps required to upgrade a deployment of PowerPivot for SharePointPowerPivot for SharePoint to Microsoft SQL Server 2014 PowerPivot for SharePointMicrosoft SQL Server 2014 PowerPivot for SharePoint. 特定步驟取決於您環境目前所執行的 SharePoint 版本,並包含 PowerPivot for SharePoint 增益集 (spPowerPivot.msi)。The specific steps depend on the version of SharePoint your environment is currently running and include the PowerPivot for SharePoint Add-in (spPowerPivot.msi).

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

如需版本資訊,請參閱< SQL Server 2014 版本資訊>。For release notes, see SQL Server 2014 Release Notes.

背景Background

  • 如果您要升級含有兩個 (含) 以上 PowerPivot for SharePointPowerPivot for SharePoint 執行個體的多伺服器 SharePoint 2010 伺服器陣列,必須在繼續升級下一部伺服器 之前 ,完整升級每部伺服器。If you are upgrading a multi-server SharePoint 2010 farm that has two or more PowerPivot for SharePointPowerPivot for SharePoint instances, you must fully upgrade each server before continuing to the next server. 完整升級包括執行 SQL Server 安裝程式來升級 PowerPivot for SharePointPowerPivot for SharePoint 程式檔案,然後再執行 SharePoint 升級動作來設定已升級的服務。A full upgrade includes running SQL Server Setup to upgrade PowerPivot for SharePointPowerPivot for SharePoint program files, followed by SharePoint upgrade actions that configure the upgraded services. 在適當的 PowerPivot 組態工具或 Windows PowerShell 中執行升級動作之前,伺服器可用性會受到限制。Server availability will be limited until you run upgrade actions in the appropriate PowerPivot Configuration Tool or Windows PowerShell.

  • SharePoint 2010 伺服陣列中的所有 PowerPivot 系統服務與 Analysis Services 執行個體都必須是相同的版本。All instances of PowerPivot System Service and Analysis Services in a SharePoint 2010 farm must be the same version. 如需有關如何驗證版本的詳細資訊,請參閱本主題中的 驗證 PowerPivot 元件和服務的版本 一節。For information on how to verify the version, see the section Verify the Versions of PowerPivot Components and Services in this topic.

  • PowerPivot 組態工具是 SQL Server 共用功能之一,所有共用功能都會同時升級。The PowerPivot configuration tools are one of the SQL Server shared features and all shared features upgrade at the same time. 如果您在升級過程中選取需要共用功能升級的其他 SQL Server 執行個體或功能,則 PowerPivot 組態工具也會一併升級。If during an upgrade process you select other SQL Server instances or features that require a shared feature upgrade, then the PowerPivot configuration tool will also be upgraded. 如果升級 PowerPivot 組態工具但是未升級 PowerPivot 執行個體,可能會發生問題。You may have issues if the PowerPivot configuration tool is upgraded but your PowerPivot instance is not. 如需 SQL Server 共用功能的詳細資訊, 請參閱使用安裝精靈(安裝程式)升級至 SQL Server 2014For more information about SQL Server shared features, see Upgrade to SQL Server 2014 Using the Installation Wizard (Setup).

  • PowerPivot for SharePoint 增益集 (spPowerPivot.msi) 會與舊版並排安裝。The PowerPivot for SharePoint Add-in (spPowerPivot.msi) installs side by side with previous versions. 例如, SQL Server 2014SQL Server 2014 增益集會安裝至資料夾 c:\Program Files\Microsoft SQL Server\120\Tools\PowerPivotToolsFor example the SQL Server 2014SQL Server 2014 add-in installs to the folder c:\Program Files\Microsoft SQL Server\120\Tools\PowerPivotTools.

必要條件Prerequisites

PermissionsPermissions

  • 您必須是伺服器陣列管理員,才能升級 PowerPivot for SharePoint 安裝。You must be a farm administrator to upgrade a PowerPivot for SharePoint installation. 您必須是本機系統管理員,才能執行 SQL Server 安裝程式。You must be a local administrator to run SQL Server Setup.

  • 您必須要有伺服器陣列組態資料庫的 db_owner 權限。You must have db_owner permissions on the farm configuration database.

SQL Server:SQL Server:

  • 如果現有的 PowerPivot 安裝為 SQL Server 2008 R2SQL Server 2008 R2,則需要 SQL Server 2008 R2SQL Server 2008 R2 Service Pack 2 (SP2),才能升級至 SQL Server 2014SQL Server 2014 PowerPivot for SharePointPowerPivot for SharePointIf the existing PowerPivot installation is SQL Server 2008 R2SQL Server 2008 R2, the SQL Server 2008 R2SQL Server 2008 R2 Service Pack 2 (SP2) is required for an upgrade to SQL Server 2014SQL Server 2014 PowerPivot for SharePointPowerPivot for SharePoint.

  • 如果現有的 PowerPivot 安裝為 SQL Server 2012SQL Server 2012,則需要 SQL Server 2012SQL Server 2012 Service Pack 1 (SP1),才能升級至 SQL Server 2014SQL Server 2014 PowerPivot for SharePointPowerPivot for SharePointIf the existing PowerPivot installation is SQL Server 2012SQL Server 2012, the SQL Server 2012SQL Server 2012 Service Pack 1 (SP1) is required for an upgrade to SQL Server 2014SQL Server 2014 PowerPivot for SharePointPowerPivot for SharePoint.

SharePoint 2010:SharePoint 2010:

  • 如果現有的安裝是執行 SharePoint 2010,請先安裝 SharePoint 2010 Service Pack 2,再升級至 SQL Server 2014SQL Server 2014PowerPivot for SharePointPowerPivot for SharePointIf the existing installation is running SharePoint 2010, install the SharePoint 2010 Service Pack 2 before upgrading to SQL Server 2014SQL Server 2014PowerPivot for SharePointPowerPivot for SharePoint. 如需詳細資訊,請參閱< Service Pack 2 for Microsoft SharePoint 2010>。For more information, see Service Pack 2 for Microsoft SharePoint 2010. 使用 PowerShell 命令 (Get-SPfarm).BuildVersion.ToString() 來驗證版本。Use the PowerShell command (Get-SPfarm).BuildVersion.ToString() to verify the version. 若要將組建版本參照至發行日期,請參閱< SharePoint 2010 組建編號>。To reference the build version to release date, see SharePoint 2010 Build Numbers.

升級現有的 SharePoint 2013 伺服器陣列Upgrade an Existing SharePoint 2013 Farm

若要將部署在 SharePoint 2013 中的 PowerPivot for SharePointPowerPivot for SharePoint 升級,請執行下列動作:To upgrade PowerPivot for SharePointPowerPivot for SharePoint deployed in SharePoint 2013, do the following:

PowerPivot for SharePoint 2013 升級powerpivot for sharepoint 2013 upgrade

  1. 在以 SharePoint 模式執行 SQL Server 2014SQL Server 2014 的後端伺服器上,執行 Analysis ServicesAnalysis Services 安裝程式。Run SQL Server 2014SQL Server 2014 Setup on backend server(s) that run Analysis ServicesAnalysis Services in SharePoint mode. 如果該伺服器主控多個 Analysis ServicesAnalysis Services執行個體,則至少要升級 POWERPIVOT 執行個體。If the server hosts multiple instances of Analysis ServicesAnalysis Services, upgrade at least the POWERPIVOT instance. 下列清單是有關 PowerPivotPowerPivot 升級的安裝精靈步驟摘要:The following list is a summary of setup wizard steps related to a PowerPivotPowerPivot upgrade:

    1. 在 [ [SQL Server]SQL Server 安裝精靈] 中,按一下 [安裝]In the [SQL Server]SQL Server Setup Wizard, click Installation.

    2. 按一下 [從 SQL Server 升級...]。Click Upgrade from SQL Server......

    3. [選取執行個體] 頁面上,選取 [POWERPIVOT] 執行個體名稱,然後按 [下一步]On the Select Instance page, select the POWERPIVOT instance name and then click Next.

    4. 如需詳細資訊, 請參閱使用安裝精靈(安裝程式)升級至 SQL Server 2014For more information, see Upgrade to SQL Server 2014 Using the Installation Wizard (Setup)

  2. 重新啟動伺服器。Restart the server.

  3. 在 SharePoint 2013 伺服器陣列中的每部伺服器上,執行 PowerPivotPowerPivot for SharePoint 增益集 (spPowerPivot.msi),以安裝資料提供者。Run the PowerPivotPowerPivot for SharePoint add-in (spPowerPivot.msi) on each server in the SharePoint 2013 farm to install the data providers. 但是執行 SQL Server 安裝精靈所在的伺服器除外,安裝精靈也會升級資料提供者。The exception is servers where you ran the SQL Server setup wizard, which also upgrades data providers. 如需詳細資訊, 請參閱安裝或卸載 PowerPivot for SharePoint 增益集(SharePoint 2013)For more information, see Install or Uninstall the PowerPivot for SharePoint Add-in (SharePoint 2013).

  4. 在其中一個 SharePoint 應用程式伺服器上執行 PowerPivot for SharePoint 2013 組態 工具,以增益集所安裝的更新方案檔案來設定 SharePoint 伺服器陣列。Run the PowerPivot for SharePoint 2013 Configuration tool on one of the SharePoint application servers to configure the SharePoint farm with the updated solution files that the add-in installed. 您無法使用 SharePoint 管理中心來進行此步驟。You cannot use Central SharePoint Administration for this step. 如需詳細資訊,請參閱下列內容:For more information, see the following:

    1. 在 Windows 的 [開始] 頁面中,輸入 PowerPivot ,然後在搜尋結果中,按一下 [PowerPivot for SharePoint 2013 組態]From the Windows Start page, type PowerPivot and in the search results, click PowerPivot for SharePoint 2013 Configuration. 請注意,搜尋可能會將組態工具的兩個版本皆傳回。Note the search may return both versions of the configuration tool.

      兩個 PowerPivot 組態工具two powerpivot configuratoin tools

      Or

      [開始] 功能表上,指向 [所有程式] ,然後依序按一下 [ Microsoft SQL Server 2014Microsoft SQL Server 2014]、 [組態工具][PowerPivot for SharePoint 2013 組態工具]On the Start menu, point to All Programs, click Microsoft SQL Server 2014Microsoft SQL Server 2014, click Configuration Tools, and then click PowerPivot for SharePoint 2013 Configuration Too. 請注意,只有在本機伺服器上安裝了 PowerPivot for SharePointPowerPivot for SharePoint 時,才會列出此工具。Note that this tool is listed only when PowerPivot for SharePointPowerPivot for SharePoint is installed on the local server.

    2. 啟動時,組態工具會檢查 PowerPivot 伺服器陣列方案以及 PowerPivot Web 應用程式方案的狀態。At startup, the configuration tool checks the upgrade status of the PowerPivot farm solution and PowerPivot web application solutions. 如果偵測到這些方案的舊版本, 您會看到 「偵測到較新版本的 PowerPivot 方案檔。請選取升級選項以升級您的伺服器陣列」。If older versions of these solutions are detected, you will see the message "Newer versions of the PowerPivot solution files have been detected. Please select the upgrade option to upgrade your farm." 按一下 [確定] 以關閉系統驗證訊息。Click OK to close the system validation message.

    3. 按一下 [升級功能、服務、應用程式和方案] ,然後按一下 [確定]Click Upgrade Features, Services, Applications and Solutions, and then click OK.

    4. 檢閱左窗格工作清單中的動作,並排除您不希望該工具執行的任何動作。Review the actions in the left pane task list and exclude any that you do not want the tool to perform. 預設包含所有動作。All actions are included by default. 若要移除動作,請在左邊工作清單中選取該動作,然後清除 [參數] 頁面上的 [在工作清單中包含這個動作] 核取方塊。To remove an action, select it in the left task list, and then on the Parameters page, clear the Include this action in the task list checkbox.

    5. 或者,在 [指令碼][輸出] 索引標籤中檢閱詳細資訊。Optionally, review detailed information in the Script or Output tab.

      [輸出] 索引標籤是此工具即將執行之動作的摘要。The Output tab is a summary of the actions that will be performed by the tool. 此資訊會儲存在記錄檔中: C:\Program Files\Microsoft SQL Server\120\Tools\PowerPivotTools\SPAddinConfiguration\LogThis information is saved in log files at C:\Program Files\Microsoft SQL Server\120\Tools\PowerPivotTools\SPAddinConfiguration\Log.

      [指令碼] 索引標籤會顯示 PowerShell 指令程式,或參考此工具將執行的 PowerShell 指令碼檔案。The Script tab shows the PowerShell cmdlets or references the PowerShell script files that the tool will run.

    6. 按一下 [驗證] 來檢查每個動作是否有效。Click Validate to check whether each action is valid. 如果無法使用 [驗證] ,表示所有動作都適用於您的系統。If Validate is not available, it means that all of the actions are valid for your system. 如果可以使用 [驗證] ,表示您可能已經修改輸入值 (例如,Excel 服務應用程式名稱),或此工具可能已經判定府執行特定動作。If Validate is available, you might have modified an input value (for example, the Excel service application name), or the tool might have determined that a particular action cannot be performed. 如果無法執行某個動作,您必須排除該動作,或修正造成此動作標示為無效的基礎條件。If an action cannot be performed, you must exclude it or fix the underlying conditions that cause the action to be flagged as invalid.

      重要

      您必須一律先處理第一個動作 [升級伺服器陣列方案]The first action, Upgrade Farm Solution, must always be processed first. 此動作會註冊用來設定伺服器的 PowerShell 指令程式。It registers the PowerShell cmdlets that are used to configure the server. 如果此動作出現錯誤,請不要繼續。If you get an error on this action, do not continue. 在處理工作清單中的其他動作之前,請改用此錯誤所提供的資訊診斷並解決問題。Instead, use the information provided by the error to diagnose and resolve the problem before processing additional actions in the task list.

    7. 按一下 [執行] ,執行適用於此工作的所有動作。Click Run to perform all of the actions that are valid for this task. 只有在通過驗證檢查的情況下,才可以使用 [執行]Run is available only after the validation check is passed. 當您按一下 [執行] 時,會出現下列警告,提醒您動作是在批次模式下處理:「工具中標示為有效的所有組態設定都會套用到 SharePoint 伺服器陣列。您要繼續嗎?When you click Run, the following warning appears, reminding you that actions are processed in batch mode: "All of the configuration settings that are flagged as valid in the tool will be applied to the SharePoint farm. Do you want to continue?".

    8. 按一下 [是] 繼續。Click Yes to continue.

    9. 在伺服器陣列中升級方案和功能可能需要數分鐘才能完成。Upgrading solutions and features in the farm can take several minutes to complete. 在這段期間內, PowerPivot 資料的連接要求將會失敗, 並出現類似下列錯誤: 「無法重新整理資料**」或「嘗試執行要求的動作時發生錯誤。請再試一次**」。During this time, connection requests for PowerPivot data will fail with errors similar to "Unable to refresh data" or "An error has occurred trying to perform the requested action. Please try again." 升級完成後,伺服器將會變成可以使用,而且將不再發生這些錯誤。After upgrade is finished, the server will become available and these errors will no longer occur.

    如需詳細資訊,請參閱下列內容:For more information, see the following:

  5. 透過執行升級後的步驟以及檢查伺服器陣列中的 PowerPivot 伺服器版本,驗證升級成功。Verify that upgrade succeeded by performing the post-upgrade steps and by checking the version of PowerPivot servers in the farm. 如需詳細資訊,請參閱本主題中的 Post-upgrade verification tasks 和下列章節:For more information, see Post-upgrade verification tasks in this topic and the following section.

升級現有的 SharePoint 2010 伺服器陣列Upgrade an Existing SharePoint 2010 Farm

若要將部署在 SharePoint 2010 中的 PowerPivot for SharePointPowerPivot for SharePoint 升級,請執行下列動作:To upgrade PowerPivot for SharePointPowerPivot for SharePoint deployed in SharePoint 2010, do the following:

PowerPivot for SharePoint 2010 升級powerpivot for sharepoint 2010 upgrade

  1. 下載 Service Pack 2 for Microsoft SharePoint 2010 ,並套用至伺服器陣列中的所有伺服器。Download Service Pack 2 for Microsoft SharePoint 2010 and apply it on all servers in the farm. 確認 SharePoint SP2 安裝成功。Verify that SharePoint SP2 installation succeeded. 在管理中心的 [升級與移轉] 頁面上,開啟 [檢查產品與修補安裝狀態] 頁面,以檢視與 SP2 相關的狀態訊息。In Central Administration, on the Upgrade and Migration page, open the Check product and patch installation status page to view status messages related to SP2.

  2. 確認 SharePoint 2010 Administration Windows 服務正在執行中。Verify that the SharePoint 2010 Administration Windows service is running.

    Get-Service | where {$_.displayname -like "*SharePoint*"}  
    
  3. 確認 SharePoint 管理中心已經啟動 SharePoint 服務、 SQL Server Analysis ServicesSQL Server PowerPivot 系統服務 ,或使用下列 PowerShell 命令:Verify the SharePoint services SQL Server Analysis Services and SQL Server PowerPivot System Service are started in SharePoint Central Administration or use the following PowerShell command:.

    get-SPserviceinstance | where {$_.typename -like "*sql*"}  
    
  4. 確認 Windows 服務 SQL Server Analysis Services (PowerPivot) 執行中。Verify the Windows service SQL Server Analysis Services (PowerPivot) is running.

    Get-Service | where {$_.displayname -like "*powerpivot*"}  
    
  5. 在以 SharePoint 模式執行 SQL Server 2014SQL Server 2014 SQL Server Analysis Services (PowerPivot) Windows 服務的第一部 SharePoint 應用程式伺服器上, SQL Server Analysis Services (PowerPivot) ,以升級 POWERPIVOT 執行個體。Run SQL Server 2014SQL Server 2014 Setup on the first SharePoint application server that runs the SQL Server Analysis Services (PowerPivot) Windows service to upgrade the POWERPIVOT instance. 在 [SQL Server 安裝精靈] 的 [安裝] 頁面上,選擇升級選項。On the Installation page of the SQL Server Setup Wizard, choose the upgrade option. 如需詳細資訊, 請參閱使用安裝精靈(安裝程式)升級至 SQL Server 2014For more information, see Upgrade to SQL Server 2014 Using the Installation Wizard (Setup).

  6. 在執行組態工具之前,請先重新啟動伺服器Restart the server before running the configuration tool. 此步驟可確保 SQL Server 安裝程式安裝的任何更新或必要條件完全在系統上設定。This step ensures that any updates or prerequisites installed by SQL Server Setup are fully configured on the system.

  7. 在執行 SQL Server Analysis Services (PowerPivot) 服務的第一部 SharePoint 應用程式伺服器上執行 PowerPivot 設定工具, 以升級 sharepoint 中的方案和 Web 服務。Run the PowerPivot Configuration Tool on the first SharePoint application server that runs SQL Server Analysis Services (PowerPivot) service to upgrade the solutions and Web services in SharePoint. 您無法使用管理中心進行此步驟。You cannot use Central Administration for this step.

    1. 指向 [開始] 功能表上的 [所有程式] ,按一下 [ Microsoft SQL Server 2014Microsoft SQL Server 2014],然後按一下 [組態工具] ,再按一下 [PowerPivot 組態工具]On the Start menu, point to All Programs, click Microsoft SQL Server 2014Microsoft SQL Server 2014, click Configuration Tools, and then click PowerPivot Configuration Tool. 請注意,只有在本機伺服器上安裝了 PowerPivot for SharePointPowerPivot for SharePoint 時,才會列出此工具。Note that this tool is listed only when PowerPivot for SharePointPowerPivot for SharePoint is installed on the local server.

    2. 啟動時,組態工具會檢查 PowerPivot 伺服器陣列方案以及 PowerPivot Web 應用程式方案的狀態。At startup, the configuration tool checks the upgrade status of the PowerPivot farm solution and PowerPivot web application solutions. 如果偵測到這些方案的舊版本, 您會看到「偵測到較新版本的 PowerPivot 方案檔。If older versions of these solutions are detected, you will see the message "Newer versions of the PowerPivot solution files have been detected. 請選取升級選項以升級您的伺服器陣列」。Please select the upgrade option to upgrade your farm." 按一下 [確定] 以關閉訊息。Click OK to close the message.

    3. 按一下 [升級功能、服務、應用程式和方案] ,然後按一下 [確定] 繼續。Click Upgrade Features, Services, Applications and Solutions, and then click OK to continue.

    4. 會出現下列警告:「PowerPivot 管理儀表板中的活頁簿即將升級為最新版本。The following warning appears: "Workbooks in the PowerPivot Management Dashboard are about to be upgraded to the latest version. 您對現有活頁簿所做的任何自訂內容都將遺失。Any customizations you made to the existing workbooks will be lost. 您要繼續嗎?」Do you want to continue?"

      此警告指的是 PowerPivot 管理儀表板中,針對資料重新整理活動報告的活頁簿。This warning refers to workbooks in the PowerPivot Management Dashboard that report on data refresh activity. 如果您自訂這些活頁簿,當現有的檔案取代成較新的版本時,您對這些活頁簿所做的任何變更都會遺失。If you customized these workbooks, any changes you made to those workbooks will be lost when existing files are replaced with newer versions.

      按一下 [是] ,將活頁簿覆寫成較新的版本。Click Yes to overwrite the workbooks with newer versions. 否則,按一下 [否] ,返回首頁。Otherwise, click No to return to the home page. 將活頁簿儲存到不同的位置,讓您擁有一個副本,然後在準備好繼續時,返回此步驟。Save the workbooks to a different location so that you have a copy, and then return to this step when you are ready to continue.

      如需有關自訂儀表板中使用之活頁簿的詳細資訊,請參閱 自訂 PowerPivot 管理儀表板For more information about customizing workbooks used in the dashboard, see Customizing the PowerPivot Management Dashboard.

    5. 檢閱工作清單中的動作,並排除您不希望該工具執行的任何動作。Review the actions in the task list and exclude any that you do not want the tool to perform. 預設包含所有動作。All actions are included by default. 若要移除動作,請在工作清單中選取該動作,然後清除 [參數] 頁面上的 [在工作清單中包含這個動作] 核取方塊。To remove an action, select it in the task list, and then clear the Include this action in the task list checkbox on the Parameters page.

    6. 或者,在 [輸出] 索引標籤或 [指令碼] 索引標籤中檢閱詳細資訊。Optionally, review detailed information in the Output tab or Script tab.

      [輸出] 索引標籤是此工具即將執行之動作的摘要。The Output tab is a summary of the actions that will be performed by the tool. 此資訊會儲存在記錄檔中: c:\Program Files\Microsoft SQL Server\120\Tools\PowerPivotTools\ConfigurationTool\LogThis information is saved in log files at c:\Program Files\Microsoft SQL Server\120\Tools\PowerPivotTools\ConfigurationTool\Log.

      [指令碼] 索引標籤會顯示 PowerShell 指令程式,或參考此工具將執行的 PowerShell 指令碼檔案。The Script tab shows the PowerShell cmdlets or references the PowerShell script files that the tool will run.

    7. 按一下 [驗證] 來檢查每個動作是否有效。Click Validate to check whether each action is valid. 如果無法使用 [驗證] ,表示所有動作都適用於您的系統。If Validate is not available, it means that all of the actions are valid for your system. 如果可以使用 [驗證] ,表示您可能已經修改輸入值 (例如,Excel 服務應用程式名稱),或此工具可能已經判定府執行特定動作。If Validate is available, you might have modified an input value (for example, the Excel service application name), or the tool might have determined that a particular action cannot be performed. 如果無法執行某個動作,您必須排除該動作,或修正造成此動作標示為無效的基礎條件。If an action cannot be performed, you must exclude it or fix the underlying conditions that cause the action to be flagged as invalid.

      重要

      您必須一律先處理第一個動作 [升級伺服器陣列方案]The first action, Upgrade Farm Solution, must always be processed first. 此動作會註冊用來設定伺服器的 PowerShell 指令程式。It registers the PowerShell cmdlets that are used to configure the server. 如果此動作出現錯誤,請不要繼續。If you get an error on this action, do not continue. 在處理工作清單中的其他動作之前,請改用此錯誤所提供的資訊診斷並解決問題。Instead, use the information provided by the error to diagnose and resolve the problem before processing additional actions in the task list.

    8. 按一下 [執行] ,執行適用於此工作的所有動作。Click Run to perform all of the actions that are valid for this task. 只有在通過驗證檢查的情況下,才可以使用 [執行]Run is available only after the validation check is passed. 當您按一下 [執行] 時,會出現下列警告,提醒您動作是在批次模式下處理:「工具中標示為有效的所有組態設定都會套用到 SharePoint 伺服器陣列。When you click Run, the following warning appears, reminding you that actions are processed in batch mode: "All of the configuration settings that are flagged as valid in the tool will be applied to the SharePoint farm. 您要繼續嗎?」Do you want to continue?"

    9. 按一下 [是] 繼續。Click Yes to continue.

    10. 在伺服器陣列中升級方案和功能可能需要數分鐘才能完成。Upgrading solutions and features in the farm can take several minutes to complete. 在這段期間內, PowerPivot 資料的連接要求將會失敗, 並出現類似「無法重新整理資料」或「嘗試執行要求的動作時發生錯誤」的錯誤。During this time, connection requests for PowerPivot data will fail with errors like "Unable to refresh data" or "An error has occurred trying to perform the requested action. 請再試一次」。Please try again." 升級完成後,伺服器將會變成可以使用,而且將不再發生這些錯誤。After upgrade is finished, the server will become available and these errors will no longer occur.

  8. 針對伺服器陣列中的每個 SQL Server Analysis Services (PowerPivot) 服務重複此程式:1) 執行 SQL Server 安裝程式 2) 執行 PowerPivot 設定工具。Repeat the process for each SQL Server Analysis Services (PowerPivot) service in the farm: 1) Run SQL Server setup 2) Run the PowerPivot Configuration tool.

  9. 透過執行升級後的步驟以及檢查伺服器陣列中的 PowerPivot 伺服器版本,驗證升級成功。Verify that upgrade succeeded by performing the post-upgrade steps and by checking the version of PowerPivot servers in the farm. 如需詳細資訊,請參閱本主題中的 Post-upgrade verification tasks 和下列章節:For more information, see Post-upgrade verification tasks in this topic and the following section.

  10. 疑難排解錯誤Troubleshooting errors

    您可以在 [參數] 窗格中檢視每個動作的錯誤資訊。You can view error information in the Parameters pane for each action.

    針對與方案部署或撤銷相關的問題,請確認已啟動 SharePoint 2010 Administrator 服務。For problems related to solution deployment or retraction, verify the SharePoint 2010 Administrator service is started. 此服務會執行觸發伺服器陣列中組態變更的計時器作業。This service runs the timer jobs that trigger configuration changes in a farm. 如果該服務未執行,方案部署或撤銷將會失敗。If the service is not running, solution deployment or retraction will fail. 持續性錯誤指的是現有的部署或撤銷作業已經在佇列中,因此會攔截組態工具的其他動作。Persistent errors indicate that an existing deployment or retraction job is already in the queue and blocking further action from the configuration tool.

    1. 以管理員身分啟動 SharePoint 2010 管理命令介面,然後執行下列命令來檢視佇列中的作業:Start the SharePoint 2010 Management Shell as an administrator and then run the following command to view jobs in the queue:

      Stsadm -o enumdeployments  
      
    2. 檢閱現有部署的下列資訊:[類型] 是 [撤銷] 或 [部署]、[檔案] 是 powerpivotwebapp.wsp 或 powerpivotfarm.wsp。Review existing deployments for the following information: Type is Retraction or Deployment, File is powerpivotwebapp.wsp or powerpivotfarm.wsp.

    3. 針對與 PowerPivot 方案相關的部署或若是方案撤銷, 複製JobId的 GUID 值, 然後將它貼入下列命令 (使用 Shell 的 [編輯] 功能表上的 [標記]、[複製] 和 [貼上] 命令來複製 GUID):For deployments or retractions related to PowerPivot solutions, copy the GUID value for JobId and then paste it into the following command (use the Mark, Copy, and Paste commands on the Shell's Edit menu to copy the GUID):

      Stsadm -o canceldeployment -id "<GUID>"  
      
    4. 依序按一下 [驗證][執行] ,重試組態工具中的工作。Retry the task in the configuration tool by clicking Validate followed by Run.

    至於其他所有錯誤,請檢查 ULS 記錄檔。For all other errors, check the ULS logs. 如需詳細資訊, 請參閱設定及查看 SharePoint 記錄檔和(診斷)記錄 PowerPivot for SharePointFor more information, see Configure and View SharePoint Log Files and Diagnostic Logging (PowerPivot for SharePoint).

活頁簿Workbooks

升級伺服器不一定會升級伺服器上執行的 PowerPivot 活頁簿,但是使用舊版 PowerPivot for Excel 建立的舊活頁簿仍可如常運作,並使用該版提供的功能。Upgrading a server does not necessarily upgrade the PowerPivot workbooks that run on it, but older workbooks created in the previous version of PowerPivot for Excel will continue to work as before, using the features available in that release. 活頁簿可以維持運作,是由於已升級的伺服器具有屬於舊版安裝的 Analysis Services OLE DB 提供者版本所致。Workbooks remain functional because an upgraded server has the version of the Analysis Services OLE DB provider that was part of the previous installation.

資料重新整理Data Refresh

升級會影響資料重新整理作業。Upgrade will impact data refresh operations. 伺服器的排程資料重新整理僅適用於符合伺服器版本的活頁簿。Scheduled data refresh on the server is available only for workbooks that match the server version. 如果您裝載舊版的活頁簿,資料重新整理可能不再適用於這些活頁簿。If you are hosting workbooks from the previous version, data refresh might no longer work for those workbooks. 若要重新啟用資料重新整理,您必須升級活頁簿。To re-enable data refresh, you must upgrade the workbooks. 您可以在 PowerPivot for Excel 中升級每個活頁簿,或是針對 SharePoint 2010 中的資料重新整理功能啟用自動升級。You can upgrade each workbook manually in PowerPivot for Excel, or enable the auto-upgrade for data refresh feature in SharePoint 2010. 自動升級會在執行資料重新整理之前將活頁簿升級為最新版本,讓資料重新整理作業依排程執行。Auto-upgrade will upgrade a workbook to the current version prior to running data refresh, allowing data refresh operations to remain on schedule.

確認 PowerPivot 元件和服務的版本Verify the Versions of PowerPivot Components and Services

PowerPivotPowerPivot 系統服務和 Analysis Services 的所有執行個體必須是相同版本。All instances of PowerPivotPowerPivot System Service and Analysis Services must be the same version. 若要確認所有伺服器元件都是相同的版本,請檢查以下版本資訊:To verify that all server components are at the same version, check version information for the following:

驗證 PowerPivot 方案和 PowerPivot 系統服務的版本Verify the version of PowerPivot Solutions and the PowerPivot System Service

執行下列 PowerShell 命令:Run the following PowerShell command:

Get-PowerPivotSystemService  

驗證 CurrentSolutionVersionVerify the CurrentSolutionVersion. SQL Server 2014SQL Server 2014為12.0 版。<主要組建 >。<次要組建 >is version 12.0.<major build>.<minor build>

驗證 Analysis Services Windows 服務的版本Verify the version of the Analysis Services Windows Service

如果您只有升級 SharePoint 2010 伺服陣列中的部分 PowerPivot for SharePointPowerPivot for SharePoint 伺服器,則未升級之伺服器上的 Analysis ServicesAnalysis Services 執行個體將會比預期在伺服器陣列中的版本還舊。If you upgraded only some of your PowerPivot for SharePointPowerPivot for SharePoint servers in a SharePoint 2010 farm, the instance of Analysis ServicesAnalysis Services on un-upgraded servers will be older than the version expected in the farm. 您必須將所有的伺服器升級至相同版本,才可以加以使用。You will need to upgrade all of your servers to the same version in order for them to be usable. 使用下列其中一種方法來驗證每部電腦上的 SQL Server Analysis Services (PowerPivot) Windows 服務版本。Use one of the following methods to verify the version of the SQL Server Analysis Services (PowerPivot) Windows service on each computer.

Windows 檔案總管Windows File Explorer:

  1. 瀏覽至 Bin 資料夾,尋找 PowerPivotPowerPivot 執行個體。Navigate to the Bin folder for the PowerPivotPowerPivot instance. 例如 C:\Program Files\Microsoft SQL Server\MSAS12.POWERPIVOT\OLAP\binFor example C:\Program Files\Microsoft SQL Server\MSAS12.POWERPIVOT\OLAP\bin.

  2. 以滑鼠右鍵按一下 msmdsrv.exe,然後選取 [屬性]Right-click msmdsrv.exe, and select Properties.

  3. 按一下 [詳細資料]Click Details.

  4. SQL Server 2014SQL Server 2014檔案版本應為12.00。<主要組建 >。<次要組建 >。file version should be 12.00.<major build>.<minor build>.

  5. 驗證這個編號與 PowerPivot 方案和系統服務版本相同。Verify that this number is identical to the PowerPivot solution and system service version.

服務啟動資訊:Service start information:

當 PowerPivot 服務啟動時,會將版本資訊寫入至 Windows 事件記錄檔。When the PowerPivot service starts, it writes version information into the Windows event log.

  1. 執行 Windows eventvwrRun Windows eventvwr

  2. 建立來源 MSOLAP$POWERPIVOT的篩選。Create a filter for source MSOLAP$POWERPIVOT.

  3. 尋找類似下列的資訊層級事件Look for an information level event similar to the following

    服務已啟動。Service started. Microsoft SQL Server Analysis Services 64 Bit Evaluation (x64) RTM 12.0.2000.8Microsoft SQL Server Analysis Services 64 Bit Evaluation (x64) RTM 12.0.2000.8.

使用 PowerShell 來驗證檔案版本。Use PowerShell to verify file version.

您可以使用 PowerShell 來驗證產品版本。You can use PowerShell to verify the product version. 如果您想要編寫指令碼或自動化版本驗證,PowerShell 是個好選項。PowerShell is a good option if you want to script or automate version verification.

(get-childitem "C:\Program Files\Microsoft SQL Server\MSAS12.POWERPIVOT2000\OLAP\bin\msmdsrv.exe").VersionInfo  

上述 PowerShell 命令會傳回類似下列資訊:The above PowerShell command returns information similar to the following:

ProductVersion FileVersion FileNameProductVersion FileVersion FileName

12.0.2000.8 2014.0120.200 C:\Program Files\Microsoft SQL Server\MSAS12.POWERPIVOT2000\OLAP\bin\msmdsrv.exe12.0.2000.8 2014.0120.200 C:\Program Files\Microsoft SQL Server\MSAS12.POWERPIVOT2000\OLAP\bin\msmdsrv.exe

驗證 SharePoint 上的 MSOLAP 資料提供者版本Verify the MSOLAP Data Provider Version on SharePoint

使用下列指示即可查看 Excel Services 信任的 Analysis Services OLE DB 提供者版本。Use the following instructions to check which versions of the Analysis Services OLE DB providers are trusted by Excel Services. 您必須是伺服陣列或服務應用程式系統管理員,才能檢查 Excel Services 信任的資料提供者設定。You must be a farm or service application administrator to check the trusted data provider settings of Excel Services.

  1. 在 [管理中心] 的 [應用程式管理] 中,按一下 [管理服務應用程式]In Central Administration, in Application Management, click Manage service applications.

  2. 按一下 Excel Services 服務應用程式的名稱,例如 [ExcelServiceApp1]Click the name of the Excel Services service application, for example ExcelServiceApp1.

  3. 按一下 [信任的資料提供者]Click Trusted Data Providers. 您應該會看到 MSOLAP.5 (Microsoft OLE DB Provider for OLAP Services 11.0)。You should see MSOLAP.5 (Microsoft OLE DB Provider for OLAP Services 11.0). 如果您已升級 PowerPivot for SharePointPowerPivot for SharePoint 安裝,也會看到舊版的 MSOLAP.4。If you upgraded your PowerPivot for SharePointPowerPivot for SharePoint installation, you will also see MSOLAP.4 from the previous version.

  4. 如需詳細資訊,請參閱< Add MSOLAP.5 as a Trusted Data Provider in Excel Services>。For more information, see Add MSOLAP.5 as a Trusted Data Provider in Excel Services.

MSOLAP.4 會描述為 Microsoft OLE DB Provider for OLAP Services 10.0。MSOLAP.4 is described as the Microsoft OLE DB Provider for OLAP Services 10.0. 這個版本可能是與 Excel Services 一併安裝的 SQL Server 2008SQL Server 2008 預設版本,或者是 SQL Server 2008 R2SQL Server 2008 R2 版本。This version might be the default version from SQL Server 2008SQL Server 2008 that is installed with Excel Services, or it might be the SQL Server 2008 R2SQL Server 2008 R2 version. SharePoint 安裝的預設版本不支援 PowerPivot 資料存取。The default version that SharePoint installs does not support PowerPivot data access. 您必須擁有 SQL Server 2008 R2SQL Server 2008 R2 版本或更新的版本,才能連接 SharePoint 上的 PowerPivot 活頁簿。You must have the SQL Server 2008 R2SQL Server 2008 R2 version or later to connect to PowerPivot workbooks on SharePoint. 若要確認您擁有 SQL Server 2008 R2SQL Server 2008 R2 版本,請使用上一節中說明如何檢視檔案屬性以確認版本的指示。To verify you have the SQL Server 2008 R2SQL Server 2008 R2 version, use the instructions in the previous section that explain how to verify the version by viewing file properties.

驗證 ADOMD.NET 資料提供者版本Verify the ADOMD.NET Data Provider Version

使用下列指示來檢查所安裝的 ADOMD.NET 版本。Use the following instructions to check which version of ADOMD.NET is installed. 您必須是伺服陣列或服務應用程式系統管理員,才能檢查 Excel Services 信任的資料提供者設定。You must be a farm or service application administrator to check the trusted data provider settings of Excel Services.

  1. 在 SharePoint 應用程式伺服器上,瀏覽至 c:\Windows\AssemblyOn your SharePoint application server, browse to c:\Windows\Assembly.

  2. 依組件名稱排序,並搜尋 Microsoft.Analysis Services.Adomd.ClientSort by assembly name and find the Microsoft.Analysis Services.Adomd.Client.

  3. 確認您的版本為12.0。<組建編號 >。Verify you have version 12.0.<build number>.

升級 SharePoint 伺服器陣列中的多部 PowerPivot for SharePoint 伺服器Upgrading Multiple PowerPivot for SharePoint Servers in a SharePoint Farm

在包含多部 PowerPivot for SharePointPowerPivot for SharePoint 伺服器的多重伺服器拓撲中,所有伺服器執行個體和元件都必須是相同版本。In a multi-server topology that includes more than one PowerPivot for SharePointPowerPivot for SharePoint server, all server instances and components must be the same version. 執行最新軟體版本的伺服器會設定伺服陣列中所有伺服器的層級。The server that runs the highest version of the software sets the level for all servers in the farm. 如果您只要升級部分伺服器,執行較舊版軟體的伺服器在升級之前將變成無法使用。If you upgrade just some of the servers, the ones that are running older versions of the software will become unavailable until they are also upgraded.

升級第一部伺服器之後,尚未升級的其他伺服器 將會變成無法使用After you upgrade the first server, additional servers that are not yet upgraded will become unavailable. 在所有伺服器執行相同層級之後,即可恢復使用。Availability is restored after all servers run at the same level.

SQL Server 安裝程式會就地升級實體電腦上的 PowerPivot 方案檔案,但是若要升級伺服器陣列使用的方案,則必須使用本主題前面章節中所描述的 PowerPivot 組態工具。SQL Server Setup upgrades the PowerPivot solution files in place on the physical computer, but to upgrade the solutions in use by the farm, you must use the PowerPivot Configuration Tool described in a previous section of this topic..

將 QFE 套用至伺服器陣列中的 PowerPivot 實例Applying a QFE to a PowerPivot instance in the farm

修補 PowerPivot for SharePoint 伺服器會將現有的程式檔案更新成包含特定問題修正的較新版本。Patching a PowerPivot for SharePoint server updates existing program files with a newer version that includes a fix for a specific problem. 將 QFE 套用至多重伺服器拓撲時,沒有您必須先開始的主要伺服器。When applying a QFE to a multi-server topology, there is no primary server that you must begin with. 只要您將相同的 QFE 套用至伺服陣列中的其他 PowerPivot 伺服器,就可以從任何伺服器開始。You can start with any server as long as you apply the same QFE to the other PowerPivot servers in the farm.

套用 QFE 時,您也必須在伺服器陣列組態資料庫中執行更新伺服器版本資訊的組態設定。When you apply the QFE, you must also perform a configuration step that updates the server version information in the farm configuration database. 已修補之伺服器的版本會變成預期的伺服陣列新版本。The version of the patched server becomes the new expected version for the farm. 在所有機器上套用並設定 QFE 之前,沒有 QFE 的 PowerPivot for SharePoint 執行個體將無法用於處理 PowerPivot 資料的要求。Until the QFE is applied and configured across all machines, the PowerPivot for SharePoint instances that do not have the QFE will be unavailable to handle requests for PowerPivot data.

為確保正確套用並設定 QFE,請遵循下列指示進行:To ensure the QFE is applied and configured correctly, follow these instructions:

  1. 使用隨附在 QFE 中的指示,安裝修補程式。Install the patch using the instructions that are provided with the QFE.

  2. 啟動 PowerPivot 組態工具。Start the PowerPivot Configuration Tool.

  3. 按一下 [升級功能、服務、應用程式和方案] ,然後按一下 [確定]Click Upgrade Features, Services, Applications and Solutions, and then click OK.

  4. 檢閱升級工作中所包含的動作,然後按一下 [驗證]Review the actions that are included in the upgrade task, and then click Validate.

  5. 按一下 [執行] 套用動作。Click Run to apply the actions.

  6. 針對伺服器陣列中的其他 PowerPivot for SharePoint 執行個體,重複這個動作。Repeat for additional PowerPivot for SharePoint instances in the farm.

    重要

    在多重伺服器部署中,請務必先修補並設定每個執行個體,然後再繼續進行下一部機器。In a multi-server deployment, be sure to both patch and configure each instance before continuing to the next machine. PowerPivot 組態工具必須先完成目前執行個體的升級工作,才能移到下一個執行個體。The PowerPivot Configuration Tool must complete the upgrade task for the current instance before you move on to the next instance.

若要檢查伺服器陣列中服務的版本資訊,請在管理中心中的 [升級與修補管理] 區段中,使用 [檢查產品與修補程式安裝狀態] 頁面。To check version information for services in the farm, use the Check product and patch installation status page in the Upgrade and Patch Management section in Central Administration.

升級後的驗證工作Post-upgrade verification tasks

升級完成後,使用下列步驟來驗證伺服器正常運作。After upgrade is complete, use the following steps to verify the server is operational.

工作Task 連結Link
確認伺服器在執行 PowerPivot for SharePoint 的所有電腦上執行。Verify the service is running on all computers that run PowerPivot for SharePoint. 啟動或停止 PowerPivot for SharePoint 伺服器Start or Stop a PowerPivot for SharePoint Server
確認網站集合層級的功能啟用。Verify feature activation at the site collection level. 為在 [管理中心] 的 網站集合啟用 PowerPivot 功能整合Activate PowerPivot Feature Integration for Site Collections in Central Administration
確認個別的 PowerPivot 活頁簿會透過開啟活頁簿,並按一下篩選與交叉分析篩選器起始查詢來正確載入。Verify individual PowerPivot workbooks are loading properly by opening a workbook and clicking on filters and slicers to initiate a query. 檢查快取的檔案是否存在硬碟上。Check for the presence of cached files on the hard drive. 快取的檔案可確認資料檔案已在實體伺服器上載入。A cached file confirms that the data file was loaded on that physical server. 尋找 c:\Program Files\Microsoft SQL Server\MSAS12.POWERPIVOT\OLAP\Backup 資料夾中的快取檔案。Look for cached files in the c:\Program Files\Microsoft SQL Server\MSAS12.POWERPIVOT\OLAP\Backup folder.
在設定為資料重新整理的所選活頁簿上測試資料重新整理。Test data refresh on selected workbooks that are configured for data refresh. 測試資料重新整理最簡單的方式就是修改資料重新整理排程,也就是選擇 [並且盡快重新整理] 核取方塊,讓資料重新整理立即執行。The easiest way to test data refresh is to modify a data refresh schedule, choosing the Also refresh as soon as possible checkbox so that data refresh runs immediately. 此步驟將判斷目前活頁簿的資料重新整理是否成功。This step will determine whether data refresh is successful for the current workbook. 針對其他常用的活頁簿重複這些步驟以確保資料重新整理運作正常。Repeat these steps for other frequently used workbooks to ensure that data refresh is functional. 如需排程資料重新整理的詳細資訊, 請參閱排程資料重新整理 (PowerPivot for SharePoint)For more information about scheduling data refresh, see Schedule a Data Refresh (PowerPivot for SharePoint).
一段時間之後,監視 PowerPivot 管理儀表板中的資料重新整理報表以確認沒有資料重新整理錯誤。Over time, monitor the data refresh reports in PowerPivot Management Dashboard to confirm there are no data refresh errors. PowerPivot 管理儀表板和使用量資料PowerPivot Management Dashboard and Usage Data

如需如何設定 PowerPivot 設定和功能的詳細資訊, 請參閱管理中心的 Powerpivot 伺服器管理和設定。For more information about how to configure PowerPivot settings and features, see PowerPivot Server Administration and Configuration in Central Administration.

如需引導您完成所有安裝後設定工作的逐步指示, 請參閱初始設定(PowerPivot for SharePoint)For step-by-step instructions that guide you through all of the post-installation configuration tasks, see Initial Configuration (PowerPivot for SharePoint).

另請參閱See Also

SQL Server 2014 版本所支援的功能 Features Supported by the Editions of SQL Server 2014
PowerPivot for SharePoint 2010 安裝PowerPivot for SharePoint 2010 Installation