修改 Orchestrator 資料庫Modify the Orchestrator database

重要

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

您可能必須在安裝後變更 Orchestrator 資料庫的位置,因為您可能會想要分隔管理伺服器和資料庫伺服器、將資料庫移到較大的伺服器或叢集,或是只根據環境中的必要變更重新設定 Orchestrator 資料庫。You might have to change the location of the Orchestrator database after installation, because you might want to separate the management server and database server, move the database to a larger server or a cluster, or just reconfigure the orchestration database based on required changes in your environment. 您可以使用標準 Microsoft SQL Server 方法將現有的資料庫移至另一部伺服器,但您必須設定 Orchestrator 功能以連接到新的伺服器。You can use standard Microsoft SQL Server methods to move the existing database to another server, but then you must configure the Orchestrator features to connect to the new server. 您必須針對 Management 伺服器、支援 Orchestration 主控台的 Web 服務及每部 Runbook 伺服器執行此項設定,如以下程序所述。You must perform this configuration for the management server, the web service supporting the Orchestration console, and each runbook server as described in the following procedures.

Management 伺服器和 Runbook 伺服器Management server and runbook servers

您可以使用資料庫設定公用程式來變更 Management 伺服器和 Runbook 伺服器安裝在環境中的連線設定。You can use the Database Configuration utility to change the connection settings that the management server and runbook servers installed in your environment. 這些伺服器的設定儲存在名為 Settings.dat的加密檔案中。The settings for these servers are stored in an encrypted file called Settings.dat. 如果您變更協調流程資料庫設定(例如埠、使用者帳戶存取權或電腦名稱稱),則必須手動卸載所有 runbook 伺服器並重新安裝,然後在 - management 伺服器和所有 runbook 伺服器上重新執行資料庫設定公用程式。If you change your orchestration database settings, such as the port, user account access, or computer name, you must manually uninstall and reinstall all runbook servers, and then re-run the Database Configuration utility on the management server and all runbook servers.

變更 Management 伺服器和 Runbook 伺服器的資料庫設定To change the database settings for the management server and runbook servers

  1. 在管理伺服器上,按一下 [開始],指向 [所有程式],依序按一下 [ **Microsoft System Center **]、[ Orchestrator],然後按一下 [資料存放區設定]。On the management server, click Start, point to All Programs, click Microsoft System Center , click Orchestrator, and then click Data Store Configuration.

  2. 在 [伺服器] 方塊中,輸入裝載資料庫的伺服器名稱** <server> \ > , <port> **方法是使用<實例的格式。In the Server box, enter the name of the server that is hosting the database by using the format <server>\<instance>,<port>. 您可以按一下** ( ) 省略號(...)** 按鈕來選取電腦。You can click the ellipsis (...) button to select the computer. 如果 Orchestrator 資料庫安裝在預設執行個體上,您不需要包含執行個體。You do not have to include the instance if the Orchestrator database is installed on the default instance. 如果 SQL Server 通常安裝在預設連接埠 1433 上,則不需要包含連接埠。You do not have to include the port if SQL Server is usually installed on the default port 1433.

    如果 Orchestrator 資料庫安裝在名為 MyInstance 的實例上,且該實例位於設定在埠12345上名為 MySQLServer 的電腦上,請輸入 MySQLServer \ MyInstance,12345If the Orchestrator database is installed on an instance called MyInstance on a computer named MySQLServer that is configured on port 12345, enter MySQLServer\MyInstance,12345.

    如果 Orchestrator 資料庫安裝在名為 MyInstance 的實例上,且該實例位於設定在埠1433上名為 MySQLServer 的電腦上,請輸入 MySQLServer \ MyInstanceIf the Orchestrator database is installed on an instance called MyInstance on a computer named MySQLServer that is configured on port 1433, enter MySQLServer\MyInstance.

    如果 Orchestrator 資料庫安裝在預設執行個體上,且該執行個體位於設定在連接埠 1433 上名為 MySQLServer 的電腦上,請輸入 MySQLServerIf the orchestration database is installed on the default instance on a computer named MySQLServer that is configured on port 1433, enter MySQLServer.

  3. 選取用來連線到 SQL Server 的驗證方法:Select the authentication method to use to connect to the SQL Server:

    • [Windows 驗證]**** Connect to the SQL Server by using .Windows Authentication Connect to the SQL Server by using Windows Authentication.

    • [SQL Server 驗證]**** :使用 SQL Server 使用者帳戶連線到 SQL Server。SQL Server Authentication Connect to the SQL Server by using a SQL Server user account. 輸入 SQL Server 使用者帳戶的 [使用者名稱] **** 和 [密碼] **** 。Type the User Name and Password of the SQL Server user account. 此帳戶必須具有建立、寫入和擁有資料庫,以及在資料庫中建立、更新和刪除資料列的權限。This account must have rights to create, write, and own a database and create, update, and delete rows in the database.

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

  5. 在 [資料存放區] **** 窗格中,按一下 [使用現有的資料庫] ****。In the Data Store pane, click Use an existing database.

  6. 在 [名稱] **** 清單中選取資料庫。In the Name list, select the database.

  7. 按一下 [完成] 。Click Finish.

