設定實驗室環境以進行升級測試Set up a lab environment for upgrade testing

重要

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

若要進行升級測試,請使用下列程序,藉由建立實驗室環境並備妥以用於生產資料,來為 Service Manager 升級做好準備。Use the following procedures to prepare for Service Manager upgrade by creating a lab environment and preparing it for production data, for the purposes of upgrade testing.

本文中的許多程序很冗長,因此可能需要相當長的時間來完成。Many of the procedures in this article are lengthy and might take a considerable amount of time to complete. 只要依序完成這些程序即可,不需要全無間斷地一口氣完成。As long as you complete the procedures in order, you do not need to complete them without stopping.

在實驗室環境中還原 Service Manager 資料庫Restore the Service Manager database in the lab environment

請使用下列程序,透過 Microsoft SQL Server 2016 還原生產 Service Manager 資料庫。Use the following procedure to restore the production Service Manager database using Microsoft SQL Server 2016.

  1. 連線到適當的 Microsoft SQL Server 資料庫引擎執行個體之後,請在 [物件總管] 中,按一下伺服器名稱以展開伺服器樹狀目錄。After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
  2. 展開 [資料庫] ,根據資料庫選取使用者資料庫或展開 [系統資料庫] ,然後選取一個系統資料庫。Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database.
  3. 以滑鼠右鍵按一下資料庫,指向 [工作] ,然後按一下 [還原] 。Right-click the database, point to Tasks, and then click Restore. 隨即會顯示 [備份資料庫] 對話方塊。The Back Up Database dialog box appears.
  4. 按一下 [資料庫]****,隨即會開啟 [還原資料庫]**** 對話方塊Click Database, which opens the Restore Database dialog box
  5. 在 [一般] **** 頁面上,還原中資料庫的名稱會顯示在 [目的地資料庫]**** 清單方塊中。On the General page, the name of the restoring database appears in the To database list box. 若要建立新資料庫,請在清單方塊中輸入該資料庫的名稱。To create a new database, enter its name in the list box.
  6. 在 [至某個時間點]**** 文字方塊中,保留預設值 ([最近可能的]),或按一下 [瀏覽] 按鈕選取特定日期和時間,以開啟 [還原時間點]**** 對話方塊。In the To a point in time text box, either retain the default (Most recent possible) or select a specific date and time by clicking the browse button which opens the Point in Time Restore dialog box. 如需詳細資訊,請參閱如何:還原至某個時間點 (SQL Server Management Studio)For more information, see How to: Restore to a Point in Time (SQL Server Management Studio).
  7. 若要指定要還原備份組的來源和位置,請按一下 [來源資料庫]**** 或 [來源裝置]****。To specify the source and location of the backup sets to restore, click either From database or From device.
  8. [選取要還原的備份組] 方格中,選取要還原的備份。In the Select the backup sets to restore grid, select the backups to restore. 如需詳細資訊,請參閱還原資料庫 (一般頁面)For more information see Restore Database (General Page).
  9. 若要檢視或選取進階選項,請按一下 [選取頁面] 窗格中的 [選項]To view or select the advanced options, click Options in the Select a page pane.
  10. 在 [還原選項]**** 面板中,選擇下列其中一個最適合您情況的選項:In the Restore options panel, choose one of the following options most appropriate for your situation:
    • 覆寫現有的資料庫Overwrite the existing database

    • 保留複寫設定Preserve the replication settings

    • 還原每個備份之前先提示Prompt before restoring each backup

    • 限制對還原資料庫的存取Restrict access to the restored database

      如需詳細資訊,請參閱還原資料庫 (選項頁面)For more information, see Restore Database (Options Page)

  11. 或者,您可以為 [將資料庫檔案還原為]**** 中各個檔案指定新的還原目的地,將資料庫還原到新的位置。Optionally, you can restore the database to a new location by specifying a new restore destination for each file in Restore the database files as. 如需詳細資訊,請參閱還原資料庫 ( 選項頁面 ) For more information see Restore Database (Options Page).
  12. 在 [復原狀態]**** 面板中,選取下列其中一個最適合您環境的選項:In the Recovery state panel, select one of the following options most appropriate for your environment:
    • 回復未認可的交易,讓資料庫保持備妥可用。無法還原其他交易記錄。 (RESTORE WITH RECOVERY)Leave the database ready to use by rolling back the uncommitted transactions. Additional transaction logs cannot be restored. (RESTORE WITH RECOVERY)

      注意

      唯有您要在此時還原所有必要的備份時,才選擇此選項。Choose this option only if you are restoring all of the necessary backups at this time.

    • 讓資料庫保持不 - 運作,且不回復未認可的交易。您可以還原其他交易記錄。 (使用 NORECOVERY 還原)Leave the database non-operational, and do not roll back the uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH NORECOVERY)

    • 讓資料庫保持唯讀 - 模式。復原未認可的交易,但是將恢復動作儲存在待命檔案中,如此就可以還原復原效果。 (使用待命還原)Leave the database in read-only mode. Undo uncommitted transactions, but save the undo actions in a standby file so that recovery effects can be reverted. (RESTORE WITH STANDBY)

      如需詳細資訊,請參閱還原資料庫 ( 選項頁面 ) For more information see Restore Database (Options Page).

在實驗室環境中準備 Service Manager 資料庫Prepare the Service Manager database in the lab environment

