安裝適用於 SharePoint 2013 的 Reporting Services SharePoint 模式Install Reporting Services SharePoint Mode for SharePoint 2013

本主題中的程序會引導您完成 SharePoint 模式之 Reporting ServicesReporting Services 的單一伺服器安裝。The procedures in this topic guide you through a single server installation of Reporting ServicesReporting Services in SharePoint mode. 這些步驟包含執行 [SQL Server 安裝精靈],以及使用 SharePoint 管理中心的設定工作。The steps include running the SQL Server installation wizard as well as configuration tasks that use SharePoint Central Administration. 本主題也可以用於更新現有安裝的個別程序,例如建立 Reporting ServicesReporting Services 服務應用程式。The topic can also be used for individual procedures for updating an existing installation, for example to create a Reporting ServicesReporting Services service application.

適用於:Applies to: SharePoint 2013 | 附註: Reporting ServicesReporting Services SharePoint 模式支援 SharePoint Server 多重租用。適用於:Applies to: SharePoint 2013 | Note: Reporting ServicesReporting Services SharePoint mode does not support SharePoint Server multi-tenancy.

如需有關將其他 Reporting ServicesReporting Services 伺服器加入至現有伺服器陣列的詳細資訊,請參閱下列主題:For information on adding more Reporting ServicesReporting Services servers to an existing farm, see the following:

單一伺服器安裝對開發和測試案例很實用,但是不建議在實際執行環境中使用。A single server installation is useful for development and testing scenarios but it is not recommended for production environments.

本主題內容:In this topic:

單一伺服器部署範例Example Single-Server Deployment

單一伺服器安裝對開發和測試案例很實用,但是不建議在實際執行環境中使用單一伺服器。A single-server installation is useful for development and testing scenarios but a single-server is not recommended for a production environment. 單一伺服器環境是指在同一部電腦上安裝 SharePoint 和 Reporting ServicesReporting Services 元件的單一電腦。The single-server environment refers to a single computer that has SharePoint and Reporting ServicesReporting Services components installed on the same computer. 本主題並未涵蓋具有多部 Reporting ServicesReporting Services 伺服器的向外延展。The topic does not cover scale-out with multiple Reporting ServicesReporting Services servers.

下圖說明單一伺服器 Reporting ServicesReporting Services 部署之一部分的元件。The following diagram illustrates the components that are part of a single server Reporting ServicesReporting Services deployment.

(1)(1) 從 SQL Server 安裝所安裝的 SharePoint 服務。SharePoint service installed from SQL Server installation. 您可以建立一個或多個 Reporting ServicesReporting Services 服務應用程式。You can create one or more Reporting ServicesReporting Services service applications.
(2)(2) Reporting ServicesReporting Services 適用於 SharePoint 產品的增益集會在 SharePoint 伺服器上提供使用者介面元件。add-in for SharePoint products provides the user interface components on the SharePoint Servers.
(3)(3) 由 Power View 和 PowerPivot 所使用的 Excel 服務應用程式。The Excel Service Application used by Power View and PowerPivot.
(4)(4) PowerPivot 服務應用程式。PowerPivot service application.

SSRS SharePoint 模式單一伺服器部署SSRS SharePoint Mode Single Server Deployment

提示

如需更多複雜的部署範例,請參閱 SharePoint 中 SQL Server BI 功能的部署拓撲For more complex deployment examples, see Deployment Topologies for SQL Server BI Features in SharePoint.

安裝程式帳戶Setup accounts

本節將描述用於 SharePoint 模式之 Reporting ServicesReporting Services 主要部署步驟的帳戶和權限。This section describes the accounts and permissions used for the primary deployment steps of Reporting ServicesReporting Services in SharePoint mode.

安裝和註冊 Reporting ServicesReporting Services 服務:Installation and registering the Reporting ServicesReporting Services Service:

  • 目前的帳戶 (稱為 「 安裝程式 」 帳戶) 的安裝期間Reporting ServicesReporting Services在 SharePoint 模式需要在本機電腦的系統管理權限。The current account during the installation (referred to as the 'setup' account) of Reporting ServicesReporting Services in SharePoint mode needs to have administrative rights in the local computer. 如果您要安裝Reporting ServicesReporting Services安裝 SharePoint 的 「 安裝程式 」 帳戶也是 SharePoint 伺服器陣列系統管理員群組的成員後,當Reporting ServicesReporting Services安裝將會註冊Reporting ServicesReporting Services為您的服務。If you are installing Reporting ServicesReporting Services after SharePoint is installed and the 'setup' account is also a member of the SharePoint farm administrators group, the Reporting ServicesReporting Services installation will register the Reporting ServicesReporting Services service for you. 如果您安裝Reporting ServicesReporting Services安裝 SharePoint,或 「 安裝程式 」 帳戶不是 farm administrators 群組的成員之前,您必須手動註冊服務。If you install Reporting ServicesReporting Services before SharePoint is installed or the 'setup' account is not a member of the farm administrators group, you register the service manually. 請參閱節步驟 2:註冊並啟動 Reporting Services SharePoint 服務See the section Step 2: Register and Start the Reporting Services SharePoint Service.

