將其他報表伺服器加入至伺服器陣列 (SSRS 向外延展)Add an Additional Report Server to a Farm (SSRS Scale-out)

在 SharePoint 伺服器陣列中加入第二個或更多的 SharePoint 模式報表伺服器,可以改善報表伺服器的處理效能和回應時間。Adding a second or more SharePoint mode report servers to your SharePoint farm can improve the performance and response time of the report server processing. 如果您發現新增更多使用者、報表和其他應用程式到報表伺服器時效能降低了,那麼新增額外的報表伺服器可以改善效能。If you find performance slowing down as you added more users, reports, and other applications to the report server, then adding additions report servers can improve performance. 此外,當硬體發生問題或者您在環境中的個別伺服器上執行一般維護作業時,也建議您加入第二個報表伺服器以提高報表伺服器的可用性。It is also recommended to add a second report server to increase the availability of report servers when there are issues with hardware or you are conducting general maintenance on individual servers in your environment. SQL Server 2012SQL Server 2012 版開始,在 SharePoint 模式中向外延展 Reporting ServicesReporting Services 環境的步驟會遵循標準 SharePoint 伺服器陣列部署,並且運用 SharePoint 負載平衡功能。Starting with the SQL Server 2012SQL Server 2012 release, the steps to scale-out a Reporting ServicesReporting Services environment in SharePoint mode follows standard SharePoint farm deployment and leverages the SharePoint load balancing features.

重要

並非所有 Reporting ServicesReporting Services 版本都支援向外延展 [SQL Server]SQL ServerScale-out of Reporting ServicesReporting Services is not supported on all editions of [SQL Server]SQL Server. 如需詳細資訊,請參閱 < Reporting ServicesReporting Services 一節支援的 SQL Server 2014 的版本功能For more information, see the Reporting ServicesReporting Services section of Features Supported by the Editions of SQL Server 2014.

提示

SQL Server 2012SQL Server 2012 版開始,您不會使用 Reporting ServicesReporting Services 組態管理員來加入伺服器以及向外延展報表伺服器。Starting with SQL Server 2012SQL Server 2012 you do not use Reporting ServicesReporting Services Configuration Manager to add servers and scale out report servers. SharePoint 產品會在具有 Reporting ServicesReporting Services 服務的 SharePoint 伺服器加入至伺服器陣列時,管理向外延展 Reporting Services。SharePoint products manage the scale-out of reporting services as SharePoint servers with the Reporting ServicesReporting Services service are added to the farm.

如需如何向外延展原生模式報表伺服器的資訊,請參閱設定原生模式報表伺服器向外延展部署 (SSRS 組態管理員)For information on how to scale-out native mode report servers, see Configure a Native Mode Report Server Scale-Out Deployment (SSRS Configuration Manager).

負載平衡Load Balancing

除非您的環境具有自訂或協力廠商負載平衡解決方案,否則 SharePoint 將自動管理 Reporting ServicesReporting Services 服務應用程式的負載平衡。The Load balancing of Reporting ServicesReporting Services service applications will be managed automatically by SharePoint unless your environment has a custom or third-party load balancing solution. 預設的 SharePoint 負載平衡行為是,每個 Reporting ServicesReporting Services 服務應用程式都將在您已經啟動 Reporting ServicesReporting Services 服務的所有應用程式伺服器之間取得平衡。The default SharePoint load balancing behavior is that each Reporting ServicesReporting Services Service Application will be balanced across all the application servers where you have started the Reporting ServicesReporting Services service. 若要確認 Reporting ServicesReporting Services 服務是否已安裝並啟動,請按一下 SharePoint 管理中心內的 [管理伺服器上的服務]To verify if the Reporting ServicesReporting Services service is installed and started, click Manage services on server in SharePoint Central Administration.