請使用下列程序,在實驗室環境中準備 Service Manager 資料庫。Use the following procedure to prepare the Service Manager database in the lab environment. 請在次要管理伺服器 (實驗室環境中的管理伺服器) 用來裝載 Service Manager 資料庫的電腦上執行此程序。Perform this procedure on the computer that is hosting the Service Manager database that is being used by the secondary management server, the management server in your lab environment.

設定資料庫Configure the database

  1. 在裝載次要管理伺服器的 Service Manager 資料庫電腦上,依序按一下 [開始]****、[所有程式]****、[Microsoft SQL Server 2016]**** 及 [SQL Server Management Studio]****。On the computer hosting the Service Manager database for the secondary management server, click Start, click All Programs, click Microsoft SQL Server 2016, and then click SQL Server Management Studio.

  2. 在 [連線至伺服器] **** 對話方塊中,依照下列步驟進行::In the Connect to Server dialog box, follow these steps:

    1. 在 [ 伺服器類型 ] 清單中,選取 [ 資料庫引擎]。In the Server Type list, select Database Engine.
    2. 在 [伺服器名稱]**** 清單中,選取 Service Manager 或資料倉儲資料庫的伺服器名稱。In the Server Name list, select the server name for your Service Manager or data warehouse databases.
    3. 在 [驗證] 清單中,選取 [Windows 驗證] ,然後按一下 [連線] 。In the Authentication list, select Windows Authentication, and then click Connect.
  3. 展開 [ 物件總管 ] 窗格中的 [ 資料庫],然後按一下 [ ServiceManager]。In the Object Explorer pane, expand Databases, and then click ServiceManager.

  4. 按一下工具列中的 [新增查詢] ****。In the toolbar, click New Query.

  5. 在中央窗格中,輸入下列命令,然後按一下 [ 執行]。In the center pane, type the following commands, and then click Execute.

    sp_configure 'clr enabled', 1  
    go  
    reconfigure  
    go   
    
  6. 在中央窗格中,移除您在上一個步驟中鍵入的命令,鍵入下列命令,然後按一下 [執行]****。In the center pane, remove the commands you typed in the previous step, type the following commands, and then click Execute.

    ALTER DATABASE ServiceManager SET SINGLE_USER WITH ROLLBACK IMMEDIATE  
    
  7. 在中央窗格中,移除您在上一個步驟中鍵入的命令,鍵入下列命令,然後按一下 [執行]****。In the center pane, remove the commands you typed in the previous step, type the following commands, and then click Execute.

    ALTER DATABASE ServiceManager SET ENABLE_BROKER  
    
  8. 在中央窗格中,移除您在上一個步驟中鍵入的命令,鍵入下列命令,然後按一下 [執行]****。In the center pane, remove the commands you typed in the previous step, type the following commands, and then click Execute.

    ALTER DATABASE ServiceManager SET MULTI_USER  
    

設定服務帳戶Configure the service account

  1. 依序展開 [物件總管] **** 窗格中的 [安全性] **** 和 [登入] ****。In the Object Explorer pane, expand Security, and then expand Logins.
  2. 以滑鼠右鍵 - 按一下 [登入],然後按一下 [新增登 Logins入]Right-click Logins, and then click New Login
  3. 在 [登入 - 新增精靈]**** 中執行下列程序:Perform the following procedures in the Login - New wizard:
    1. 按一下 [搜尋]Click Search.

    2. 鍵入在實驗室環境中 Service Manager 資料庫所使用服務帳戶的使用者名稱 (domain\username),按一下 [檢查名稱]****,然後按一下 [確定]****。Type the username (domain\username) for the service account for Service Manager database in the lab environment, click Check Names, and then click OK.

      注意

      如果資料存取帳戶是以 LocalSystem 身分執行,請在 [ <domain\computername$> SQL 登入] 中使用格式,其中 <computername> 是管理伺服器的名稱。If the Data Access Account is running as LocalSystem, use the format <domain\computername$> in SQL Logins, where <computername> is the name of the management server.

    3. 在 [選取頁面] **** 窗格中按一下 [使用者對應] ****。In the Select a page pane, click User Mapping.

    4. 在 [已對應到此登入的使用者]**** 區域的 [對應]**** 欄中,按一下代表 Service Manager 資料庫名稱的那一列 (ServiceManager 是預設資料庫名稱)。In the Users mapped to this login area, in the Map column, click the row that represents the name of the Service Manager database (ServiceManager is the default database name).

    5. 在 [資料庫角色成員資格對象:ServiceManager]**** 區域中,確定已選取了下列項目:In the Database role membership for: ServiceManager area, make sure that the following entries are selected:

      • configsvc _ 使用者configsvc_users
      • 資料庫 _ accessadmindb_accessadmin
      • db _ datareaderdb_datareader
      • 資料庫 _ >datawriterdb_datawriter
      • 資料庫 _ >ddladmindb_ddladmin
      • 資料庫 _ securityadmindb_securityadmin
      • dbmodule _ 使用者dbmodule_users
      • publicpublic
      • sdk _ 使用者sdk_users
      • sql 相依性 _ _ 訂閱者sql_dependency_subscriber
    6. 按一下 [確定]。Click Ok

