在 Service Manager 中管理執行身分帳戶Manage Run As accounts in Service Manager

重要

此版本的 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 的設定期間,您已指定工作流程和服務帳戶的認證、Microsoft SQL Server Analysis Services 以及 SQL Server Reporting Services (SSRS) 。During the setup of Service Manager, you specified credentials for the workflow and service accounts, for Microsoft SQL Server Analysis Services, and for SQL Server Reporting Services (SSRS). 如果您的組織中使用密碼安全性需求的設定,則這些密碼會過期,您必須在 Service Manager 中更新新的密碼。If, because of the configurations of password security requirements used in your organization, these passwords expire, you must update the new passwords in Service Manager. 此外,如果您決定使用者名稱必須變更,您也必須在 Service Manager 中加以變更。In addition, if you decide that the user names must change, you also must change them in Service Manager. 本節說明如何進行這些變更。This section describes how to make those changes.

最佳做法是不要從 Service Manager 主控台刪除「執行身份」帳戶。It is a best practice never to delete Run As accounts from the Service Manager console. Service Manager 管理套件會監視執行身份帳戶。The Service Manager management pack monitors Run As accounts. 健全狀況服務會定期嘗試以執行身分帳戶的身分進行登入。At regular intervals, the Health service attempts to log on as the Run As accounts. 如果登入失敗,便會叫用事件識別碼 7000 並產生警示。If this fails, Event ID 7000 is invoked that causes an alert. 避免此問題的最佳方式,就是永遠不會從 Service Manager 主控台刪除「執行身份」帳戶。The best way to avoid this issue is never to delete Run As accounts from the Service Manager console. 您可以變更帳戶的名稱或認證,以重複使用現有的執行身分帳戶。You can reuse existing Run As accounts by changing their name or credentials. 如果您想要停止使用執行身分帳戶,您可以將它的認證變更為 [本機系統],並將名稱變更為容易記住的名稱,例如 [ 使用中]。If you want to stop using a Run As account, you can change its credentials to Local System and change the name to something easy to remember, such as Inactive.

變更 Service Manager 所使用運算元據庫帳戶的使用者認證Change the user credentials for the Operational Database account used by Service Manager

如果 Service Manager 中運算元據庫帳戶的使用者帳戶變更,您必須進行下列變更:If the user account for the Operational Database Account in Service Manager changes, you must make the following changes:

  1. 將新帳戶新增至 Service Manager 和資料倉儲管理伺服器的 Service Manager 系統管理員使用者角色Add the new account to the Service Manager Administrators user role for both the Service Manager and data warehouse management servers

  2. 在主控 Service Manager 資料庫的電腦上,為新的使用者建立 SQL Server 登入帳戶。Create a SQL Server logon account for the new user on computers hosting Service Manager databases. 在主控 Service Manager 資料庫的電腦上,將新的使用者指派給 skd_users 和 configsvc_users 角色。On the computer hosting the Service Manager database, assign the new user to the skd_users and configsvc_users roles.

  3. 將新的帳戶設為 Service Manager 電腦上的本機系統管理員。Make the new account a local administrator on the Service Manager computers.

  4. 讓新的使用者帳戶成為 Service Manager 資料存取服務和 Service Manager 管理設定服務的登入帳戶,然後重新開機這些服務。Make the new user account the logon account for the Service Manager Data Access Service and Service Manager Management Configuration services, and then restart these services.

    注意

    Service Manager 管理服務的登入帳戶一律是本機系統帳戶,而且不得變更。The logon account for the Service Manager Management service is always the local system account and must not be changed.

  5. 重新開機 Service Manager 管理服務。Restart the Service Manager Management service.

  6. 讓新使用者成為操作執行帳戶。Make the new user the Operational Run As account.

使用下列程式,在 Service Manager 中進行這些變更。Use the following procedures to make these changes in Service Manager.

重要

請勿將運算元據庫帳戶設定為使用 Network Service 帳戶。Do not configure the Operational Database Account to use the Network Service account.

將使用者新增至本機系統管理員帳戶To add the user to the local administrators account

  1. 請在裝載下列項目的電腦上,將新的使用者新增為 Windows 系統管理員本機群組的成員:Add the new user as a member of the Administrators local group in Windows on the computers hosting the following:
    • Service Manager 管理伺服器Service Manager management server
    • 資料倉儲管理伺服器Data warehouse management server
    • 自助入口網站Self-Service Portal
    • Service Manager 資料庫Service Manager database
    • 資料倉儲資料庫Data warehouse databases

