Oracle, I and everything in between

August 7, 2009

Retrieving Administrator Password

Filed under: Uncategorized — Prakash @ 2:49 am

I always thought that there was no way to retrieve or reset the Administrator password. Until I came across Kishore’s post on OTN. To my surprise, it WORKS!

From Kishore’s post (Good one Kishore!):

  • Open NQSConfig.INI file
  • Uncomment AUTHENTICATION_TYPE = BYPASS_NQS;
  • Stop the BI Server service
  • Close Administration Tool, if opened. (Then only the changes are affecting to the Administration Tool)
  • Open Administration Tool, then rpd which needs password reset, in offline mode
  • Give any password here, it accepts.
  • Now go to Manage > Security.
  • From here it’s the normal process how you change password for Administrator.
  • Save the changes to rpd
  • Revert back the changes in NQSConfig.INI
  • Start BI Server and open rpd with new password.
  • Create a free website or blog at WordPress.com.