設定 Service Manager 資料表Configure Service Manager tables

  1. 展開 [物件總管]**** 窗格中的 [資料庫]****、[ServiceManager]**** 和 [資料表]****。In the Object Explorer pane, expand Databases, expand ServiceManager, and then expand Tables.

  2. 以滑鼠右鍵 - 按一下 [ dbo.MT _ Microsoft $ SystemCenter $ ManagementGroup],然後按一下 [ 編輯前 200個數據列]。Right-click dbo.MT_Microsoft$SystemCenter$ManagementGroup, and then click Edit Top 200 Rows.

  3. 在中央窗格中,找到 [SQLServerName_43FB076F_7970_4C86_6DCA_8BD541F45E3A]**** 欄。In the center pane, locate the column SQLServerName_43FB076F_7970_4C86_6DCA_8BD541F45E3A.

  4. 在此欄的第一列和第二列中,鍵入在實驗室環境中裝載 Service Manager 資料庫之電腦的電腦名稱。In the first row and second rows of this column, type the computer name of the computer hosting the Service Manager database in the lab environment. 若是具名執行個體,請鍵入電腦名稱\執行個體名稱。In the case of named instances, type computer name\instance name.

  5. 以滑鼠右鍵 - 按一下 [ dbo]。MT _ Microsoft $ SystemCenter $ ResourceAccessLayer $ SqlResourceStore,然後按一下 [ 編輯前 200個數據列]。Right-click dbo. MT_Microsoft$SystemCenter$ResourceAccessLayer$SqlResourceStore, and then click Edit Top 200 Rows.

  6. 在中央窗格中,找到 [Server_43FB076F_7970_4C86_6DCA_8BD541F45E3A]**** 欄。In the center pane, locate the column Server_43FB076F_7970_4C86_6DCA_8BD541F45E3A.

  7. 在此欄的第一列中,鍵入在實驗室環境中裝載 Service Manager 資料庫 SQL Server 之電腦的電腦名稱。In the first row of this column, type the computer name of the computer hosting the SQL Server for the Service Manager database in the lab environment. 若是具名執行個體,請鍵入電腦名稱\執行個體名稱。In the case of named instances, type computer name\instance name.

  8. 以滑鼠右鍵 - 按一下 [ LFX]。[資料來源],然後按一下 [ 編輯前 200個數據列]。Right-click LFX.DataSource, and then click Edit Top 200 Rows.

  9. 在中央窗格中,找到 [DataSourceAddress]**** 欄。In the center pane, locate the column DataSourceAddress.

  10. 在此資料行的第一個資料列中,找出以 資料來源開頭的專案 = <server name> ;初始目錄 = ServiceManager;保存安全性資訊 = FalseIn the first row of this column, locate the entry that starts with Data Source = <server name>; Initial Catalog = ServiceManager; Persist Security Info=False. 在實驗室環境中輸入主控 SQL Server 的電腦名稱稱,以取代 <server name>Type the name of the computer hosting SQL Server in the lab environment in place of <server name>.

  11. 以滑鼠右鍵 - 按一下 [ dbo]。MT _ Microsoft $ SystemCenter $ ResourceAccessLayer $ SdkResourceStore,然後按一下 [ 編輯前 200個數據列]。Right-click dbo. MT_Microsoft$SystemCenter$ResourceAccessLayer$SdkResourceStore, and then click Edit Top 200 Rows.

  12. 在中央窗格中,找到 [Server_48B308F9_CF0E_0F74_83E1_0AEB1B58E2FA]**** 欄。In the center pane, locate the column Server_48B308F9_CF0E_0F74_83E1_0AEB1B58E2FA.

  13. 在此欄的所有列中,鍵入在實驗室環境中裝載 Service Manager 管理伺服器之電腦的名稱。In all of the rows in this column, type the name of the computer hosting the Service Manager management server in the lab environment.

  14. 以滑鼠右鍵 - 按一下 [   ** [ dbo] ] 。 [MT _ Microsoft $ SystemCenter $ ResourceAccessLayer $ CmdbResourceStore ] **,然後按一下 [   編輯前 200個數據列]。Right-click [dbo].[MT_Microsoft$SystemCenter$ResourceAccessLayer$CmdbResourceStore], and then click Edit Top 200 Rows.

  15. 在所有列中,更新 [Server_48B308F9_CF0E_0F74_83E1_0AEB1B58E2FA]**** 欄,然後鍵入在實驗室環境中裝載 Service Manager 資料庫之 SQL 電腦的名稱In all rows update the column Server_48B308F9_CF0E_0F74_83E1_0AEB1B58E2FA, type the name of the SQL computer hosting the Service Manager database in the lab environment

  16. 按一下工具列中的 [新增查詢] ****。In the toolbar, click New Query.

  17. 在中央窗格中,鍵入下列命令,然後按一下 [執行]****。In the center pane, type the following command, and then click Execute.

    Delete from dbo.MT_Microsoft$SystemCenter$ResourceAccessLayer$DwSdkResourceStore  
    
  18. 關閉 Microsoft SQL Server Management StudioClose Microsoft SQL Server Management Studio.

設定實驗室的 Service Manager 管理伺服器Configure the lab Service Manager management server

  • 使用登錄編輯程式,展開下列路徑並更新 DatabaseServerNameUsing Registry Editor, expand the following path and update DatabaseServerName :

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\System Center\2010\Common\DatabaseHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\System Center\2010\Common\Database

在實驗室環境中編輯 Service Manager 管理伺服器上的登錄Edit the registry on the Service Manager Management Server in the lab environment