將使用者新增至系統管理員使用者角色To add the user to the Administrators user role

  1. 在 Service Manager 主控台中,按一下 [系統管理]****。In the Service Manager console, click Administration.
  2. 在 [系統 管理 ] 窗格中,展開 [ 管理],展開 [ 安全性],然後按一下 [ 使用者角色]。In the Administration pane, expand Administration, expand Security, and then click User Roles.
  3. 在 [ 使用者角色 ] 窗格中,按一下 [系統 管理員]。In the User Roles pane, click Administrators.
  4. 在 [工作] **** 窗格中,按一下 [屬性] ****。In the Tasks pane, click Properties.
  5. 在 [編輯使用者角色] 嚮導中,按一下 [ 使用者]。In the Edit User Role Wizard, click Users.
  6. 按一下 [ 移除 ] 移除現有的認證, 按一下 [新增 ] 並新增認證,然後按一下 [確定]Click Remove to remove the existing credentials, click Add and add the new credentials, and then click OK.
  7. 在 Service Manager 主控台中,按一下 [資料倉儲]****。In the Service Manager console, click Data Warehouse.
  8. 在 [ 資料倉儲 ] 窗格中,展開 [ 資料倉儲],展開 [ 安全性],然後按一下 [ 使用者角色]。In the Data Warehouse pane, expand Data Warehouse, expand Security, and then click User Roles.
  9. 重複步驟 3 到 6。Repeat steps 3 through 6.

變更 Service Manager 資料存取服務和 Service Manager 管理設定服務的登入帳戶To change the logon account for the Service Manager Data Access Service and Service Manager Management Configuration services

  1. 在主控 Self-Service 入口網站的電腦上,按一下 Windows 桌面上的 [ 開始],然後按一下 [ 執行]。On the computer that hosts the Self-Service Portal, on the Windows desktop, click Start, and then click Run.
  2. 在 [執行] **** 對話方塊的 [開啟] **** 方塊中,輸入 services.msc,然後按一下 [確定] ****。In the Run dialog box, in the Open box, type services.msc, and then click OK.
  3. 在 [ 服務 ] 視窗的 [ **服務] (本機) ** ] 窗格中,以滑鼠右鍵按一下 [ System Center 資料存取服務],然後按一下 [ 屬性]。In the Services window, in the Services (Local) pane, right-click System Center Data Access Service, and then click Properties.
  4. 在 [ **System Center 資料存取服務屬性 (本機電腦) ** ] 對話方塊中,按一下 [ 入],然後按一下 [流覽]In the System Center Data Access Service Properties (Local Computer) dialog box, click Log On, and then click Browse.
  5. 在 [ 選取使用者或群組 ] 對話方塊中,完成下列步驟:In the Select User or Group dialog box, complete these steps:
    1. 按一下 [ 位置],在 [ 位置 ] 對話方塊中,按一下 [ 整個目錄],然後按一下 [確定]Click Locations, in the Locations dialog box, click Entire Directory, and then click OK.
    2. 在 [ 輸入物件名稱來選取 ] 方塊中,輸入新運算元據庫帳戶的名稱,按一下 [ 檢查名稱],然後按一下 [確定]In the Enter the object name to select box, type the name of the new Operational Database Account, click Check Names, and then click OK.
    3. 在 [ 密碼 ] 和 [ 確認密碼 ] 方塊中,輸入新使用者的密碼,然後按一下 [確定]In the Password and Confirm Password boxes, type the password for the new user, and then click OK.
  6. 重新開機 Service Manager 資料存取服務。Restart the Service Manager Data Access Service.
  7. 以滑鼠按右鍵 [ System Center 管理設定],然後按一下 [內容]。Right-click System Center Management Configuration, and then click Properties.
  8. 在 [ **System Center 管理設定內容 (本機電腦) ** ] 對話方塊中,按一下 [ 入],然後按一下 [流覽]In the System Center Management Configuration Properties (Local Computer) dialog box, click Log On, and then click Browse.
  9. 在 [ 選取使用者或群組 ] 對話方塊中,完成下列步驟:In the Select User or Group dialog box, complete these steps:
    1. 按一下 [ 位置],然後在 [ 位置 ] 對話方塊中,按一下 [ 整個目錄],然後按一下 [確定]Click Locations, and in the Locations dialog box, click Entire Directory, and then click OK.
    2. 在 [ 輸入物件名稱來選取 ] 方塊中,輸入新運算元據庫帳戶的名稱,按一下 [ 檢查名稱],然後按一下 [確定]In the Enter the object name to select box, type the name of the new Operational Database Account, click Check Names, and then click OK.
    3. 在 [ 密碼 ] 和 [ 確認密碼 ] 方塊中,輸入新使用者的密碼,然後按一下 [確定]In the Password and Confirm Password boxes, type the password for the new user, and then click OK.
  10. 重新開機 Service Manager Management Configuration Service。Restart the Service Manager Management Configuration service.

