如何移動報表伺服器角色How to Move the Reporting Server Role

重要

已不再支援此版本的 Operations Manager,建議升級至 Operations Manager 2019This version of Operations Manager has reached the end of support, we recommend you to upgrade to Operations Manager 2019.

您可以將 System Center Operations Manager 報表伺服器元件移動到新的伺服器,或是在原始伺服器上重新安裝元件。You can move the System Center Operations Manager Reporting server component to a new server, or reinstall the component on the original server.

在此移動過程中,Operations Manager 會停止在 OperationsManagerDW 資料庫中儲存資料,直到您完成重新安裝 Operations Manager 報表伺服器為止。During this move, Operations Manager stops storing data in the OperationsManagerDW database until you complete the Operations Manager reporting server reinstall.

使用本文中的步驟將報表伺服器移動到新的伺服器並驗證移動是否成功。Use the procedures in this article to move the reporting server to a new server and verify the success of the move. 您必須備份任何在 Operations Manager 之外撰寫的報告、我的最愛,以及儲存在報表伺服器資料庫中的排程。You must back up any custom reports authored outside of Operations Manager, favorites, and schedules which are stored in the report server database. 如需移動 SQL Server 報表服務安裝所需之準備和步驟的詳細資訊,請參閱將報表伺服器資料庫移至其他電腦 (SSRS 原生模式)For more information about the preparation and steps required to move the SQL Server reporting services installation, see Moving the Report Server Databases to Another Computer (SSRS Native Mode).

注意

請確認您已確實遵循所有的步驟。若沒有的話,可能會導致資料損毀。Ensure that you follow all steps precisely, as not doing so might result in data corruption.

移轉概觀Migration Overview

Reporting Services 的移轉過程包含了手動和自動步驟。The migration process for Reporting Services includes manual and automated steps. 下列工作是報表伺服器移轉的一部分:The following tasks are part of a report server migration:

  • 備份資料庫和設定檔,例如 Web.config (若您已將報表伺服器設定為啟用 FIPS 相容的話)。Back up databases and configuration files, such as Web.config if you configured report server to enable FIPS compliance.
  • 備份加密金鑰。Back up the encryption key.
  • 安裝新的 SQL Server 執行個體。Install a new instance of SQL Server. 若您使用的是相同的硬體,您可以將 SQL Server 與您現有的安裝並存安裝 (若現有的安裝為支援版本的話)。If you are using the same hardware, you can install SQL Server side-by-side with your existing installation if it was one of the supported versions.
  • 設定報表伺服器。Configure the report server.
  • 安裝 Operations Manager 報表伺服器元件。Install Operations Manager Reporting server component.
  • 將報表伺服器資料庫從您現有的安裝移動到新的 SQL Server 安裝。Move the report server database from your existing installation to your new SQL Server installation.
  • 還原 Web.config 中定義的設定,以包含在先前設定中啟用的自訂設定。Restore settings defined in Web.config to include custom settings enabled in the previous configuration.

備份資料Backup data

  1. 建立資料倉儲資料庫的完整備份。Create a full backup of the data warehouse database. 預設名稱為 OperationsManagerDWThe default name is OperationsManagerDW. 同樣的,建立 ReportServerReportServerTempDB 資料庫的完整備份。Also create a full backup of the ReportServer and ReportServerTempDB database. 如需詳細資訊,請參閱建立完整資料庫備份 (SQL Server)For more information, see Create a Full Database Backup (SQL Server).
  2. 在目前的 Operations Manager 報表伺服器上,備份 SSRS 加密金鑰。On the current Operations Manager reporting server, backup the SSRS encryption key. 如需詳細資訊,請參閱 SSRS 加密金鑰 - 備份與還原加密金鑰For more information, see SSRS Encryption Keys - Back Up and Restore Encryption Keys.
  3. 備份報表伺服器設定檔。Back up the report server configuration files. 要備份的檔案包含:Files to back up include:
    • Web.configWeb.config

