如何設定 Orchestrator 資料庫連線How to configure Orchestrator database connections

重要

此版本的 Orchestrator 已達終止支援,建議您 升級至 Orchestrator 2019This version of Orchestrator has reached the end of support, we recommend you to upgrade to Orchestrator 2019.

在您每天的協調器作業中,您可能需要將連接設定變更為 Orchestrator 資料庫。As part of your day-to-day operations of Orchestrator you may need to change the connection settings to the Orchestrator database. 您可以 DBSetup 公用程式來變更這種設定。You can us the DBSetup utility to change this setting. 常見的案例是連線到已還原的備份。The common scenario is connecting to a restored backup.

此公用程式提供兩種功能:This utility provides two functions:

  1. DBSetup 可讓您變更 Management 伺服器或 Runbook 伺服器用來連線到資料庫的資料庫名稱或認證。DBSetup allows you to change the database name or credentials that are used by the management server or runbook servers to connect to the database.
  2. DBSetup 可讓您連線到重建的資料庫。DBSetup allows you to connect to a rebuilt database.

在連線到重建的資料庫時:When connecting to a rebuilt database:

  • 您只能針對在 Management 伺服器安裝期間使用的同一部資料庫伺服器執行此程序。This procedure can only be performed against the same database server used during the installation of the management server.
  • 您必須擁有建立資料庫的資料庫權限。You must have database permissions to create the database.

相反地,DBconfig 只會建立新資料庫,不會設定資料庫的安全性。In contrast, DBconfig only creates a new database; it does not configure the security for the database. DBConfig 可設定資料庫中的資料庫架構,以及建立 settings.dat(含有 Management 伺服器和 Runbook 伺服器的連線詳細資料) 的內容。DBConfig configures the database schema in the database and creates the contents of settings.dat, which contains the connection details for the management server and runbook servers. 如需 執行 DBConfig 的詳細資訊,請參閱 How to Change the Orchestrator DatabaseFor more information on running DBConfig, see How to Change the Orchestrator Database.

設定 Orchestrator 資料庫連接To configure Orchestrator database connections

  • 從 [開始] **** 功能表或從 Program Files 資料夾執行 DBsetup 二進位檔。Run the DBsetup binary from the Start menu or from the Program Files folder.

在新的資料庫伺服器上建立新資料庫To create a new database on a new database server

  1. 執行 Orchestrator 安裝程式,並安裝新的管理伺服器。Run the Orchestrator Setup Wizard, and install a new management server.
  2. 在安裝精靈的 [設定資料庫伺服器] **** 頁面上,指向新的資料庫伺服器。On the Configure the database server page in the setup wizard, point to the new database server.
  3. 在部署中新增 DB 伺服器後,您還必須執行 permissionsconfig,然後再匯出服務主要金鑰並將其匯入新的資料庫伺服器。After you add a new DB server to your deployment, you must also run permissionsconfig, and then export and import the service master key to the new database server.

後續步驟Next steps

深入瞭解如何變更 orchestrator 資料庫,以瞭解如何 變更 Orchestrator 資料庫Learn more about how to change the Orchestrator database at How to Change the Orchestrator Database.