必要條件Prerequisites

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

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

  • 您必須知道裝載 SharePoint 組態和內容資料庫之現有資料庫伺服器的名稱。You need to know the name of the existing database server that is hosting the SharePoint configuration and content databases.

  • 資料庫伺服器必須設定為允許遠端資料庫連接。The database server must be configured to allow for remote database connections. 如果不允許,您就無法將新的伺服器加入伺服器陣列,因為新的伺服器將無法建立 SharePoint 組態資料庫的連接。If it is not, you will not be able to join the new server to the farm because the new server will not be able to make a connection to the SharePoint configuration databases.

  • 新的伺服器必須安裝目前伺服器陣列伺服器所執行的相同 SharePoint 版本。The new server will need to have the same version of SharePoint installed that the current farm servers are running. 例如,如果伺服器陣列已經安裝 SharePoint 2010 Service Pack 1 (SP1),您也必須在新的伺服器上安裝 SP1,才能讓它加入伺服器陣列。For example if the farm already has SharePoint 2010 Service Pack 1 (SP1) installed, you will need to also install SP1 on the new server before it can join the farm.

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

    在 SharePoint 2010 伺服器陣列中使用 SQL Server BI 功能的指引Guidance for Using SQL Server BI Features in a SharePoint 2010 Farm

步驟Steps

本主題中的步驟假設 SharePoint 伺服器陣列管理員要安裝及設定伺服器。The steps in this topic assume that a SharePoint farm administrator is installing and configuring the server. 下圖顯示一般三層環境,而且下圖中的編號項目將於下列清單中描述:The diagram shows a typical three tier environment and the numbered items in the diagram are described in the following list:

  • (1) 多個 Web 前端 (WFE) 伺服器。(1) Multiple web front-end (WFE) servers. WFE 伺服器需要適用於 SharePoint 2010 的 Reporting ServicesReporting Services 增益集。The WFE servers require the Reporting ServicesReporting Services add-in for SharePoint 2010.

  • (2) 執行 Reporting ServicesReporting Services 和網站的單一應用程式伺服器,例如管理中心。(2) A single application server running Reporting ServicesReporting Services and web sites, for example Central Administration. 下列步驟會將第二個應用程式伺服器加入至這一層。The following steps add a second application server to this tier.

  • (3) 兩個 SQL Server 資料庫伺服器。(3) Two SQL Server database servers.

  • (4) 代表軟體或硬體網路負載平衡解決方案 (NLB)。(4) Represents a software or hardware network load balancing solution (NLB)

新增 Reporting Services 應用程式伺服器Adding a Reporting Services application server

下列步驟假設管理員要安裝及設定伺服器。The following steps assume that an administrator is installing and configuring the server. 此伺服器將在伺服器陣列中設定為新的應用程式伺服器,而且不會當做 Web 前端 (WFE) 使用。The server will be setup as a new application server in the farm and not used as a web front-end (WFE).

步驟Step 說明和連結Description and Link
執行 SharePoint 2010 產品準備工具Run the SharePoint 2010 Products Preparation Tool 您必須擁有 SharePoint 2010 安裝媒體。You must have the SharePoint 2010 installation media. 準備工具是安裝媒體上的 PrerequisiteInstaller.exeThe preparation tool is PrerequisiteInstaller.exe on the installation media.
安裝 SharePoint 2010 產品。Install a SharePoint 2010 product. 1) 選取伺服器陣列安裝類型。1) Select the Server Farm installation type.

2) 選取完成伺服器類型。2) Select Complete for the server type.

3) 安裝完成時,如果您現有的 SharePoint 伺服器陣列已安裝 SharePoint 2010 SP1,請不要執行 [SharePoint 產品設定精靈]。3) When the installation is complete, do not run the SharePoint Products Configuration wizard if your existing SharePoint farm has SharePoint 2010 SP1 installed. 您應該先安裝 SharePoint SP1,然後再執行 SharePoint 產品設定精靈。You should install SharePoint SP1 before running the SharePoint products configuration wizard.
安裝 SharePoint Server 2010 SP1。Install SharePoint Server 2010 SP1. 如果您現有的 SharePoint 伺服器陣列已安裝 SharePoint 2010 SP1 下載並安裝從 SharePoint 2010 SP1:https://support.microsoft.com/kb/2460045If your existing SharePoint farm has SharePoint 2010 SP1 installed download and install SharePoint 2010 SP1 from:https://support.microsoft.com/kb/2460045.