解除安裝 Operations Manager 報表伺服器Uninstall Operations Manager reporting server

  1. 在目前的 Operations Manager 報表伺服器上,遵循下列步驟來解除安裝 Operations Manager 報表伺服器元件:On the current Operations Manager reporting server, uninstall the Operations Manager reporting server component as follows:
    a.a. 開啟控制台,然後按一下 [程式和功能] 。Open Control Panel, and then click Programs and Features.
    b.b. 在 [程式和功能] 中,選取 [System Centrer Operations Manager] ,然後按一下 [解除安裝/變更] 。In Programs and Features, select System Center Operations Manager, and then click Uninstall/Change.
    c.c. 在 [Operations Manager 設定精靈] 中,按一下 [移除功能] 。In the Operations Manager Setup wizard, click Remove a feature.
    d.d. 在 [選取要移除的功能] 頁面中,選取 [報表伺服器] ,然後按一下 [解除安裝] 。In the Select features to remove page, select Reporting server, and then click Uninstall. 在精靈完成之後,按一下 [關閉] 。Click Close when the wizard finishes.

  2. 在代管資料倉儲資料庫的 SQL Server 執行個體上,還原您先前備份的資料倉儲資料庫。On the SQL Server instance hosting the data warehouse database, restore the data warehouse database you previously backed up. 如需詳細資訊,請參閱還原資料庫備份 (SQL Server Management Studio)For more information, see Restore a Database Backup (SQL Server Management Studio).

安裝 SQL Server Reporting ServicesInstall SQL Server Reporting Services

  1. 若您是在新的伺服器上安裝 Operations Manager 報表伺服器元件,請執行全新安裝 SQL Server Reporting ServicesIf you are installing the Operations Manager reporting server component on a new server, perform a new install SQL Server Reporting Services.
  2. 若您是在原始伺服器上重新安裝 Operations Manager 報表伺服器元件,您必須遵下列步驟移除原始安裝留下來的任何資料:If you are reinstalling the Operations Manager reporting server component on the original server, you must remove any data that is left from the original installation by doing the following:
    a.a. 將位於產品來源媒體上 SupportTools 資料夾中的 ResetSRS.exe 工具複製到本機資料夾。Copy the ResetSRS.exe tool from the SupportTools folder on the product source media to a local folder.
    b.b. 使用 [以系統管理員身分執行] 選項開啟命令提示字元視窗,遵循下列步驟來執行此工具:ResetSRS.exe <SQL Server instance name>Open a command prompt window using the Run as Administrator option and run the tool as follows: ResetSRS.exe <SQL Server instance name>. 在這裡,SQL Server 執行個體名稱為安裝 SQL Reporting Services 的 SQL Server 執行個體,例如 Instance1Here, SQL Server instance name is the SQL Server instance that SQL Reporting Services is installed on, such as Instance1. 若 SQL Server 使用的是預設執行個體,則請輸入 MSSQLSERVERIf SQL Server is using the default instance, enter MSSQLSERVER.
    d.d. 使用 Reporting Services 設定工具設定報表伺服器 Web 服務及入口網站 URL,以及報表伺服器資料庫。Configure the report server Web service and portal URL, and report server database using the Reporting Services Configuration tool. 如需詳細資訊,請參閱設定報表伺服器 (Reporting Services 原生模式)For more information, see Configure a Report Server (Reporting Services Native Mode).

驗證 SQL 報表伺服器安裝Verify the installation of SQL Report server

