Skip to Content
author's profile photo Former Member
Former Member

forget the password for dbm and dbadmin in maxdb .

Hi all

Is there any way to reset the dbm,dbadmin passowd for maxdb because i have forget all the paswords.Is there any way to chage the .upc file to reset the password.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on May 14, 2012 at 10:15 PM

    Hello,

    Did you forget both user's passwords?

    Similar question was already posted by another MAXDB users & you could search for answers.

    Are you SAP customer?

    How did you install/create the database instance?

    Did you save the database users passwords in the DB studio or DBMGUI prophiles?

    What is the version of your database?

    Did you try to connect to the database with default user/pwd ?

    http://maxdb.sap.com/doc/7_7/45/01f20034166c32e10000000a114a6b/content.htm

    Regards, Natalia Khlopina

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Arshad,

      I am afraid there is no standard procedure available for MaxDB to recover lost or forgotten passwords.

      In critical situation in case the passwords of DBM and SYSDBA database users need to be reset for you for the PRODUCTION SERVER=> Create a SAP message and maintain the open connection to the server => SAP MaxDB Developers could check the binary files if the database user's passwords could be reset. This cannot be done at customer site without SAPs help.

      Please also keep in mind not to forget your passwords. Recovering passwords from SAP is time consuming and would normally be charged as 'Remote Consulting' service.

      In your case, if you do not have important data in your DB, you can drop the database and reinstall the system. In future to avoid this situation makesure to use atleast one of the following:

      • If an r/3 system has a connection to the MaxDB that was setup in DB59 properly, you may connect to the database using DB50 / DB50N and change the password using "dbmcli" tool.
      • If you are able to connect the MaxDB using DBMGUI/DATABASE STUDIO and the password is saved in those tools, you would be able to change the
        password (Refer to the note: 25591)
      • If the XUSER entries are maintained that contain connection information that is required to log on to the database. (Refer to the solution of this note 39439) to create XUSER entries for the OS User.

      If the DBM or SYSDBA password is known, you can use SAP Note: 25591 - Password change for DBM and DBA users to change the password.

      I hope this helps.

      Regards,

      Yashwanth

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.