Powercenter8.1.1之啟動Service initialization failed

qqmengxue發表於2011-06-29

環境介紹:

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為正確的重啟問題就可以解決

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10130206/viewspace-1051762/,如需轉載,請註明出處,否則將追究法律責任。

相關文章