Forgot password for OBIEE rpd (or) Resetting Admin Tool password

Standard

During my R&D work today, i come across a situation how to reset the password for rpd where I forgot the old password. All existed solutions (like NQSChangepassword.exe command) have associated with mentioning old password to get the new one.

The work around I found:

  1. Open NQSConfig.INI file
  2. Go to Security part and find AUTHENTICATION_TYPE = BYPASS_NQS;
  3. Uncomment (remove #) this part.
  4. Stop the BI Server service
  5. Close Administration Tool, if opened. (Then only the changes are affecting to the Administration Tool)
  6. Open Administration Tool, then rpd which needs password reset, in offline mode
  7. Give any password, it accepts.
  8. Now go to Manage > Security.
  9. From here it’s the normal process how you change password.
  10. Save the changes to rpd
  11. Revert back the changes in NQSConfig.INI
  12. Start BI Server and open rpd with new password.

I am not aware of whether it is this bug or something else. And there is also a way to do this using Import from Repository. But this is deprecated option. Of course, i found that my approach is an easy way and not time consuming process 🙂

This is the work around I found for resetting password of rpd.

The same i posted in Forums too ..

here it is….

BTW, I am using 10.1.3.4 version…

Your’s Kishore…

Advertisements

About Kishore & Naresh

Hi.. This is a blog operated by Kishore and Naresh. We are colleagues and working as BI Developers. Here we want to share our ideas and researches here. We were the active members of OTN Forums and inspired with Venkat and John's blog. We may not reach to that level, but we brings up all our ideas and research work we done. All the views expressed here are our own and does not reflect the views of our employers. We need all your blessings and support to grow. Thanks

17 responses »

  1. Kishore & Naresh……g8 work. This was my first week of refreshing what i learnt about OBIEE in the month of Apr-09. And after doing the install the first bottleneck was accessing the rpd file that i created (on the day of install). None of the passwords that i gave during the installations worked…and i wonder why???.

    Anyway the solution you provided helped me overcome the misery! Thanks.

  2. Hi Kishore,

    Thanks for sharing information. These were really helpful.

    I have also copied some posts to my blog with reference as your blog. In case you have any obligations do let me know. I will remove them.

    Regards,
    Ashish

    • i don’t have any issues if you’re mention parent reference as my post…

      Can you please share your blog link…

      Thanks

  3. hi

    if you make changes in offline mode how it will reflect and moreover RPD offline changes are something by which those changed at file system.

    Thanks
    Reddy

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s