Thread: Resetting rpd Password (Informative)

This question is not answered. Helpful answers available: 4. Correct answers available: 1.


Permlink Replies: 3 - Pages: 1 - Last Post: Aug 7, 2009 12:48 AM Last Post By: Kishore Guggilla
Kishore Guggilla

Posts: 1,311
Registered: 06/17/08
Resetting rpd Password (Informative)
Posted: Aug 6, 2009 10:43 AM
 
Click to report abuse...   Click to reply to this thread Reply
Hello Everybody,

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

The work around I found:

  • Open NQSConfig.INI file
  • Go to Security part and find AUTHENTICATION_TYPE = BYPASS_NQS;
  • Uncomment this part
  • 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.
  • I am not aware of whether it is bug or something else, and don’t even know any other best solution exists for the same. Using Import from Repository hope we can do this... As it's deprecated and the above procedure is the simple one, i am using this...

    But this is the work around I found and want to let you all know this.
    I blog it soon... :-)

    Hope it's helpful...

    Corrections & Comments are welcome... :)

    hsekar

    Posts: 83
    Registered: 11/11/08
    Re: Resetting rpd Password (Informative)
    Posted: Aug 6, 2009 11:02 AM   in response to: Kishore Guggilla in response to: Kishore Guggilla
     
    Click to report abuse...   Click to reply to this thread Reply
    Hi Kishore,

    Trying to understand the procedure,although its offline copy you are opening the same RPD for which you forgot the p/w.How will it open in offline mode if you uncomment AUTHENTICATION_TYPE = BYPASS_NQS.

    let me know if i am understanding in wrong way.

    Thanks
    rnm1978

    Posts: 763
    Registered: 01/16/09
    Re: Resetting rpd Password (Informative)
    Posted: Aug 7, 2009 12:39 AM   in response to: Kishore Guggilla in response to: Kishore Guggilla
    Helpful
    Click to report abuse...   Click to reply to this thread Reply
    Good find! :)

    I've validated the procedure here, with a couple of observations:
    1) If you delete or rename NQSConfig.ini the Admin Tool still loads (but requires the correct Administrator password)
    2) If you invalidate the NQSConfig.ini (eg omit a closing square bracket from a section heading) then you get NQSError 47012 Syntax error in NQSConfig.ini file.
    so it looks like the Admin tool will read the file if it's there (and honour the AUTHENTICATION_TYPE setting), but doesn't require it.

    It would be interesting to raise this as an SR to find out if it's intended behaviour.
    Kishore Guggilla

    Posts: 1,311
    Registered: 06/17/08
    Re: Resetting rpd Password (Informative)
    Posted: Aug 7, 2009 12:48 AM   in response to: rnm1978 in response to: rnm1978
     
    Click to report abuse...   Click to reply to this thread Reply
    Hi...

    Thanks for you comment..

    Yes.. i did the first observation.
    But the 2nd one is some what interesting..

    Hey.. anyhow, thanks for the information. May i know your name please... :)

    I marked your comment as helpful... ;)
    Legend
    Guru Guru : 2500 - 1000000 pts
    Expert Expert : 1000 - 2499 pts
    Pro Pro : 500 - 999 pts
    Journeyman Journeyman : 200 - 499 pts
    Newbie Newbie : 0 - 199 pts
    Oracle ACE Director
    Oracle ACE Member
    Oracle Employee ACE
    Helpful Answer (5 pts)
    Correct Answer (10 pts)

    Point your RSS reader here for a feed of the latest messages in all forums