建立 SQL Server 登入To create a SQL Server logon

  1. 在主控 Service Manager 和資料倉儲資料庫的電腦上,開啟 SQL Server Management StudioOn the computers hosting the Service Manager and data warehouse databases, open SQL Server Management Studio.
  2. 在 [ 連接到伺服器 ] 對話方塊中,完成下列步驟:In the Connect to Server dialog box, complete 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. 依序展開 [物件總管] **** 窗格中的 [安全性] **** 和 [登入] ****。In the Object Explorer pane, expand Security, and then expand Logins.
  4. 以滑鼠右鍵 按一下[登入],然後按一下 [新增登入]。Right-click Logins, and then click New Login.
  5. 在 [ 登入-新增 ] 對話方塊的 [ 選取頁面 ] 窗格中,按一下 [一般],然後按一下 [ 搜尋]。In the Login - New dialog box, in the Select a page pane, click General, and then click Search.
  6. 在 [ 選取使用者或群組 ] 對話方塊中,完成下列步驟:In the Select User or Group dialog box, complete these steps:
    1. 按一下 [ 位置],在 [ 位置 ] 對話方塊中,按一下 [ 整個目錄],然後按一下 [確定]Click Locations, in the Locations dialog box, click Entire Directory, and then click OK.
    2. 在 [ 輸入物件名稱來選取 ] 方塊中,輸入新運算元據庫帳戶的名稱,按一下 [ 檢查名稱],然後按一下 [確定]In the Enter the object name to select box, type the name of the new Operational Database Account, click Check Names, and then click OK.
  7. 在 [ 選取頁面 ] 窗格中,按一下 [ 伺服器角色],然後在 [ 伺服器角色 ] 清單中,確定已選取 [ 系統管理員 ] 和 [ 公用 ],然後按一下 [確定]In the Select a page pane, click Server Roles, and in the Server roles list, ensure that sysadmin and public are selected, and then click OK.

若要變更服務 ManagerSelf-Service 入口網站應用程式集區帳戶To change the Service ManagerSelf-Service Portal application pool account

  1. 在 Windows 桌面上,按一下 [ 開始],指向 [ 程式],指向 [系統 管理工具],然後按一下 [ Internet Information Services (IIS) 管理員]。On the Windows desktop, click Start, point to Programs, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
  2. 在 [ Internet Information Services (IIS) 管理員 ] 視窗的 [連線] 窗格 中,展開您的電腦名稱稱,然後按一下 [ 應用程式集區]。In the Internet Information Services (IIS) Manager window, in the Connections pane, expand the name of your computer, and then click Application Pools.
  3. 在 [ 應用程式 集區] 窗格中,以滑鼠右鍵按一下 SM_AppPool,然後按一下 [ Advanced Settings]。In the Application Pools pane, right-click SM_AppPool, and then click Advanced Settings.
  4. 在 [ Advanced Settings ] 對話方塊的 [ 進程模型 ] 區域中,按一下 [ 識別],然後按一下省略號 (...) 按鈕。In the Advanced Settings dialog box, in the Process Model area, click Identity, and then click the ellipsis (...) button.
  5. 在 [ 應用程式集區識別 ] 對話方塊中,選取 [ 自訂帳戶],然後按一下 [ 設定]。In the Application Pool Identity dialog box, select Custom account, and then click Set.
  6. 在 [ 設定認證 ] 對話方塊的 [ 使用者名稱 ] 方塊中,輸入運算元據庫帳戶的使用者名稱。In the Set Credentials dialog box, in the User name box, type the user name for the Operational Database Account. 在 [ 密碼 ] 和 [ 確認密碼 ] 方塊中,輸入新運算元據庫帳戶的密碼,然後按一下 [確定]In the Password and Confirm password boxes, type the password for the new Operational Database Account, and then click OK.
  7. 在 [ 應用程式集區識別 ] 對話方塊中,按一下 [確定]In the Application Pool Identity dialog box, click OK.
  8. 在 [ Advanced Settings ] 對話方塊中,按一下 [確定]In the Advanced Settings dialog box, click OK.
  9. 關閉 Internet Information Services (IIS) 管理員。Close Internet Information Services (IIS) Manager.