請使用下列程序,在實驗室環境中編輯 Service Manager 管理伺服器上的登錄。Use the following procedure to edit the registry on the Service Manager management server in the lab environment.

警告

不正確編輯的登錄可能會嚴重損害您的系統;因此,在變更登錄前,請先備份電腦上的所有重要資料。Incorrectly editing the registry might severely damage your system; therefore, before making changes to the registry, back up any valued data on the computer.

編輯登錄Edit the registry

  1. 在實驗室環境中裝載 Service Manager 管理伺服器的電腦上,以具有系統管理認證的使用者身分登入電腦。On the computer hosting the Service Manager management server in the lab environment, log on to the computer as a user with administrative credentials.
  2. 在 Windows 桌面上,按一下 [開始] ****,然後按一下 [執行] ****。On the Windows desktop, click Start, and then click Run.
  3. 在 [執行] **** 對話方塊的 [開啟] **** 方塊中,輸入 regedit,然後按一下 [確定] ****。In the Run dialog box, in the Open box, type regedit, and then click OK.
  4. 在 [登錄編輯程式] 視窗中,展開 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\System Center\2012\Common\Database]****。In the Registry Editor window, expand HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\System Center\2012\Common\Database.
  5. 按兩下右窗格中的 [DatabaseServerName] ****。In the right pane, double-click DatabaseServerName.
  6. 在 [編輯字串]**** 方塊的 [數值資料]**** 方塊中,鍵入在實驗室環境中裝載 Service Manager 資料庫 SQL Server 之電腦的名稱。In the Edit String box, in the Value data box, type the name of the computer hosting the Service Manager database SQL Server in the lab environment. 如果您使用的是 SQL Server 的具名執行個體,請使用 Computer Name\Instance name 格式。If you are using a named instance of SQL Server, use the Computer Name\Instance name format.
  7. 按一下 [確定]****,然後關閉登錄編輯程式。Click OK, and then close the Registry Editor.

在次要管理伺服器上啟動 Service Manager 服務Start Service Manager services on the secondary management server

請使用下列程序啟動 Service Manager 服務。Use the following procedure to start the Service Manager services.

啟動 Service Manager 服務To start Service Manager services

  1. 在 Windows 桌面上,按一下 [開始] ****,然後按一下 [執行] ****。On the Windows desktop, click Start, and then click Run.
  2. 在 [執行]**** 對話方塊的 [開啟]**** 欄位中,鍵入 services.msc,然後按一下 [確定]****。In the Run dialog box, in the Open field, type services.msc, and then click OK.
  3. 在 [服務] 視窗的 [**服務 ( 本機 ) ** ] 窗格中,找到下列三項服務,並且針對每個服務按一下 [**啟動**]:In the Services window, in the Services (Local) pane, locate the following three services and for each one, click Start:
    • System Center 資料存取服務System Center Data Access Service
    • System Center 管理System Center Management
    • System Center 管理設定System Center Management Configuration

在實驗室環境中升階次要管理伺服器Promote a secondary management server in a lab environment

請使用下列程序提升次要管理伺服器。Use the following procedure to promote the secondary management server.

  1. 在次要管理伺服器上,執行下列步驟:On the secondary management server, do the following:
    1. 關閉 Service Manager 主控台。Close the Service Manager console.
    2. 在 Windows 桌面上,按一下 [開始] ****,然後按一下 [執行] ****。On the Windows desktop, click Start, and then click Run.
    3. 在 [執行] **** 對話方塊的 [開啟] **** 文字欄位中,輸入 services.msc,然後按一下 [確定] ****。In the Run dialog box, in the Open text field, type services.msc, and then click OK.
    4. 在 [服務] 視窗的 [**服務 ( 本機 ) ** ] 窗格中,找到下列三項服務,並針對每個服務按一下 [**停止**]:In the Services window, in the Services (Local) pane, locate the following three services and for each one, click Stop:
      • System Center 資料存取服務System Center Data Access Service
      • System Center 管理System Center Management
      • System Center 管理設定System Center Management Configuration
    5. 保持開啟 [服務]**** 視窗。Leave the Services window open.
    6. 開啟 [Windows 檔案總管]。Open Windows Explorer. 找到 [\Program Files\Microsoft System Center\Service Manager] 資料夾。Locate the \Program Files\Microsoft System Center\Service Manager folder.
    7. 刪除此資料夾中的 [Health Service State] 資料夾及其中所有內容。In this folder, delete the Health Service State folder and all of its contents.
  2. 在 Test SQL Server 執行個體的 ServiceManager 資料庫上,執行下列步驟:Do the following on the ServiceManager database on the Test SQL Server instance:
    1. 在 Windows 桌面上,按一下 [開始]****,指向 [程式集]****,指向 [Microsoft SQL Server 2016]****,然後按一下 [SQL Server Management Studio]****。On the Windows desktop, click Start, point to Programs, point to Microsoft SQL Server 2016, and then click SQL Server Management Studio.
    2. 在 [連接到 Database Engine] 對話方塊中,依照下列步驟進行:In the Connect to Database Engine dialog box, follow these steps:
      1. 在 [伺服器名稱]**** 方塊中,鍵入裝載 ServiceManager 資料庫之伺服器的名稱。In the Server name box, type the name of the server that hosts the ServiceManager database.
      2. 選取 [驗證] 方塊中的 [Windows 驗證]。In the Authentication box, select Windows Authentication.
      3. 按一下 [ 連接]。Click Connect.
    3. 展開 [ 物件總管 ] 窗格中的 [ 資料庫],然後按一下 [ ServiceManager]。In the Object Explorer pane, expand Databases, and then click ServiceManager.
    4. 在工具列上,按一下 [新增查詢]On the toolbar, click New Query.
    5. 在 [ SQLQuery1 ] 窗格 ( 中央窗格中 ) ,輸入下列內容,其中 <FQDN of your server> 是您要升級的管理伺服器的 FQDN:In the SQLQuery1.sql pane (center pane), type the following, where <FQDN of your server> is the FQDN of the management server that you are promoting:
      EXEC p _ PromoteActiveWorkflowServer ' <FQDN of your server> 'EXEC p_PromoteActiveWorkflowServer '<FQDN of your server>'
      在工具列上按一下 [執行] ****。On the toolbar, click Execute.
    6. 留意 [SQLQuery1.sql]**** 窗格 (中央窗格) 的底部是否顯示 [已成功執行查詢]****。At the bottom of the SQLQuery1.sql pane (center pane), observe that Query executed successfully is displayed.
    7. 結束 Microsoft SQL Server Management Studio。Exit Microsoft SQL Server Management Studio.
  3. 在次要管理伺服器上,執行下列步驟:Do the following on the secondary management server:
    1. 在 Windows 桌面上,按一下 [開始] ****,然後按一下 [執行] ****。On the Windows desktop, click Start, and then click Run.
    2. 在 [執行]**** 對話方塊的 [開啟]**** 欄位中,鍵入 services.msc,然後按一下 [確定]****。In the Run dialog box, in the Open field, type services.msc, and then click OK.
    3. 在 [服務] 視窗的 [**服務 ( 本機 ) ** ] 窗格中,找到下列三項服務,然後按一下 [**啟動**]。In the Services window, in the Services (Local) pane, locate the following three services and for each one, click Start.
      • System Center 資料存取服務System Center Data Access Service
      • System Center 管理System Center Management
      • System Center 管理設定System Center Management Configuration