若您正在原始伺服器上重新安裝 Operations Manager 報表伺服器元件,請執行下列步驟以確認 SQL Reporting Services 已正常運作。If you are reinstalling the Operations Manager reporting server component on the original server, perform the following steps to confirm SQL Reporting Services is working correctly.

  1. 執行 Reporting Services 設定工具並連線到您安裝的報表伺服器執行個體。Run the Reporting Services Configuration tool and connect to the report server instance you just installed. Web 服務 URL 頁面包含報表伺服器 Web 服務的連結。The Web Service URL page includes a link to the Report Server Web service. 按一下該連結,以驗證您可以存取伺服器。Click the link to verify you can access the server.
  2. 開啟瀏覽器,並在網址列鍵入報表伺服器 URL。Open a browser and type the report server URL in the address bar. 該位址是由您在安裝過程中為報表伺服器指定的伺服器名稱和虛擬目錄名稱所組成。The address consists of the server name and the virtual directory name that you specified for the report server during setup. 根據預設,報表伺服器虛擬目錄的名稱為 ReportServerBy default, the report server virtual directory is named ReportServer. 您可以使用下列 URL 來驗證報表伺服器安裝:http:///ReportServer<_instance name>You can use the following URL to verify report server installation: http:///ReportServer<_instance name>. 若您將報表伺服器安裝為具名執行個體,則 URL 可能會有所不同。The URL will be different if you installed the report server as a named instance.
  3. 若要驗證入口網站已安裝成功並正常執行,請開啟瀏覽器並在網址列鍵入入口網站 URL。To verify that the web portal is installed and running, open a browser and type the Web Portal URL in the address bar. 該位址是由您在安裝過程,或是在 Reporting Services 設定工具的入口網站 URL 頁面中為入口網站指定的伺服器名稱和虛擬目錄名稱所組成。The address consists of the server name and the virtual directory name that you specified for the web portal during setup or in the Web Portal URL page in the Reporting Services Configuration tool. 根據預設,入口網站的虛擬目錄為 ReportsBy default, the web portal virtual directory is Reports. 您可以使用下列 URL 來驗證入口網站安裝:http:///Reports<_instance name>You can use the following URL to verify the web portal installation: http:///Reports<_instance name>.

安裝 Operations Manager 報表伺服器Install Operations Manager Reporting server

  1. 在新的 Operations Manager 報表伺服器上,遵循下列步驟來安裝 Operations Manager 報表伺服器元件:On the new Operations Manager reporting server, install the Operations Manager Reporting server component as follows:
    a.a. 在 [設定] 的 [SQL Server Reporting Services 執行個體] 頁面上,確認 SQL Server 執行個體已指向新的 SQL Server 執行個體 (若您要將報表移動到新伺服器的話)。On the Configuration, SQL Server instance for reporting services page, make sure the SQL Server instance refers to the new SQL Server instance if you are moving reporting to a new server.
    b.b. 在 [設定] 的 [設定 Operations Managers 帳戶] 頁面上,確認資料讀取器帳戶與您先前用於報表伺服器的帳戶相同。On the Configuration, Configure Operation Manager accounts page, be sure the Data Reader account is the same account previously used for the report server.

若您正在新的 SQL Server Reporting Services 執行個體上還原原始設定,請針對 SQL Server Reporting Services 還原原始的 ReportServerReportServerTempDB 資料庫,以保留您的自訂報告、我的最愛,以及來自原始 Reporting Services 部署的排程。If you are restoring the original configuration on a new SQL Server reporting services instance, restore the original ReportServer and ReportServerTempDB databases for SQL Server Reporting services to preserve your custom reports, favorites, schedules from the original reporting services deployment.

  1. 驗證 RSExecRole 為具有操作報表伺服器資料庫及暫存資料庫的資料庫角色。Verify the RSExecRole is a database role with the report server database and temporary database. RSExecRole 必須具備報表伺服器資料庫資料表的選取、輸入、更新、刪除及參考權限,以及預存程序的執行權限。RSExecRole must have select, insert, update, delete, and reference permissions in the report server database tables, and execute permissions on the stored procedures.
  2. 還原您先前備份的加密金鑰。Restore the encryption keys you backed up earlier. 如需詳細資訊,請參閱 SSRS 加密金鑰 - 備份與還原加密金鑰For more information, see SSRS Encryption Keys - Back Up and Restore Encryption Keys.
  3. 還原定義在 Web.config 中,於先前設定內啟用的自訂設定。Restore custom settings defined in Web.config enabled in the previous configuration.
  4. 重新啟動報表伺服器服務。Restart the Report Server service.

在完成安裝及後續設定步驟後,請執行下列步驟來確認 Operations Manager 報表已正常運作。After completing the installation and post-configuration steps, perform the following to confirm Operations Manager reporting is working correctly.

  1. 驗證您是否可以從 Operations 主控台中成功執行報表。Verify that you can successfully run a report from the Operations console.
  2. 確定所有管理伺服器的健全狀況狀態為狀況良好Ensure that the health state of all Management servers is Healthy.

後續步驟Next steps