forget the password for dbm and dbadmin in maxdb .

[Former Member]

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.

[former_member229109]

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

[Former Member]

Hi

sorry for so much late reply.

i search a lot but couldn't find any answer regarding this.

Here is the complete situation.

i installed a maxdb database,and i forget both password for dbm and dbadmin users

yes i am a sap customer

i create the database as single install ,not with SAP installation.

i didn't save password to dbmgui or dbstudio because just after installation i  forget password.

i cannot also login through xuser key.

verion of my database is 7.8.01

yes i tried to connect using default password as listed in URL documentation.

now same is the problem with one of my QA server installation

here i installed SAP EHP 6 . and i forget the master password that i set during installation.database is same maxdb 7.8.01,Is there anyway to reset this.

[yashwanthkumar_kethineed]

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