現在,您的次要管理伺服器即為管理群組的主要管理伺服器。Your secondary management server is now the primary management server for the management group.

在實驗室環境中啟用連接器Enable the connectors in the lab environment

請使用下列程序,在實驗室環境中啟用 Service Manager 連接器。Use the following procedure to enable the Service Manager connectors in the lab environment. 在此程序中,您無法啟用 Operations Manager 連接器。In this procedure, you will not be enabling the Operations Manager connector.

警告

請勿在實驗室環境中啟用或刪除 Operations Manager 警示連接器,Do not enable or delete the Operations Manager alert connector in the lab environment. 這麼做將會使生產環境中的警示連接器失敗。Doing so will cause the alert connector in the production environment to fail.

啟用連接器Enable a connector

  1. 在 Service Manager 主控台中,按一下 [系統管理]****。In the Service Manager console, click Administration.
  2. 展開 [ 系統管理 ] 窗格中的 [ 系統管理],然後按一下 [ 連接器]。In the Administration pane, expand Administration, and then click Connectors.
  3. 在 [連接器]**** 窗格中,選取您要啟用的連接器。In the Connectors pane, select the connector that you want to enable.
  4. 在 [工作]**** 窗格的連接器名稱下方,按一下 [啟用]****。In the Tasks pane, under the connector name, click Enable.

在實驗室環境中安裝新的資料倉儲伺服器Install a new data warehouse server in the lab environment

請使用下列程序,在實驗室環境中安裝新的資料倉儲伺服器。Use the following procedure to install a new data warehouse server in the lab environment.

