Reset default MaxDB password

[Former Member]

Hi,

I am using NetWeaver 2004s ABAP Trial version. I have forgotten the MaxDB password for CONTROL user. Is there a way I can reset it using SAP GUI.

Regards,

Jagannath

[Former Member · Accepted solution]

Hi,

Using DBM gui connect to the database, and then do to configuration->databse user.

Login using dba user and there you can see the list of users. click on it and then go for change password.

regards and do reward with suitable points

[Former Member]

Hi,

Should xlist not be of any help Iu2019ve developed a solution for resetting MaxDB passwordsu2026

Check out my blog for more information

http://www.mattbartlett.co.uk/maxdb-password-reset-procedure-versions-7-6-7-7-7-8/

Video - MaxDB Password Reset Procedure

http://www.youtube.com/watch?v=L8Wy_x3zsS0

Cheers

Matt

[former_member229109]

Hello Jagannath,

You could change the password of the control user using DBMGUI:

A) if you are able logon as SYSDBA user < by default - SUPERDBA/admin >;

B) Stop database; database is in offline mode;

C) Top menu-> Instance-> Configuration -> DBM Operator;

Display properties of the control user ->

Password : < Change ...>

Click on bottom < Change ...> -> Change password

D) Disconnect the database;

E) Connect to the database as control user with the new password;

F) For SAP systems, please pay attention to the note ::

39439 XUSER entries for SAP DB 6.x and 7.x

-> Please let me know what version of the database you have?

-> What is the version of the DBMGUI? < Start DBMGUI -> Help ->About >

-> Could you connect to the database as SUPERDBA user?

If you are SAP customer please review the SAP notes:

767598 Available documentation

25591 Changing the DBM, SYSDBA and DBA user passwords

Please review the document "Changing the Passwords of Standard Users " at ::

http://maxdb.sap.com/currentdoc/ca/69d8b637f1bb4d913c877c1ab33b73/content.htm

<http://maxdb.sap.com -> We have updated the documentation for MaxDB 7.6.

To read the new documentation online, go to

http://maxdb.sap.com/currentdoc/default.htm -> Basic Information ->

MaxDB Security Guide -> User Administration and Authentication ->

Changing the Passwords of Standard Users >

Thank you and best regards, Natalia Khlopina

[Former Member]

Hi Natalia, Mantosh,

Thanks a lot for replying.

Here are the requested details. I have forgotten the SUPERDBA password too

DB Version : 7.6.00.32

DBMGUI Version : 7.6.00.37

I am unable to connect as SUPERDBA user

Regards,

Jagannath

[former_member229109]

Hello Jagannath,

-> Do remember any passwords, which you setup during the installation?

-> Please check if you have xuser entries on the database server.

Logon as <sid>adm user & run command:

xuser list

Thank you and best regards, Natalia Khlopina

[Former Member]

Hi Natalia,

I recollected the password and able to connect to the database.

Thanks,

Jagannath