如需有關 SharePoint 2010 SP1 的詳細資訊,請參閱 安裝 Office 2010 SP1 和 SharePoint 2010 SP1 時的已知問題For more information on SharePoint 2010 SP1, see Known issues when you install Office 2010 SP1 and SharePoint 2010 SP1:
執行 SharePoint 產品設定精靈,將伺服器加入至伺服器陣列。Run the SharePoint Products Configuration wizard to add the server to the farm. 1) 在Microsoft SharePoint 2010 產品程式群組中,按一下Microsoft SharePoint 2010 產品組態精靈1) In the Microsoft SharePoint 2010 Products program group, click Microsoft SharePoint 2010 Products Configuration Wizard.

2) 在連線至伺服器陣列頁面上,選取連接到現有的伺服陣列然後按一下下一步2) On the Connect to a Server Farm page select Connect to an existing Farm and click Next.

3) 在指定組態資料庫設定頁面上,輸入用於現有的伺服陣列和組態資料庫的名稱的資料庫伺服器的名稱。3) On the Specify Configuration Database Settings page, type the name of the database server used for the existing farm and the name of the configuration database. 按一下 [下一步] 。Click Next.
** 重要* * 如果您看到類似下面的錯誤訊息,而且您已經確認自己擁有的權限,然後確認 SQL Server 網路組態,在啟用了哪些通訊協定Sql ServerConfiguration Manager: 「 無法連接到資料庫伺服器。** Important ** If you see an error message similar to the following and you have verified you have permissions, then verify what protocols are enabled for the SQL Server Network Configuration in Sql Server Configuration Manager:"Failed to connect to the database server. 確定資料庫存在、 資料庫是 Sql Server,而且您有適當的權限來存取伺服器。 」Ensure the database exists , is a Sql Server, and that you have the appropriate permissions to access the server."
** 重要* * 如果您看到的頁面伺服器陣列產品及修補狀態,您必須檢閱頁面上的資訊,然後才可以繼續使用所需的檔案來更新伺服器將伺服器加入至伺服器陣列。** Important ** If you see the page Server Farm Product and Patch Status, you will need to review the information on the page and update the server with the needed files before you can proceed with joining the server to the farm.

4) 在指定的伺服器陣列安全性設定頁面上輸入您的伺服器陣列複雜密碼,然後按一下下一步4) On the Specify Farm Security Settings page type your farm passphrase and click Next. 在確認頁面上,按 [下一步] 執行精靈。Click Next on the confirmation page to run the wizard.

5) 按一下下一步來執行伺服陣列組態精靈5) Click Next to run the Farm Configuration Wizard.
確認伺服器已加入至 SharePoint 伺服器陣列。Verify the server was added to the SharePoint farm. 1) 在 SharePoint 管理中心內,按一下 [系統設定] 群組中的 [管理此伺服器陣列中的伺服器] 。1) In SharePoint Central Administration, click Manage servers in this farm in the System Settings group.

2) 確認已加入新的伺服器,而且狀態正確。2) Verify the new server is added and the status is correct.

3) 請注意,您不會看到服務SQL Server Reporting Services 服務執行。3) Note you do not see the service SQL Server Reporting Services Service running. 下一個步驟將會安裝此服務。The service will be installed in the next step.