安裝資料倉儲管理伺服器與資料倉儲資料庫Install a data warehouse management server and data warehouse databases

  1. 使用具有系統管理權限的帳戶登入電腦。Log on to the computer by using an account that has administrative rights.

  2. 在 Service Manager 安裝媒體上,按兩下 Setup.exe 檔案。On the Service Manager installation media, double-click the Setup.exe file.

  3. 按一下 [Microsoft System Center Service Manager 2016]**** 頁面上的 [安裝 Service Manager 資料倉儲管理伺服器]****。On the Microsoft System Center Service Manager 2016 page, click Install a Service Manager data warehouse management server.

  4. 在 [ 產品註冊 ] 頁面的方塊中,輸入資訊。On the Product registration page, type information in the boxes. 在 [產品金鑰]**** 方塊中,鍵入隨同 Service Manager 收到的產品金鑰,或者選取 [安裝成評估版 (試用 180 天)?]****。In the Product key boxes, type the product key you received with Service Manager, or alternatively, select Install as an evaluation edition (180 day trial)?. 閱讀 Microsoft 軟體授權條款,並且如果適用的話,按一下 [ 我已經閱讀、瞭解並同意授權合約的條款],然後按一下 [ 下一步]。Read the Microsoft Software License Terms, and, if applicable, click I have read, understood, and agree with the terms of the license agreement, and then click Next.

  5. 在 [ 安裝位置 ] 頁面上,確認有足夠的磁碟空間可用,然後按 [ 下一步]。On the Installation location page, verify that sufficient free disk space is available, and then click Next. 如有需要,請按一下 [瀏覽]**** 以變更要安裝 Service Manager 資料倉儲管理伺服器的位置。If necessary, click Browse to change the location in which the Service Manager data warehouse management server will be installed.

  6. 在 [ 系統檢查結果 ] 頁面上,確認必要條件是否已通過,或至少已通過但出現警告,然後按一下 [ 下一步]。On the System check results page, make sure that prerequisites passed or at least passed with warnings, and then click Next.

  7. 在 [設定資料倉儲資料庫]**** 頁面上,Service Manager 會檢查您正在使用的電腦是否可裝載資料倉儲資料庫。On the Configure data warehouse databases page, Service Manager checks the computer you are using to see if it can host the data warehouse databases. 在此設定中,請確認資料庫伺服器是否為將安裝資料倉儲管理伺服器的電腦,然後按一下 [ 下一步]。For this configuration, confirm that the database server is the computer on which you are installing the data warehouse management server, and then click Next.

    警告

    如果您使用的是預設定序 (SQL_Latin1_General_CP1_CI_AS),則會出現警告訊息。A warning message appears if you are using the default collation (SQL_Latin1_General_CP1_CI_AS). 使用預設定序時,Service Manager 將無法支援多種語言。Support for multiple languages in Service Manager is not possible when you are using the default collation. 如果您稍後決定使用不同的定序來支援多種語言,則必須重新安裝 SQL Server。If later you decide to support multiple languages using a different collation, you have to re-install SQL Server.

  8. 在 [設定資料倉儲管理群組]**** 頁面上,遵循下列步驟進行:On the Configure the data warehouse management group page, follow these steps:

    1. 在 [ 管理群組名稱 ] 方塊中,輸入群組的唯一名稱。In the Management group name box, type a unique name for the group.

      警告

      管理群組名稱必須是唯一的。Management group names must be unique. 當您部署 Service Manager 管理伺服器與 Service Manager 資料倉儲管理伺服器時,請勿使用相同的管理群組名稱。Do not use the same management group name when you deploy a Service Manager management server and a Service Manager data warehouse management server. 另外,也請勿使用 Operations Manager 所使用的管理群組名稱。Furthermore, do not use the management group name that is used for Operations Manager.

    2. 按一下 [瀏覽]****,輸入要授與 Service Manager 系統管理權限的使用者帳戶或群組,然後按一下 [下一步]****。Click Browse, enter the user account or group to which you want to give Service Manager administrative rights, and then click Next.

  9. 如果有 SQL Server Reporting Services,則 Service Manager 會使用現有的電腦。Service Manager will use the existing computer if SQL Server Reporting Services is present. 在 [設定資料倉儲的報表伺服器]**** 頁面上,接受預設值,然後按一下 [下一步]****。On the Configure the reporting server for the data warehouse page, accept the defaults, and then click Next.

  10. 在 [ 設定 Service Manager 服務的帳戶 ] 頁面上,按一下 [ 網域帳戶],指定帳戶的使用者名稱、密碼和網域,然後按一下 [ 測試認證]。On the Configure the account for Service Manager services page, click Domain account, specify the user name, password, and domain for the account, and then click Test Credentials. 在您收到 [接受認證 ] 訊息後,按 [下一步]After you receive a The credentials were accepted message, click Next.

  11. 在 [ 設定報表帳戶 ] 頁面上,指定帳戶的使用者名稱、密碼和網域,然後按一下 [ 測試認證]。On the Configure the reporting account page, specify the user name, password, and domain for the account, and then click Test Credentials. 在您收到 [接受認證 ] 訊息後,按 [下一步]After you receive a The credentials were accepted message, click Next.

  12. 在 [診斷與使用方式資料]**** 頁面上,表示您是否有意願與 Microsoft 共用 Service Manager 診斷與使用方式資料。On the Diagnostic and usage data page, indicate your preference for sharing your Service Manager diagnostic and usage data with Microsoft. 您可以選擇按一下 [System Center Service Manager 隱私權聲明]****,然後按一下 [下一步]****。As an option, click Privacy statement for System Center Service Manager, and then click Next.

  13. 在 [ **使用 Microsoft Update 協助您的電腦保持在安全和 - 最 - ** 新的狀態] 頁面上,指定您使用 Microsoft Update 檢查 Service Manager 更新的喜好設定,然後按 [下一步]On the Use Microsoft Update to help keep your computer secure and up-to-date page, indicate your preference for using Microsoft Update to check for Service Manager updates, and then click Next.

  14. 按一下 [ 安裝摘要 ] 頁面上的 [ 安裝]。On the Installation summary page, click Install.