Web 服務Web Service

支援 Orchestration 主控台的 Web 服務不會使用 Settings.dat 檔案。The web service supporting the Orchestration console does not use the Settings.dat file. 若要變更 web 服務的資料庫設定,您必須修改 Internet Information Services IIS 伺服器上的 Web.config 檔案 ( ) 。To change the database settings for the web service, you must modify the Web.config file on the Internet Information Services (IIS) server. 您可以使用 IIS 管理員 來修改檔案,但必須先藉由 _ 執行 aspnetregiis.exe 可執行檔來將它解密。You can use IIS Manager to modify the file, but you must first decrypt it by running the aspnet_regiis.exe executable file.

變更 Orchestrator web service 的資料庫設定To change the database settings for the Orchestrator web service

  1. 以系統管理認證登入已安裝 Orchestration 主控台的電腦。Log on with administrative credentials to the computer with the Orchestration console installed.

  2. 以系統管理認證開啟 [命令提示字元] 視窗。Open a Command Prompt window with administrator credentials.

  3. 執行下列命令將 Web.config 檔案解密:Run the following command to decrypt the Web.config file:

    C: \ Windows \ Microsoft.NET \ Framework \ v 4.0.30319 \ aspnet _regiis.exe - pdf "connectionStrings" "C: \ Program Files ( x86 ) \ Microsoft System Center \ Orchestrator \ Web Service \ Orchestrator "C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -pdf "connectionStrings" "C:\Program Files (x86)\Microsoft System Center \Orchestrator\Web Service\Orchestrator"

  4. 若要啟動 [IIS 管理員],請按一下 [ 開始],指向 [系統 管理工具],然後按一下 [ Internet Information Services ( IIS ) 管理員]。To start the IIS Manager, click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.

  5. 展開 [ 網站 ] 節點,然後按一下 [ Microsoft System Center Orchestrator Web Service]。Expand the Sites node, and then click Microsoft System Center Orchestrator Web Service.

  6. 在 [ 功能] 視圖中,按兩下 [ - 連接字串]。In the Features View, double-click Connection Strings.

  7. 在 [ 連接字串 ] 窗格中,按兩下 [ - orchestratorcoNtext]]。In the Connections String pane, double-click OrchestratorContext.

  8. 在 [ 自訂 ] 方塊中,向下卷到包含伺服器名稱 ( 資料來源 ) 和資料庫名稱 ( 初始目錄的字串部分 ) 。In the Custom box, scroll down to the portion of the string that includes the server name (Data Source) and database name (Initial Catalog). 請視需要修改這些值。Modify these values as required.

  9. 按一下 [確定] ,關閉對話方塊。Click OK to close the dialog box.

  10. 關閉 [ IIS 管理員]。Close IIS Manager.

  11. 執行下列命令將 Web.config 檔案加密:Run the following command to encrypt the Web.config file:

    C: \ Windows \ Microsoft.NET \ Framework \ v 4.0.30319 \ aspnet _regiis.exe - pef "connectionStrings" "C: \ Program Files ( x86 ) \ Microsoft System Center \ Orchestrator \ Web Service \ Orchestrator "C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -pef "connectionStrings" "C:\Program Files (x86)\Microsoft System Center \Orchestrator\Web Service\Orchestrator"

後續步驟Next steps

深入瞭解 資料庫大小和效能的最佳做法。Read more about best practices for database sizing and performance. 深入瞭解 Orchestrator 架構Get an overview of Orchestrator architecture.