變更運算元據庫帳戶To change the Operational Database Account

  1. 在 Service Manager 主控台中,按一下 [系統管理]****。In the Service Manager console, click Administration.
  2. 在 [系統 管理 ] 窗格中,依序展開 [ 管理]、[ 安全性],然後按一下 [ 執行帳戶]。In the Administration pane, expand Administration, expand Security, and then click Run As Accounts.
  3. 在 [ 執行身份帳戶 ] 窗格中,按一下 [ 運算元據庫帳戶]。In the Run As Accounts pane, click Operational Database Account.
  4. 在 [工作] **** 窗格中,按一下 [屬性] ****。In the Tasks pane, click Properties.
  5. 在 [ 運算元據庫帳戶 ] 頁面的 [ 使用者名稱]、[ 密碼] 和 [ 網域 ] 方塊中,輸入運算元據庫帳戶的新認證,然後按一下 [確定]In the Operational Database Account page, in the User name, Password, and Domain boxes, type the new credentials for the Operational Database Account, and then click OK.

變更 Service Manager 所使用運算元據庫帳戶的密碼Change the password for the Operational Database account used by Service Manager

若要變更 Service Manager 資料存取和 Service Manager 管理設定服務的登入密碼,請執行下列程式。To change the log-on password for the Service Manager Data Access and Service Manager Management Configuration services, perform the following procedure.

  1. 在 Windows 桌面上,按一下 [開始] ,然後按一下 [執行] 。On the Windows desktop, click Start, and then click Run.
  2. 在 [執行] **** 對話方塊的 [開啟] **** 方塊中,輸入 services.msc,然後按一下 [確定] ****。In the Run dialog box, in the Open box, type services.msc, and then click OK.
  3. 在 [ 服務 ] 視窗的 [ **服務] (本機) ** ] 窗格中,以滑鼠右鍵按一下 [ System Center 資料存取服務],然後按一下 [ 屬性]。In the Services window, in the Services (Local) pane, right-click System Center Data Access Service, and then click Properties.
  4. 在 [ **System Center 資料存取服務屬性 (本機電腦) ** ] 對話方塊中,按一下 [ 入]。In the System Center Data Access Service Properties (Local Computer) dialog box, click Log On.
  5. 在 [ 密碼 ] 和 [ 確認密碼 ] 文字方塊中輸入新密碼,然後按一下 [確定]Type the new password in the Password and Confirm Password text boxes, and then click OK.
  6. 重新開機 Service Manager 資料存取服務。Restart the Service Manager Data Access Service.
  7. 以滑鼠按右鍵 [ System Center 管理設定],然後按一下 [內容]。Right-click System Center Management Configuration, and then click Properties.
  8. 在 [ **System Center 管理設定內容 (本機電腦) ** ] 對話方塊中,按一下 [ 入]。In the System Center Management Configuration Properties (Local Computer) dialog box, click Log On.
  9. 在 [ 密碼 ] 和 [ 確認密碼 ] 文字方塊中輸入新密碼,然後按一下 [確定]Type the new password in the Password and Confirm Password text boxes, and then click OK.
  10. 重新啟動 System Center 管理設定服務。Restart the System Center Management Configuration service.

變更 Service Manager 所使用的工作流程執行身分帳號憑證Change the workflow Run As account credentials used by Service Manager

在安裝期間,您已定義要指派給 Service Manager 工作流程執行帳戶的帳戶。During setup, you defined the account to be assigned to the Service Manager Workflow Run As account. 如果該帳戶的密碼發生變更,您必須使用新密碼來更新工作流程執行身分帳戶。If the password for that account changes, you must update the Workflow Run As account with the new password. 如果您想要變更 Service Manager 工作流程執行帳戶的帳戶,您必須變更工作流程執行身份帳戶和工作流程使用者角色。If you want to change the account for the Service Manager Workflow Run As account, you must change both the Workflow Run As account and the Workflow User Role.