驗證資料倉儲管理伺服器的安裝Validate a data warehouse management server installation

  1. 在裝載資料倉儲管理伺服器的電腦 (您執行安裝程式的伺服器) 上,執行 services.msc,並確認是否已安裝下列服務:On the computer hosting the data warehouse management server (the server you ran Setup on), run services.msc, and verify that the following services have been installed:
    • System Center 資料存取服務System Center Data Access Service
    • System Center 管理System Center Management
    • System Center 管理設定System Center Management configuration
  2. 在裝載資料倉儲資料庫的電腦上,按一下 [開始]****,依序指向 [程式集]**** 與 [Microsoft SQL Server]****,然後按一下 [SQL Server Management Studio]****。On the computer hosting the data warehouse databases, click Start, point to Programs, point to Microsoft SQL Server, and then click SQL Server Management Studio.
  3. 在 [連線至伺服器]**** 對話方塊中,選取下列項目:In the Connect to Server dialog box, select the following:
    1. 在 [ 伺服器類型 ] 清單中,選取 [ 資料庫引擎]。In the Server Type list, select Database Engine.
    2. 在 [伺服器名稱] 清單中,選取 Service Manager 資料倉儲資料庫的伺服器和執行個體。In the Server Name list, select the server and instance for your Service Manager data warehouse database. 例如選取 [電腦 4]****。For example, select Computer 4.
    3. 在 [驗證] 清單中,選取 [Windows 驗證] ,然後按一下 [連線] 。In the Authentication list, select Windows Authentication, and then click Connect.
  4. 在 [物件總管] **** 窗格中,展開 [資料庫] ****。In the Object Explorer pane, expand Databases.
  5. 確認是否列出 DWDataMartDWRepositoryDWStagingAndConfig 資料庫。Verify that the DWDataMart, DWRepository, and DWStagingAndConfig databases are listed.

在實驗室環境中登錄資料倉儲伺服器Register the data warehouse server in the lab environment

請使用下列程序,在實驗室 Service Manager 環境中登錄新安裝的資料倉儲伺服器。Use the following procedure to register the newly installed data warehouse server with the lab Service Manager environment.

登錄資料倉儲Register a data warehouse

  1. 登入裝載 Service Manager 主控台的電腦。Log on to the computer that hosts the Service Manager console. 使用 Service Manager 和資料倉儲管理系統管理員群組成員的帳戶。Use an account that is a member of the Service Manager and data warehouse management administrators group.

  2. 在 Service Manager 主控台中,按一下 [系統管理]****。In the Service Manager console, click Administration.

  3. 在 [系統管理] **** 窗格中展開 [系統管理] ****。In the Administration pane, expand Administration.

  4. 在 [系統 管理 ] 視圖的 [ 使用 Service Manager 的資料倉儲註冊 ] 區域中,按一下 [ 向 Service Manager 資料倉儲註冊]。In the Administration view, in the Register with Service Manager's Data Warehouse area, click Register with Service Manager Data Warehouse.

  5. 在資料倉儲登錄精靈的 [開始之前] **** 頁面上,按 [下一步] ****。In the Data Warehouse Registration wizard, on the Before You Begin page, click Next.

  6. 在 [資料倉儲]**** 頁面的 [伺服器名稱]**** 方塊中,鍵入裝載資料倉儲管理伺服器的電腦完整網域名稱,然後按一下 [測試連線]****。On the Data Warehouse page, in the Server name box, type the fully qualified domain name of the computer hosting the data warehouse management server, and then click Test Connection. 如果測試不成功,請按 [下一步] ****。If the test is successful, click Next.

  7. 在 [認證] **** 頁面上,您可以接受 [執行身分帳戶] **** 清單中的預設項目,然後按 [下一步] ****,或是輸入您自己選擇之使用者或群組的認證。On the Credentials page, you can accept the default entry in the Run as account list, and then click Next, or you can enter credentials from a user or group of your own choosing.

    重要

    您所指定的帳戶將在 Service Manager 管理伺服器上獲得系統管理認證的指派,並在 Service Manager 資料庫上取得讀取權限。The account you specify will be assigned administrative credentials on the Service Manager management server and granted Read permission on the Service Manager database. 向資料倉儲進行登錄時,您可以指定來自其他 Service Manager 管理伺服器的不同認證。You can specify different credentials from other Service Manager management groups when registering with the data warehouse.

  8. 在 [摘要] **** 頁面上,按一下 [建立] ****。On the Summary page, click Create.

  9. 在 [完成]**** 頁面上,當顯示 [資料倉儲登錄成功]**** 時,按一下 [關閉]****。On the Completion page, when The data warehouse registration succeeded is displayed, click Close.

  10. 畫面上會出現對話方塊,說明報表部署程序尚未完成。A dialog box states that the report deployment process has not finished. 這是預期的行為。This is to be expected. 請在 [System Center Service Manager] **** 對話方塊中,按一下 [確定] ****。On the System Center Service Manager dialog box, click OK.

  11. 幾分鐘後,在關閉 [資料倉儲登錄精靈] 之後,[資料倉儲]**** 按鈕便會新增至 Service Manager 主控台。In a few minutes, after closing the Data Warehouse Registration wizard, the Data Warehouse button will be added to the Service Manager console. 在 Service Manager 主控台中,按一下 Service Manager 主控台按鈕右下角的箭號,然後按一下 [顯示更多按鈕]****。In the Service Manager console, click the arrow at the lower right corner of the Service Manager console buttons, and then click Show More Buttons.

    您可以使用 Windows PowerShell 命令來完成此項工作。You can use a Windows PowerShell command to complete this task. 如需如何使用 Windows PowerShell 向資料倉儲登錄 Service Manager 管理群組的資訊,請參閱 Add-SCDWMgmtGroupFor information about how to use Windows PowerShell to register Service Manager management groups with the data warehouse, see Add-SCDWMgmtGroup.