建立 Reporting ServicesReporting Services 服務應用程式Creating Reporting ServicesReporting Services Service Applications

  • 安裝並註冊 Reporting ServicesReporting Services 服務之後,請建立一個或多個 Reporting ServicesReporting Services 服務應用程式。Following installation and registering the Reporting ServicesReporting Services service, create one or more Reporting ServicesReporting Services service applications. 「SharePoint 伺服器陣列服務帳戶」需要暫時成為本機 Administrators 群組的成員,才能建立 Reporting Services 服務應用程式。The "SharePoint farm service account " needs to temporarily be a member of the local administrators group so the Reporting Services service application can be created. 如需有關 SharePoint 2013 帳戶權限的詳細資訊,請參閱 < 帳戶的權限及 SharePoint 2013 中的安全性設定(https://technet.microsoft.com/library/cc678863.aspx) 。For more information on SharePoint 2013 account permissions, see Account permissions and security settings in SharePoint 2013 (https://technet.microsoft.com/library/cc678863.aspx).

    安全性最佳作法是避免讓 SharePoint 伺服陣列管理員帳戶同時成為本機作業系統管理員帳戶。It is security best practice that SharePoint farm administrator accounts are not also local operating system administrator accounts. 如果您在安裝程序中,將伺服陣列管理員帳戶加入至本機 Administrators 群組,建議您在安裝完成之後,從本機 Administrators 群組中移除該帳戶。If you add a farm admin account to the local administrators group as part of your installation process, it is recommended you remove the account from the local administrators group after installation is complete.

步驟 1:以 SharePoint 模式安裝 Reporting Services 報表伺服器Step 1: Install Reporting Services Report Server in SharePoint mode

這個步驟會在 SharePoint 模式下安裝 Reporting ServicesReporting Services 報表伺服器以及適用於 SharePoint 產品的 Reporting ServicesReporting Services 增益集。This step installs a Reporting ServicesReporting Services report server in SharePoint mode and the Reporting ServicesReporting Services add-in for SharePoint products. 根據電腦上已經安裝的元件而定,您可能不會看見下列步驟所描述的部分安裝頁面。Depending on what is already installed on your computer, you may not see some of the installation pages described in the following steps.

  1. 執行 [SQL Server 安裝精靈] (Setup.exe)。Run the SQL Server Installation Wizard (Setup.exe).

  2. 在精靈的左側按一下 [安裝] ,然後按一下 [新增 SQL Server 獨立安裝或將功能加入至現有安裝]Click Installation in the left side of the wizard and then click New SQL Server stand-alone installation or add features to an existing installation.

  3. [安裝程式支援規則] 頁面上按一下 [確定] (假設已通過所有規則)。Click OK on the Setup Support Rules page, assuming all rules passed.

  4. [安裝程式支援檔案] 頁面中按一下 [安裝]Click Install on the Setup Support Files page. 根據電腦上已經安裝的元件而定,您可能會看見下列訊息:Depending on what is already installed on your computer, you might see the following message:

    • 「一個或多個受影響的檔案有暫止的作業。"One or more affected files have operations pending. 您必須在安裝程序完成之後重新啟動電腦。」You must restart your computer after the setup process is completed."

    • 按一下 [確定]Click Ok.

  5. 在支援檔案完成安裝而且 [支援規則] 頁面顯示 [通過] 狀態之後,請按 [下一步]Click Next after the support files have completed installing and the Support Rules pages show a status of Passed. 檢閱任何警告或封鎖問題。Review any warnings or blocking issues.

  6. [安裝類型] 頁面上,按一下 [將功能加入到現有的 SQL Server 2014 執行個體]On the Installation Type page, click Add features to an existing instance of SQL Server 2014. 在下拉式清單中選取正確的執行個體,然後按 [下一步]Select the correct instance in the drop-down list and click Next.

  7. 如果您看見 [產品金鑰] 頁面,請輸入您的金鑰或接受 "Enterprise Evaluation" 版本的預設值。If you see the Product Key page, type your key or accept the default of the 'Enterprise Evaluation' edition.

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

  8. 如果您看見 [授權條款] 頁面,請檢閱並接受這些授權條款。If you see the License terms page, review and accept the license terms. Microsoft 感謝您同意傳送功能使用資料,協助改進產品功能及支援。Microsoft appreciates you clicking to agree to send feature usage data to help improve product features and support.

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

  9. 如果您看見 [安裝程式角色] 頁面,請選取 [SQL Server 功能安裝]If you see the Setup Role page, select SQL Server Feature Installation

    [下一步]Click Next

    適用於安裝程式角色的 SQL Server 功能安裝SQL Server Feature Installation for setup role

  10. [特徵選取] 頁面上,選取下列選項:Select the following on the Feature Selection page:

    • Reporting Services - SharePointReporting Services - SharePoint

    • 適用於 SharePoint 產品的 Reporting Services 增益集Reporting Services add-in for SharePoint Products.

      附註安裝增益集安裝精靈選項是使用新SQL Server 2014SQL Server 2014版本。note The installation wizard option for installing the add-in is new with the SQL Server 2014SQL Server 2014 release.

    • 如果您尚未有 SQL Server Database EngineDatabase Engine的執行個體,您也可以針對完整的環境選取 [Database Engine Services][管理工具 - 完整]If you do not already have an instance of SQL Server Database EngineDatabase Engine, you could also select Database Engine Services and Management Tools Complete for a complete environment.

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

    SSRS SharePoint 模式的特徵選取SSRS Feature Selection for SharePoint mode

  11. 如果您看見 [安裝規則] 頁面,If you see the Installation Rules page. 檢閱任何警告或封鎖問題。Review any warnings or blocking issues. 然後按 [下一步]Then click Next

  12. 如果您選取 Database Engine 服務,請接受 [執行個體組態] 頁面上的預設 [MSSQLSERVER] 執行個體,然後按 [下一步]If you selected the Database Engine services, accept the default instance of MSSQLSERVER on the Instance Configuration page and click Next.

    注意Reporting Services SharePoint 服務架構與舊版 Reporting Services 架構不同,不是以 SQL Server「執行個體」為基礎。noteThe Reporting Services SharePoint service architecture is not based on a SQL Server "instance" as was the previous Reporting Services architecture.

  13. 檢閱 [磁碟空間需求] 頁面,然後按 [下一步]Review the Disk Space Requirements page and click Next.

  14. 如果您看見 [伺服器組態] 頁面,請輸入適當的認證。If you see the Server Configuration page type appropriate credentials. 如果您想要使用 Reporting ServicesReporting Services 資料警示或訂閱功能,則必須將 SQL Server Agent 的 [啟動類型] 變更為 [自動]If you want to use the Reporting ServicesReporting Services data alerting or subscription features, you need to change the Startup Type for SQL Server Agent to Automatic. 根據電腦上已經安裝的元件而定,您可能不會看見 [伺服器組態] 頁面。You may not see the Server Configuration page, depending on what is already installed on the computer.

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

  15. 如果您選取了 Database Engine 服務,就會看到 [資料庫引擎組態] 頁面。請將適當的帳戶加入至 SQL 管理員清單,然後按 [下一步]If you selected the Database Engine services, you will see the Database Engine Configuration page, add appropriate accounts to the list of SQL Administrators and click Next.

  16. [Reporting Services 組態] 頁面上,您應該會看到已選取 [只安裝] 選項。On the Reporting Services Configuration page you should see the Install only option is selected. 這個選項會安裝報表伺服器檔案,但是不會設定 Reporting ServicesReporting Services的 SharePoint 環境。This option installs the report server files, and does not configure the SharePoint environment for Reporting ServicesReporting Services.

    注意

    當 SQL Server 安裝完成時,請遵循本主題其他章節來設定 SharePoint 環境。When the SQL Server installation is complete, follow the other sections of this topic to configure the SharePoint environment. 包括安裝 Reporting ServicesReporting Services 共用服務及建立 Reporting ServicesReporting Services 服務應用程式。This Includes installing the Reporting ServicesReporting Services shared service and creating Reporting ServicesReporting Services service applications.

    SQL Server 安裝精靈-SSRS 組態頁面SQL Server Setup Wizard - SSRS Configuration Page

  17. 按一下 [錯誤報告] 頁面上的核取方塊傳送錯誤報告,協助 Microsoft 改進 SQL Server 功能與服務。Help Microsoft improve SQL Server features and services by clicking the check box to send error reports on the Error Reporting page.

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

  18. 檢閱任何警告,然後在 [安裝組態規則] 頁面上按 [下一步]Review any warnings and then click Next on the Installation Configuration Rules page.

  19. [準備安裝] 頁面上檢閱安裝摘要,然後按 [下一步]On the Ready to Install page, review the installation summary and then click Next. 此摘要將包括其值顯示為 [SharePointFilesOnlyMode][Reporting Services SharePoint 模式] 子節點。The summary will include a Reporting Services SharePoint Mode child node that will show a value of SharePointFilesOnlyMode. 按一下 [安裝]Click Install.

  20. 安裝需要幾分鐘的時間。The installation will take several minutes. 您將會看見 [完成] 頁面,其中列出功能以及每項功能的狀態。You will see the Complete page with the features listed and the status of each feature. 您可能會看見資訊對話方塊,指出電腦需要重新啟動。You may see an information dialog indicating the computer needs to be restarted.

步驟 2:註冊並啟動 Reporting Services SharePoint 服務Step 2: Register and Start the Reporting Services SharePoint Service

PowerShell 相關內容PowerShell related content

注意

如果您要在現有的 SharePoint 伺服器陣列中進行安裝,則不需要完成本節中的步驟。If you are installing into an existing SharePoint farm, you do not need to complete the steps in this section. 當您在本文件的上一節執行 SQL Server 安裝精靈時,就會安裝並啟動 Reporting ServicesReporting Services SharePoint 服務。The Reporting ServicesReporting Services SharePoint service is installed and started when you ran the SQL Server installation wizard as part of the previous section of this document.

您需要手動註冊 Reporting ServicesReporting Services 服務的常見原因如下。The following are the common reasons why you need to manually register the Reporting ServicesReporting Services service.

  • 您在安裝 SharePoint 之前已安裝 Reporting ServicesReporting Services SharePoint 模式。You installed Reporting ServicesReporting Services SharePoint mode before SharePoint was installed.

  • 此用來安裝 Reporting ServicesReporting Services SharePoint 模式的帳戶,不是 SharePoint 伺服器陣列管理員群組的成員。The account used to install Reporting ServicesReporting Services SharePoint mode, was not a member of the SharePoint farm administrators group. 如需詳細資訊,請參閱< Setup accounts>一節。For more information, see the section Setup accounts.

必要檔案會隨 [SQL Server 安裝精靈] 安裝,但是您必須在 SharePoint 伺服器陣列中註冊服務。The necessary files were installed as part of the SQL Server installation wizard, but the services need to be registered into the SharePoint farm. SQL Server 2014SQL Server 2014 版本引進了適用於 SharePoint 模式中 Reporting ServicesReporting Services 的 PowerShell 支援。The SQL Server 2014SQL Server 2014 release introduces PowerShell support for Reporting ServicesReporting Services in SharePoint mode.

下列步驟將引導您開啟 SharePoint 管理命令介面並執行指令程式:The following steps guide you through opening the SharePoint Management Shell and running cmdlets:

  1. 按一下 [開始] 按鈕Click the Start button

  2. 按一下 [Microsoft SharePoint 2013 產品] 群組。Click the Microsoft SharePoint 2013 Products group.

  3. 以滑鼠右鍵按一下 [SharePoint 2013 管理命令介面] ,然後按一下 [以系統管理員身分執行]Right-click SharePoint 2013 Management Shell click Run as administrator. 注意:標準 Windows PowerShell 視窗無法辨識 SharePoint 命令。NOTE: the SharePoint commands are not recognized in the standard Windows PowerShell window. 請使用 [SharePoint 2013 管理命令介面]Use the SharePoint 2013 Management Shell.

  4. 執行下列 PowerShell 命令安裝 SharePoint 服務。Run the following PowerShell command to install the SharePoint service. 成功完成命令會在管理命令介面中顯示新行。A successful completion of the command displays a new line in the management shell. 成功完成命令之後,不會有任何訊息傳回 管理命令介面:No message is returned to the management shell when the command completes successfully:

    Install-SPRSService  
    

    重要

    如果您看到類似下列的錯誤訊息:If you see an error message similar to the following:

    Install-sprsservice:'Install-sprsservice' 詞彙無法辨識Install-SPRSService : The term 'Install-SPRSService' is not recognized as the
    Cmdlet、函數、指令檔或可執行程式的名稱。name of a cmdlet, function, script file, or operable program. 請檢查Check the
    名稱拼字是否正確,如果包含路徑的話,請確認路徑是否spelling of the name, or if a path was included, verify that the path is
    正確,然後再試一次。correct and try again.

  5. 執行下列 PowerShell 命令以安裝服務 Proxy。Run the following PowerShell command to install the service proxy. 成功完成命令會在管理命令介面中顯示新行。A successful completion of the command displays a new line in the management shell. 成功完成命令之後,不會有任何訊息傳回 管理命令介面:No message is returned to the management shell when the command completes successfully:

    Install-SPRSServiceProxy  
    
  6. 執行下列 PowerShell 命令以啟動服務,或參閱下列附註,以取得有關如何從 SharePoint 管理中心啟動服務的指示:Run the following PowerShell command to start the service or see the following notes for instructions on how to start the service from SharePoint Central administration:

    get-spserviceinstance -all |where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance  
    

您使用的可能是 Windows Powershell 而非 SharePoint 管理命令介面,或者未安裝 Reporting ServicesReporting Services SharePoint 模式。Either you are in the Windows Powershell instead of the SharePoint Management Shell or Reporting ServicesReporting Services SharePoint mode is not installed. 如需 Reporting ServicesReporting Services 和 PowerShell 的詳細資訊,請參閱 Reporting Services SharePoint 模式的 PowerShell CmdletFor more information on Reporting ServicesReporting Services and PowerShell, see PowerShell cmdlets for Reporting Services SharePoint Mode.

您也可以從 SharePoint 管理中心啟動服務,而不是執行第三個 PowerShell 命令。You can also start the service from SharePoint central Administration rather than running the third PowerShell command. 下列步驟也可用於確認服務是否執行。The following steps are also useful to verify that the service is running.

  1. 在 SharePoint 管理中心內,按一下 [系統設定] 群組中的 [管理伺服器上的服務]In SharePoint Central Administration, click Manage Services on Server in the System Settings group.

  2. 找到 [SQL Server Reporting Services 服務] ,然後按一下 [動作] 欄中的 [啟動]Find SQL Server Reporting Services Service and click Start in the Action column.

  3. Reporting Services 服務的狀態會從 [已停止] 變更為 [已啟動]The status of the Reporting Services service will change from Stopped to Started. 如果清單中沒有 Reporting Services 服務,請使用 PowerShell 安裝該服務。If the Reporting Services service is not in the list, use PowerShell to install the service.

    注意

    如果 Reporting Services 服務停留在 [啟動中] 狀態,而未變更為 [已啟動] ,請確認已在 Windows 伺服器管理員中啟動 'SharePoint 2013 Administration' 服務。If the Reporting Services service stays in the Starting status and does not change to Started, verify the 'SharePoint 2013 Administration' service is started in Windows Server Manager.

步驟 3:建立 Reporting Services 服務應用程式Step 3: Create a Reporting Services Service Application

本節提供建立服務應用程式的步驟,以及屬性的描述 (如果您要檢閱現有的服務應用程式)。This section provides the steps to create a service application and a description of the properties, if you are reviewing an existing service application.

  1. 在 SharePoint 管理中心的 [應用程式管理] 群組中,按一下 [管理服務應用程式]In SharePoint Central Administration, in the Application Management group, click Manage Service Applications.

  2. 在 SharePoint 功能區中,按一下 [新增] 按鈕。In the SharePoint ribbon, click the New button.

  3. 在 [新增] 功能表中,按一下 [SQL Server Reporting Services 服務應用程式]In the New menu, click SQL Server Reporting Services Service Application..

    重要

    如果Reporting ServicesReporting Services選項不會不會出現在清單中,它是指示所Reporting ServicesReporting Services共用的服務未安裝If the Reporting ServicesReporting Services option does not appear in the list, it is an indication that the Reporting ServicesReporting Services shared service is not installed. 檢閱上一節中,如何使用 PowerShell Cmdlt 來安裝 Reporting ServicesReporting Services 服務的相關資訊。Review the previous section on how to use PowerShell cmdlts to install the Reporting ServicesReporting Services service.

  4. [建立新的 SQL Server Reporting Services 服務應用程式] 頁面中,輸入應用程式的名稱。In the Create SQL Server Reporting Services Service Application page, enter a name for the application. 如果您要建立多個 Reporting Services 服務應用程式,描述性名稱和命名慣例將有助於您組織管理作業。If you are creating multiple Reporting Services service applications, a descriptive name or naming convention will help you organize your administration and management operations.

  5. [應用程式集區] 區段中,建立應用程式的新應用程式集區 (建議)。In Application Pool section, create a new application pool for the application (recommended). 如果您針對應用程式集區和服務應用程式使用相同的名稱,可讓進行中的管理更容易。If you use the same name for both the application pool and the services application, it can make ongoing administration easier. 這可能也會受到您將建立的服務應用程式數目以及是否需要在單一應用程式集區中使用許多應用程式所影響。This can also be affected by how many service applications you will create and if you need to use several in a single application pool. 請參閱 SharePoint Server 文件集以取得應用程式集區管理的建議事項和最佳作法。See the SharePoint Server documentation on recommendations and best practices for application pool management.

    針對應用程式集區選取或建立安全性帳戶。Select or create a security account for the application pool. 請務必指定網域使用者帳戶。Be sure to specify a domain user account. 網域使用者帳戶會啟用 SharePoint 受管理帳戶功能,好讓您在一個地方更新密碼和帳戶資訊。A domain user account enables the use of the SharePoint managed account feature, which lets you update passwords and account information in one place. 如果您計劃將部署向外延展,以包括在相同識別下執行的其他服務執行個體,也需要網域帳戶。Domain accounts are also required if you plan to scale out the deployment to include additional service instances that run under the same identity.

  6. [資料庫伺服器] 中,您可以使用目前的伺服器或選擇不同的 SQL Server。In the Database Server, you can use the current server or choose a different SQL Server.

  7. [資料庫名稱] 中,預設值是 ReportingService_<guid>,這是唯一的資料庫名稱。In Database Name the default value is ReportingService_<guid>, which is a unique database name. 若您要輸入新值,請輸入唯一值。If you type a new value, type a unique value. 這是專門針對服務應用程式所建立的新資料庫。This is the new database to be created specifically for the services application.

  8. [資料庫驗證] 中,預設值是 Windows 驗證。In Database Authentication, the default is Windows Authentication. 如果您選擇 [SQL 驗證] ,請參考 SharePoint 文件,以了解在 SharePoint 部署中使用這個驗證類型的最佳作法。If you choose SQL Authentication, refer to SharePoint documentation for best practices on how to use this authentication type in a SharePoint deployment.

  9. [Web 應用程式關聯] 區段中,選取要佈建以供目前 Reporting Services 服務應用程式存取的 Web 應用程式。In the Web Application Association section, select the Web Application to be provisioned for access by the current Reporting Services Service Application. 您可以建立一個 Reporting Services 服務應用程式與一個 Web 應用程式的關聯。You can associate one Reporting Services service application to one web application. 如果目前所有的 Web 應用程式已有相關聯的 Reporting Services 服務應用程式,則會顯示警告訊息。If all of the current web applications are already associated with a Reporting Services service application, you see a warning message.

  10. 按一下 [確定] 。Click OK.

  11. 服務應用程式的建立程序會需要數分鐘才能完成。The process to create a service application could take several minutes to complete. 完成後,您會看到確認訊息及 [提供訂閱和警示] 頁面的連結。When it is complete, you will see a confirmation message and a link to a Provision Subscriptions and Alerts page. 如果您想要使用 Reporting ServicesReporting Services 訂閱功能或資料警示功能,請完成提供步驟。Complete the provision step if you want to use the Reporting ServicesReporting Services subscriptions feature or the data alerts feature. 如需詳細資訊,請參閱 SSRS 服務應用程式的佈建訂用帳戶及警示For more information, see Provision Subscriptions and Alerts for SSRS Service Applications.

PowerShell 相關內容如需使用 PowerShell 建立Reporting ServicesReporting Services服務應用程式,請參閱:PowerShell related content For information on using PowerShell to create a Reporting ServicesReporting Services service application, see:

步驟 4:啟用 Power View 網站集合功能。Step 4: Activate the Power View Site Collection Feature.

Power ViewPower View (適用於 SQL Server 2014SQL Server 2014 SharePoint 產品之 Reporting ServicesReporting Services MicrosoftMicrosoft 增益集的功能) 是網站集合功能。, a feature of SQL Server 2014SQL Server 2014Reporting ServicesReporting Services Add-in for MicrosoftMicrosoft SharePoint Products, is a site collection feature. 將會針對根網站集合以及安裝 Reporting ServicesReporting Services 增益集之後所建立的網站集合自動啟用此功能。The feature is activated automatically for root site collections and site collections created after the Reporting ServicesReporting Services add-in is installed. 如果您打算使用 Power ViewPower View,請確認此功能是否已啟用。If you plan to use Power ViewPower View, verify that the feature is activated.

如果您在安裝 SharePoint Server 之後安裝適用於 SharePoint 產品的 Reporting ServicesReporting Services 增益集,只會針對根網站集合啟用報表伺服器整合功能和 Power View 整合功能。If you install the Reporting ServicesReporting Services add-in for SharePoint Products after the installation of the SharePoint Server, then the Report Server integration feature and the Power View integration feature will only be activated for root site collections. 如果是其他網站集合,請手動啟用這些功能。For other site collections, manually activate the features.

若要啟動或確認 Power View 網站集合功能To Activate or Verify the Power View Site Collection Feature

  1. 下列步驟會假設您的 SharePoint 網站設定為 2013 體驗版The following steps assume your SharePoint site is configured for the 2013 experience version.

    開啟瀏覽器,移至所要的 SharePoint 網站。Open your browser to the desired SharePoint site. 例如, http://<伺服器名稱>/sites/biFor example http://<servername>/sites/bi

  2. 按一下 設定SharePoint 設定Click SettingsSharePoint Settings.

  3. 按一下 [網站設定]Click Site settings.

  4. [網站集合管理] 群組中,按一下 [網站集合功能]In the Site Collection Administration group Click Site collection features.

  5. 在清單中尋找 [Power View 整合功能]Find Power View Integration Feature in the list.

  6. 按一下 [啟用]Click Activate. 功能狀態會變更為 [使用中]The feature status will change to Active.

每個網站集合都已完成這個程序。This procedure is completed per site collection. 如需詳細資訊,請參閱 在 SharePoint 中啟用報表伺服器和 Power View 整合功能For more information, see Activate the Report Server and Power View Integration Features in SharePoint.

步驟 1-4 的 Windows PowerShell 指令碼Windows PowerShell script for Steps 1-4

本節中的 PowerShells 指令碼與上一節的完成步驟 1 到 4 相同。The PowerShells script in this section are the equivalent of completing steps 1 to 4 in the previous sections. 此指令碼完成下列各項:The script completes the following:

  • 安裝 Reporting ServicesReporting Services 服務和服務 Proxy,以及啟動服務。Installs Reporting ServicesReporting Services service and service proxy, and starts the service.

  • 建立名為 "Reporting Services" 的服務 Proxy。Creates a service proxy named "Reporting Services".

  • 建立Reporting ServicesReporting Services服務應用程式名為"Reporting Services Application"。Creates a Reporting ServicesReporting Services service application named "Reporting Services Application".

  • 啟用網站集合的 Power ViewPower View 功能。Enables the Power ViewPower View feature for a site collection.

參數Parameters

  • 更新服務 Proxy 的 -AccountUpdate the -Account for the service proxy. 帳戶必須是 SharePoint 伺服器陣列中受管理的服務帳戶。The account needs to be a managed service account in the SharePoint farm. 如需詳細資訊,請參閱 SharePoint 主題< 規劃 SharePoint 2013 管理帳戶及服務帳戶>。For more information, see the SharePoint topic Plan for administrative and service accounts in SharePoint 2013.

  • 更新服務應用程式的 -DatabaseServer 參數。Update the -DatabaseServer parameter for the service application. 這個參數是 Database Engine 執行個體This parameter is the database engine instance

  • 更新您想要啟用 Power ViewPower View 功能之網站的 -url 參數。Update the -url parameter of the site that you want the Power ViewPower View feature enabled.

若要使用指令碼:To use the script:

  1. 使用系統管理權限來開啟 Windows PowerShell。Open Windows PowerShell with administrative privileges.

  2. 將下列程式碼複製到指令碼視窗。Copy the following code into the script window.

  3. 更新上一節中描述的三個參數,然後執行指令碼。Update the three parameters described in the previous section, and then run the script.

#This script Configures SQL Server Reporting Services SharePoint mode  
  
$starttime=Get-Date  
write-host -foregroundcolor DarkGray StartTime>> $starttime   
  
Write-Host -ForegroundColor Green "Import the SharePoint PowerShell snappin"  
Add-PSSnapin Microsoft.Sharepoint.Powershell -EA 0  
  
Write-Host -ForegroundColor Green "Install SSRS Service and Service Proxy, and start the service"  
Write-Host -ForegroundColor Green ">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>"  
  
    Write-Host -ForegroundColor Green "Install the Reporting Services Shared Service"  
    Install-SPRSService  
  
    Write-Host -ForegroundColor Green " Install the Reporting Services Service Proxy"  
    Install-SPRSServiceProxy  
  
    # Get the ID of the RS Service Instance and start the service   
    Write-Host -ForegroundColor Green "Start the Reporting Services Service"  
    $RS = Get-SPServiceInstance | Where {$_.TypeName -eq "SQL Server Reporting Services Service"}  
    Start-SPServiceInstance -Identity $RS.Id.ToString()  
  
    # Wait for the Reporting Services Service to start...  
    $Status = Get-SPServiceInstance $RS.Id.ToString()  
    While ($Status.Status -ne "Online")  
    {  
        Write-Host -ForegroundColor Green "SSRS Service Not Online...Current Status = " $Status.Status  
        Start-Sleep -Seconds 2  
        $Status = Get-SPServiceInstance $RS.Id.ToString()  
    }  
  
$time=Get-Date  
write-host -foregroundcolor DarkGray StartTime>> $starttime   
write-host -foregroundcolor DarkGray $time  
  
Write-Host -ForegroundColor Green "Create a new application pool and Reporting Services service application"  
Write-Host -ForegroundColor Green ">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>"  
Write-Host -ForegroundColor Green "Create a new application pool"  
#!!!! update "-Account" with an existing Managed Service Account  
New-SPServiceApplicationPool -Name "Reporting Services" -Account "<domain>\User name>"  
$appPool = Get-SPServiceApplicationPool "Reporting Services"  
  
Write-Host -ForegroundColor Green " Create the Reporting Services Service Application"  
#!!!! Update "-DatabaseServer", an instance of the SQL Server database engine   
$rsService = New-SPRSServiceApplication -Name "Reporting Services Application" -ApplicationPool $appPool -DatabaseName "Reporting_Services_Application" -DatabaseServer "<server name>"  
  
Write-Host -ForegroundColor Green "Create the Reporting Services Service Application Proxy"  
$rsServiceProxy = New-SPRSServiceApplicationProxy -Name "Reporting Services Application Proxy" -ServiceApplication $rsService  
  
Write-Host -ForegroundColor Green "Associate service application proxy to default web site and grant web applications rights to SSRS application pool"  
Write-Host -ForegroundColor Green ">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>"     
# Associate the Reporting Services Service Applicatoin Proxy to the default web site...  
Get-SPServiceApplicationProxyGroup -default | Add-SPServiceApplicationProxyGroupMember -Member $rsServiceProxy  
  
$time=Get-Date  
write-host -foregroundcolor DarkGray StartTime>> $starttime   
write-host -foregroundcolor DarkGray $time  
  
Write-Host -ForegroundColor Green "Enable the PowerView and reportserver site features"  
Write-Host -ForegroundColor Green ">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>"  
#!!!! update "-url"  of the site where you want the features enabled  
Enable-SPfeature -identity "powerview" -Url http://server/sites/bi  
Enable-SPfeature -identity "reportserver" -Url http://server/sites/bi  
  
####To Verify, you can run the following:  
#Get-SPRSServiceApplication  
#Get-SPServiceApplicationPool | where {$_.name -like "reporting*"}  
#Get-SPRSServiceApplicationProxy  
  

其他組態Additional Configuration

本節描述多數 SharePoint 部署中重要的其他組態步驟。This section describes additional configuration steps that are important in most SharePoint deployments.

設定 Excel Services 和 PowerPivotConfigure Excel Services and PowerPivot

如果您想要在 SharePoint 中檢視 Excel 2013 活頁簿中的 Power ViewPower View Power View 報表,就必須將伺服器陣列上的 Excel Services 應用程式設定為使用 SharePoint 模式中的 Analysis ServicesAnalysis Services 伺服器。If you want to view Power ViewPower View Power View reports in an Excel 2013 workbook in SharePoint, an Excel Services Application on the farm needs to be configured to use an Analysis ServicesAnalysis Services Server in SharePoint mode. 此外, Reporting ServicesReporting Services 服務應用程式所使用的應用程式集區安全性帳戶必須是 Analysis Services 伺服器的系統管理員。Also, the application pool security account used by the Reporting ServicesReporting Services service application, must be an administrator on the Analysis Services Server. 如需詳細資訊,請參閱下列內容:For more information, see the following:

提供訂閱和警示Provision Subscriptions and Alerts

Reporting ServicesReporting Services 訂閱和資料警示可能需要 SQL Server Agent 權限組態。The Reporting ServicesReporting Services subscription and data alert features may require the configuration of SQL Server Agent permissions. 如果您看到錯誤訊息,指出需要 SQL Server Agent,且您已確認 SQL Server Agent 正在執行,則請更新權限。If you see an error message that indicates SQL Server Agent is required and you have verified SQL Server Agent is running, update the permissions. 您可以在成功建立服務應用程式頁面上,按一下 [提供訂閱和警示] 連結,以移至其他頁面並提供 SQL Server Agent。You can click the link Provision Subscriptions and Alerts on the create service application success page to go to another page for provisioning SQL Server Agent. 如果您的部署跨電腦界限 (例如 SQL Server 資料庫執行個體位於其他電腦上),則需要提供步驟。The provision step is needed if your deployment crosses machine boundaries, for example when the SQL Server database instance is on a different machine. 如需詳細資訊,請參閱 SSRS 服務應用程式的佈建訂閱及警示For more information, see Provision Subscriptions and Alerts for SSRS Service Applications

設定 SSRS 服務應用程式的電子郵件Configure E-mail for SSRS Service Applications

Reporting ServicesReporting Services 資料警示功能會以電子郵件訊息傳送警示。The Reporting ServicesReporting Services data alerts feature sends alerts in e-mail messages. 若要傳送電子郵件,您可能需要設定 Reporting ServicesReporting Services 服務應用程式,以及修改服務應用程式的電子郵件傳遞延伸模組。To send e-mail you may need to configure your Reporting ServicesReporting Services service application and you may need to modify the e-mail delivery extension for the service application. 如果您計劃針對 Reporting ServicesReporting Services 訂閱功能使用電子郵件傳遞延伸模組,則需要電子郵件設定。If you plan to use the e-mail delivery extension for the Reporting ServicesReporting Services subscription feature, the e-mail settings are required. 如需詳細資訊,請參閱設定 Reporting Services 服務應用程式的電子郵件 (SharePoint 2010 和 SharePoint 2013)For more information, see Configure E-mail for a Reporting Services Service Application (SharePoint 2010 and SharePoint 2013)

將 Reporting Services 內容類型加入至內容庫Add Reporting Services Content Types to Content Libraries

Reporting ServicesReporting Services 會提供預先定義的內容類型,可用來管理共用資料來源 (.rsds) 檔、報表模型 (.smdl) 檔,以及報表產生器的報表定義 (.rdl) 檔。provides predefined content types that are used to manage shared data source (.rsds) files, report models (.smdl), and Report Builder report definition (.rdl) files. [報表產生器報表][報表模型][報表資料來源] 內容類型加入至文件庫會啟用 [新增] 命令,讓您能夠建立該類型的新文件。Adding a Report Builder Report, Report Model, and Report Data Source content type to a library enables the New command so that you can create new documents of that type. 如需詳細資訊,請參閱 < 將報表伺服器內容類型加入至文件庫(以 SharePoint 整合模式的 Reporting Services)For more information, see Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode).