請使用下列程序來定義做為工作流程執行身分帳戶的新使用者帳戶,並更新現有帳戶的新密碼。Use the following procedures to define a new user account for the Workflow Run As account and to update a new password for the existing account.

使用新認證變更工作流程執行身分帳戶To change the Workflow Run As account using new credentials

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

  2. 在 [系統 管理 ] 窗格中,依序展開 [ 管理]、[ 安全性],然後按一下 [ 執行帳戶]。In the Administration pane, expand Administration, expand Security, and then click Run As Accounts.

  3. 在 [ 執行身份帳戶 ] 窗格中,按一下 [ 工作流程帳戶]。In the Run As Accounts pane, click Workflow Account.

  4. 在 [工作] **** 窗格中,按一下 [屬性] ****。In the Tasks pane, click Properties.

  5. 在 [ 工作流程帳戶 ] 頁面的 [ 使用者名稱]、[ 密碼] 和 [ 網域 ] 方塊中,輸入工作流程執行身分帳戶的新認證,然後按一下 [確定]In the Workflow Account page, in the User name, Password, and Domain boxes, type the new credentials for the Workflow Run As account, and then click OK.

  6. 在 [系統 管理 ] 窗格中,按一下 [ 使用者角色]。In the Administration pane, click User Roles.

  7. 在 [ 使用者角色 ] 窗格中,按一下 [ 工作流程]。In the User Roles pane, click Workflows.

  8. 在 [工作] **** 窗格中,按一下 [屬性] ****。In the Tasks pane, click Properties.

  9. 在 [編輯使用者角色] 嚮導中,按一下 [ 使用者]。In the Edit User Role Wizard, click Users.

  10. 按一下 [ 移除 ] 移除現有的認證,按一下 [ 新增 ] 以新增您在步驟5中指定的認證,然後按一下 [確定]Click Remove to remove the existing credentials, click Add to add the credentials you specified in step 5, and then click OK.

    重要

    若無法為工作流程執行帳戶和使用者角色設定新帳戶,會導致 Service Manager 停止運作。Failure to configure the new account for the Workflow Run As account and User Role causes Service Manager to stop functioning.

變更工作流程執行身分帳戶認證的密碼To change the password for the Workflow Run As account credentials

  1. 在 Service Manager 主控台中,按一下 [系統管理]****。In the Service Manager console, click Administration.
  2. 在 [系統 管理 ] 窗格中,依序展開 [ 管理]、[ 安全性],然後按一下 [ 執行帳戶]。In the Administration pane, expand Administration, expand Security, and then click Run As Accounts.
  3. 在 [ 執行身份帳戶 ] 窗格中,按一下 [ 工作流程帳戶]。In the Run As Accounts pane, click Workflow Account.
  4. 在 [工作] **** 窗格中,按一下 [屬性] ****。In the Tasks pane, click Properties.
  5. 在 [ 工作流程帳戶 ] 頁面的 [ 密碼 ] 方塊中,輸入工作流程執行帳戶的新密碼,然後按一下 [確定]In the Workflow Account page, in the Password box, type the new password for the Workflow Run As account, and then click OK.

變更 Service Manager 所使用 SQL Server Analysis Services 帳戶的認證Change the credentials for a SQL Server Analysis Services account used by Service Manager

如果用於 SQL Server Analysis Services 帳戶的帳戶 Service Manager 變更,您也必須變更帳戶的認證。If the account that is used for the SQL Server Analysis Services account changes in Service Manager, you must also change the credentials for the account. 使用下列程式來變更 SQL Server Analysis Services 帳戶的認證。Use the following procedure to change the credentials for the SQL Server Analysis Services account.