驗證登錄Validate the registration

  1. 在裝載資料倉儲管理伺服器的電腦上,使用系統管理認證啟動 Windows PowerShell。On the computer hosting the data warehouse management server, start Windows PowerShell with administrative credentials.

  2. 當出現 Windows PowerShell 命令提示字元時鍵入下列命令,然後按下 Enter:At the Windows PowerShell command prompt, type the following commands, and then press ENTER:

    Set-ExecutionPolicy RemoteSigned  
    Import-Module .\Microsoft.EnterpriseManagement.Warehouse.Cmdlets.psd1  
    
    
  3. 輸入下列命令,然後按 ENTER 鍵。Type the following command, and then press ENTER.

    Get-SCDWMgmtGroup  
    
    
  4. 如果登錄成功,畫面上會顯示內含兩列資料的表格;If registration was successful, a table with two rows of data is displayed. 其中一列顯示資料倉儲管理群組的資料,另一列則顯示 Service Manager 管理群組的資料。One row displays data for the data warehouse management group, and a second row displays data for the Service Manager management group. 如果登錄失敗,畫面上只會顯示資料倉儲管理群組的資料。If registration fails, only the data for the data warehouse management group is displayed.

判斷部署完成的時間Determine when the deployment is complete

您需要給予足夠的時間來完成管理組件部署程序,因此必須判斷該程序完成的時間。Because you need to allow enough time for the management pack deployment process to be completed, you will have to determine when that process is complete. 您可以在 Service Manager 中使用下列程序,判斷此程序完成的時間。You can use the following procedure in Service Manager to determine when the process is complete.

判斷管理組件部署完成的時間To determine when management pack deployment has completed

  1. 啟動 Service Manager 主控台。Start the Service Manager console.

  2. 在 Service Manager 主控台中,按一下 [資料倉儲]****。In the Service Manager console, click Data Warehouse.

  3. 展開 [資料倉儲] **** 窗格中的 [資料倉儲] ****,然後按一下 [資料倉儲作業] ****。In the Data Warehouse pane, expand Data Warehouse, and then click Data Warehouse Jobs.

  4. 在 [資料倉儲作業]**** 窗格中,按一下 [MPSyncJob]****。In the Data Warehouse Jobs pane, click MPSyncJob.

  5. 在 [工作]**** 窗格的 [同步處理]**** 底下,按一下 [詳細資料]****。In the Tasks pane, under Synchronization, click Details.

  6. 在 [管理組件 (MP) 同步處理作業]**** 對話方塊中,捲動到右邊並查看 [狀態]**** 欄。In the MP Sync Job dialog box, scroll to the right and examine the Status column.

    注意

    在 [管理組件 (MP) 同步處理作業]**** 對話方塊中,按一下 [狀態]**** 以便依字母順序排序 [狀態] 欄。In the MP Sync Job dialog box, click Status to alphabetically sort the status column.

  7. 捲動 [狀態]**** 清單。Scroll through the Status list. 當所有管理組件的 [狀態] 欄都已列出 [已關聯]**** 或 [已匯入]**** 時,表示管理組件部署程序已完成。The management pack deployment process is complete when Associated or Imported is listed in the status column for all of the management packs. 請確定 [狀態] 清單中沒有 [擱置關聯]**** 或 [失敗]**** 的狀態。Make sure that there is no status of either Pending Association or Failed in the status list. 在 [資料倉儲作業]**** 窗格中,[MPSyncJob]**** 的狀態已從 [執行中]**** 變更為 [未啟動]****。In the Data Warehouse Jobs pane, the status of the MPSyncJob will have changed from Running to Not Started. 這個管理組件部署程序最多可能需要兩個小時才能完成。This deployment process can take up to two hours to complete.

  8. 若要重新整理 [管理組件 (MP) 同步處理作業]**** 對話方塊:To refresh the MP Sync Job dialog box:

    1. 按 [確定]**** 關閉對話方塊。Press OK to close the dialog box.
    2. 在 [工作]**** 窗格的 [資料倉儲作業]**** 區域中,按一下 [重新整理]****。In the Tasks pane, in the Data Warehouse Jobs area, click Refresh.
    3. 在 [資料倉儲作業]**** 窗格中,按一下 [MPSyncJobs]****。In the Data Warehouse Jobs pane, click MPSyncJobs.
    4. 在 [工作]**** 窗格的 [同步處理]**** 底下,按一下 [詳細資料]****。In the Tasks pane, under Synchronization, click Details.
  9. 在管理組件部署完成之後 (按照步驟 7 判斷),確定 [資料倉儲作業]**** 窗格中是否顯示下列 5 個資料倉儲作業:After the management packs have been deployed (as determined in step 7), make sure that the following 5 data warehouse jobs are displayed in the Data Warehouse Jobs pane:

    • 提取_<Service Manager management group name>Extract_<Service Manager management group name>
    • 提取_<data warehouse management group name>Extract_<data warehouse management group name>
    • Load.CommonLoad.Common
    • Transform.CommonTransform.Common
    • MPSyncJobMPSyncJob
  10. 如果沒有顯示這 5 個資料倉儲作業,請執行下列程序:If these 5 data warehouse jobs are not displayed, perform the following procedure:

    1. 在 [資料倉儲作業]**** 窗格中,按一下 [MPSyncJob]****。In the Data Warehouse Jobs pane, click MPSyncJob.
    2. 在 [工作]**** 窗格的 [同步處理]**** 底下,按一下 [繼續]****。In the Tasks pane, under Synchronization, click Resume.
    3. 執行前述步驟 4,評估管理組件部署是否已完成。Assess if management pack deployment has completed by returning to step 4 above.

後續步驟Next steps