環境介紹：

Powercenter8.1.1 win32bit

SQL SERVER 2008

[@more@]

由於公司要做BI專案，所以準備使用powercenter這個老大工具，下載-安裝一切順利，可是在啟動service的時候卻報：

The Integration Service PowerCenter_Integration_Service is enabled to run in Normal mode.

The service did not start due to the following error: Service initialization failed.. Check the for more information

很是不解，powercenter本身可以設定為啟動DEBUG模式，設定方式為：選擇相應的NODE->Properties->Error Severity Level 修改為DEBUG模式，然後重啟，觀察日誌會發現以下資訊：

ERROR 星期三六月 29 14:39:25 2011 2648 CMN_1006 Failed to connect to repository [PowerCenter].
ERROR 星期三六月 29 14:39:25 2011 2648 REP_12400 Repository Error ([REP_55102] Failed to connect to repository service [PowerCenter].)
ERROR 星期三六月 29 14:39:25 2011 2648 REP_12400 Repository Error (Failed to connect to repository service [PowerCenter].)
ERROR 星期三六月 29 14:39:25 2011 2648 REP_12014 An error occurred while accessing the repository
ERROR 星期三六月 29 14:39:25 2011 2648 REP_12400 Repository Error (Failed to connect to repository service [PowerCenter].)
ERROR 星期三六月 29 14:39:25 2011 2648 REP_12400 Repository Error ([REP_57060] Login failure. User Administrator failed to login to the repository. Error Message: The password is incorrect for user Administrator) ERROR 星期三六月 29 14:39:25 2011 2648 REP_12400 Repository Error (User Administrator failed to login to the repository. Error Message: The password is incorrect for user Administrator)
ERROR 星期三六月 29 14:39:25 2011 2648 REP_12014 An error occurred while accessing the repository

透過日誌不難發現是做密碼驗證的時候不透過導致的，

透過查詢相應的資料發現powercenter關於Integration service預設的使用者名稱密碼為：Administrator/Administrator,透過修改相應Integration service—>Associated Repository->修改Repository User Name和Repository Password為正確的重啟問題就可以解決

Powercenter8.1.1之啟動Service initialization failed

相關文章