4) 若要從 WFE 角色中移除此伺服器,請按一下管理伺服器上的服務和停止該服務Microsoft SharePoint Foundation Web 應用程式4) To remove this server from the WFE role, click Manage services on server and stop the service Microsoft SharePoint Foundation Web Application.
安裝和設定 Reporting Services SharePoint 模式。Install and configure Reporting Services SharePoint mode. 執行 SQL Server 2014SQL Server 2014 安裝。Run SQL Server 2014SQL Server 2014 installation. 如需有關安裝Reporting ServicesReporting ServicesSharePoint 模式中,請參閱 < 安裝 Reporting Services SharePoint Mode for SharePoint 2010如果伺服器只會當做應用程式伺服器和伺服器不會使用為一部 wfe 伺服器,您不需要選取Reporting Services 增益集適用於 SharePoint 產品上:For more information on the installation of Reporting ServicesReporting Services SharePoint mode, see Install Reporting Services SharePoint Mode for SharePoint 2010 If the server will only be used as an application server and the server will not be used as a WFE, you do not need to select Reporting Services add-in for SharePoint products on:

安裝程式角色頁面上,選取SQL Server 功能安裝the Setup Role page, select SQL Server Feature Installation

特徵頁面上,選取Reporting Services-SharePointthe Feature Selection page, select Reporting Services - SharePoint

-或--OR-

Reporting Services 組態頁面上,確認只安裝選項選取Reporting Services SharePoint 模式the Reporting Services Configuration page verify the Install Only option is selected for Reporting Services SharePoint Mode.
確認 Reporting Services 可以運作。Verify that Reporting Services is operational. 1) 在 SharePoint 管理中心內,按一下 [系統設定] 群組中的 [管理此伺服器陣列中的伺服器] 。1) In SharePoint Central Administration, click Manage servers in this farm in the System Settings group.

2) 確認 [SQL Server Reporting Services 服務] 正在執行。2) Verify the service SQL Server Reporting Services Service.

如需詳細資訊,請參閱< Verify a Reporting Services InstallationFor more information, see Verify a Reporting Services Installation

其他組態Additional Configuration

您可以將向外延展部署中的個別 Reporting ServicesReporting Services 伺服器最佳化為僅執行背景處理,如此伺服器就不會與互動報表執行作業競用資源。You can optimize individual Reporting ServicesReporting Services servers in a scaled out deployment to perform background processing only so they do not compete for resources with interactive report execution. 背景處理包括排程、訂閱和資料警示。Background processing includes schedules, subscriptions, and data alerts.

若要變更個別報表伺服器的行為,請將 RSreportServer.config 設定檔中的 <IsWebServiceEnable> 設定為 false。To change the behavior of individual report servers, set <IsWebServiceEnable> to false in the RSreportServer.config configuration file.

根據預設,報表伺服器的 <IsWebServiceEnable> 會設定為 TRUE。By default reports servers are configured with <IsWebServiceEnable> set to TRUE. 當所有伺服器都設定為 TRUE 時,伺服器陣列中所有節點的互動和背景就能達到負載平衡。When all servers are configured for TRUE, interactive and background will be load balanced across all nodes in the farm.

如果您將所有報表伺服器的 <IsWebServiceEnable> 設定為 False,當您嘗試使用 Reporting ServicesReporting Services 功能時,就會看見類似以下的錯誤訊息:If you configure all report servers with <IsWebServiceEnable> set to False, you will see an error message similar to the following when you try to use Reporting ServicesReporting Services features:

未啟用 Reporting Services Web 服務。The Reporting Services Web Service is not enabled. 設定 Reporting Services SharePoint 服務有至少一個執行個體<Iswebserviceenable> > 設為 true。Configure at least one instance of the Reporting Services SharePoint Service to have <IsWebServiceEnable> set to true. 如需詳細資訊,請參閱修改 Reporting Services 組態檔 (RSreportserver.config)For more information, see Modify a Reporting Services Configuration File (RSreportserver.config)

另請參閱See Also

將 web 或應用程式的伺服器新增至 SharePoint 2013 中的伺服器陣列 Add web or application servers to farms in SharePoint 2013
設定服務 (SharePoint Server 2010)Configure services (SharePoint Server 2010)