變更 SQL Server Analysis Services 帳戶的認證To change the credentials for the SQL Server Analysis Services account

  1. 在主控 SQL Server Analysis Server (SSAS) 的電腦上,開啟 [ SQL Server Management Studio]。On the computer hosting SQL Server Analysis Server (SSAS), open SQL Server Management Studio.
  2. 在 [ 連接到伺服器 ] 對話方塊中,完成下列步驟:In the Connect to Server dialog box, complete these steps:
    1. 在 [ 伺服器類型 ] 清單中,按一下 [ Analysis Services]。In the Server Type list, click Analysis Services.
    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. Microsoft SQL Server Managementstudio 的 [ 物件總管 ] 窗格中,展開 [ 資料庫],展開 [ DWASDataBase],展開 [ 資料來源],然後按兩下 [ DWDataMart]。In Microsoft SQL Server Management Studios, in the Object Explorer pane, expand Databases, expand DWASDataBase, expand Data Sources, and then double-click DWDataMart.
  4. 在 [ 資料來源屬性-DWDataMart] 的 [ 安全性設定] 底下,按一下 [ ImpersonateAccount] 旁的省略號按鈕 ( ... ) 。In Data Source Properties - DWDataMart, under Security Settings, click the ellipsis button (...) next to ImpersonateAccount.
  5. 在 [模擬 資訊 ] 視窗中,選取 [ 使用特定的 Windows 使用者名稱和密碼],輸入新帳戶的認證,然後按一下 [確定]In the Impersonation Information window, select Use a specific Windows user name and password, type the credentials for the new account, and then click OK.
  6. 按一下 [確定] 關閉 [ 資料來源屬性-DWDataMart],然後關閉 Microsoft SQL Server Management Studio。Click OK to close Data Source Properties - DWDataMart, and then close Microsoft SQL Server Management Studio.

變更 Service Manager 所使用 SQL Server Reporting Services 帳戶的認證Change the credentials for the SQL Server Reporting Services account used by Service Manager

如果用於 SQL Server Reporting Services 帳戶的帳戶變更 Service Manager,您必須變更帳戶的認證。If the account that is used for the SQL Server Reporting Services account changes in Service Manager, you must change the credentials for the account. 使用下列程式來變更 SQL Server Reporting Services 帳戶的認證。Use the following procedure to change the credentials for the SQL Server Reporting Services account.

變更 SQL Server Reporting Services 帳戶的認證To change the credentials for the SQL Server Reporting Services account

  1. 在主控 SQL Server 報表伺服器 (SSRS) 的電腦上,啟動瀏覽器並連接至 http://<server name>/reportsOn the computer hosting SQL Server Reporting Server (SSRS), start a browser, and connect to http://<server name>/reports.
  2. SQL Server Reporting Services 首頁 上,按兩下 [ Service Manager],然後按兩下 [ DWStagingAndConfig]。On the SQL Server Reporting Services Home page, double-click Service Manager, and then double-click DWStagingAndConfig.
  3. 在 [ 連接方式] 區域中,按一下 [ 安全地儲存在報表伺服器中的認證],在 [ 使用者名稱 ] 和 [ 密碼 ] 方塊中輸入目前的認證, 然後按一下 [ 套用]。In the Connect using area, click Credentials stored securely in the report server, type the current credentials in the User name and Password boxes, and then click Apply.
  4. 在瀏覽器工具列中,按一下 [ 上一步 ] 按鈕以返回 [ Service Manager ] 頁面。In the browser tool bar, click the Back button to return to the Service Manager page.
  5. 針對剩餘的 Service Manager 資料來源重複步驟2和3。Repeat steps 2 and 3 for the remaining Service Manager data sources.

變更 SQL 登入帳戶的預設語言Change the default language for the SQL login accounts

建議您將英文作為 SQL 使用者登入帳戶的預設語言。We recommend English as the default language for the SQL users' login accounts.

因為日期格式是以語言為基礎,所以如果 SQL 使用者登入帳戶的語言不是英文,則會有一些資料倉儲工作,特別是使用 SQL SET_DateFormat 函式的作業失敗。As date format is based on the language, if the language of SQL user login accounts is not English, then, a few data warehouse jobs, especially the jobs that use SQL SET_DateFormat function, fail. 這些作業不會從 Service Manager 將資料推送至資料倉儲,或可能會將不正確的資料傳送到資料倉儲,而導致資料倉儲中的資料損毀。These jobs do not push the data into the data warehouse from Service Manager or might send incorrect data into the data warehouse, leading to data corruption in the data warehouse..

您可以為新的 SQL 登入帳戶將預設語言設定為英文,或變更現有帳戶的預設語言。You can set the default language as English for a new SQL login account or change the default language for an existing account. 深入了解Learn more.

後續步驟Next steps