啟動報表伺服器檔案同步處理功能Activate the Report Server File sync Feature

如果使用者經常直接上傳已發行的報表項目至 SharePoint 文件庫, [報表伺服器檔案同步處理] 網站層級功能會很有協助。If users will frequently upload published report items directly to SharePoint document libraries, the Report Server File Sync site level feature will be beneficial. 檔案同步處理功能會更頻繁地同步處理報表伺服器目錄與文件庫中的項目。The file sync feature will synchronize the report server catalog with items in document libraries on a more frequent basis. 如需詳細資訊,請參閱 在 SharePoint 管理中心啟動報表伺服器檔案同步處理功能For more information, see Activate the Report Server File Sync Feature in SharePoint Central Administration.

驗證安裝Verify the installation

以下是驗證 Reporting ServicesReporting Services SharePoint 模式部署的建議步驟和程序。The following are suggested steps and procedures to verify the Reporting ServicesReporting Services SharePoint mode deployment.

  • 請參閱驗證主題< Verify a Reporting Services Installation>中的<SharePoint>一節。See the SharePoint section in the verification topic Verify a Reporting Services Installation.

  • 在 SharePoint 文件庫中,建立只包含一個文字方塊 (例如標題) 的基本 Reporting ServicesReporting Services 報表。In a SharePoint document library, create a basic Reporting ServicesReporting Services report that only contains a text box, for example a title. 此報表不包含任何資料來源或資料集。The report does not contain any data sources or datasets. 目標是確認您可以開啟報表產生器、建立基本報表和預覽報表。The goal is to verify you can open Report Builder, build a basic report, and preview the report.

    將報表儲存至文件庫,然後從文件庫中執行報表。Save the report to the document library and the run the report from the library. 如需使用報表產生器建立報表的詳細資訊,請參閱啟動報表產生器 (報表產生器)For more information on creating reports with Report Builder, see Start Report Builder (Report Builder).

另請參閱See Also

Reporting Services SharePoint 模式的 PowerShell Cmdlet PowerShell cmdlets for Reporting Services SharePoint Mode
升級和移轉 Reporting Services Upgrade and Migrate Reporting Services
內容藍圖:安裝及設定 SharePoint Server 和 SQL Server BI Content Roadmap: Set up and configure SharePoint Server and SQL Server BI
SQL server 2012 版本支援的功能 Features Supported by the Editions of SQL Server 2012
Reporting Services SharePoint 服務和服務應用程式Reporting Services SharePoint Service and Service Applications