Reset control user password?

[donald_voorhees]

Hello,

I have just installed a Windows 64 bit NW CE 7.1 instance on a Max DB database. The install did not ask me for a password for the control user and control/control does not work. I need to connect to it via Max DB gui to configure it and complete the install. I know there is a command line utility to change the control user password but I can not find it anywhere.

Can anyone off any assistance/help with this?

Thanks

[former_member229109]

Hello Donald,

-> What master password did you set during the installation?

-> Was you able to add the database instance in DBMGUI?

-> Please try to connect to the database with control user & 'master-password'.

Thank you and best regards, Natalia Khlopina

[donald_voorhees]

Thanks for the reply.

I tried the master password with no success. I also tried SUPERDBA and ADMIN with no success.

The MaxDB is running and I was able to add the server to the MAXDB gui, but as you can imagine I cant connect to the DB instance.

[former_member229109]

Hello Donald,

-> What is the 'master password' you set during the installation?

-> Please logon to the database server as <SID>adm, run the following commands

& update with outputs ::

dbmcli inst_enum

dbmcli db_enum

xinstinfo <SID>

dbmcli -d <SID> -u superdba,<master password> db_state

xuser list

Thank you and best regards, Natalia Khlopina

Edited by: Natalia Khlopina on May 13, 2008 5:06 PM

[donald_voorhees]

Thank You, as I said the master password doesnt seem to work at all. As a matter of fact no user/password combo seems to work even the defaults. Here are the outputs.

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\ssdadm>dbmcli inst_enum

OK

7.6.03.05 E:\sapdb\SSD\db

C:\Documents and Settings\ssdadm>dbmcli db_enum

OK

SSD E:\sapdb\SSD\db 7.6.03.05 fast runnin

SSD E:\sapdb\SSD\db 7.6.03.05 quick offlin

SSD E:\sapdb\SSD\db 7.6.03.05 slow offlin

SSD E:\sapdb\SSD\db 7.6.03.05 test offlin

C:\Documents and Settings\ssdadm>xinstinfo SSD

IndepData : E:\sapdb\data

IndepPrograms : E:\sapdb\programs

InstallationPath : E:\sapdb\SSD\db

Kernelversion : KERNEL 7.6.03 BUILD 005-123-152-005

Rundirectory : E:\sapdb\data\wrk\SSD

C:\Documents and Settings\ssdadm>dbmcli -d SSD -u superdba, XXXpassw1 dbstate

Error! Connection failed to node (local) for database SSD:

-24950,ERR_USRFAIL: User authorization failed

C:\Documents and Settings\ssdadm>xuser list

-

---

XUSER Entry 1

-

---

Key :DEFAULT

Username :SAPDBJ2EE

UsernameUCS2:S.A.P.D.B.J.2.E.E. . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :SSD

Nodename :sapmgmt-jf00

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 2

-

---

Key :c_J2EE

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :SSD

Nodename :sapmgmt-jf00

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 3

-

---

Key :w

Username :SUPERDBA

UsernameUCS2:S.U.P.E.R.D.B.A. . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :SSD

Nodename :sapmgmt-jf00

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

C:\Documents and Settings\ssdadm>

[former_member229109]

Hello Donald,

-> You tried:

"C:\Documents and Settings\ssdadm>dbmcli -d SSD -u superdba, XXXpassw1 dbstate"

there is space after "...superdba, " & before the password

=>

Please run:

C:\Documents and Settings\ssdadm>dbmcli -d SSD -u superdba,XXXpassw1 db_state

-> Please update with output of the commands as ssdadm user:

C:\Documents and Settings\ssdadm>dbmcli -d SSD -U w db_state

C:\Documents and Settings\ssdadm>dbmcli -d SSD -U c_J2EE db_state

< If the passwords of the users control, superdba saved correctly using xuser tool,

then you could connect to the database using c_J2EE or w key >

Thank you and best regards, Natalia Khlopina

Edited by: Natalia Khlopina on May 14, 2008 12:43 PM

[donald_voorhees]

Thanks for all your help so far.

Even with the space gone, no connection is possible.

Unfortunately what seems to be the issue is no passwords got set for any of the DB users, it is impossible to connect to the DB using any user or password combo.

I need to find the process to reset the control users password.

Output of requested commands.

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\ssdadm>dbmcli -d SSD -U w db_state

OK

State

ONLINE

C:\Documents and Settings\ssdadm>dbmcli -d SSD -U c_J2EE db_state

OK

State

ONLINE

C:\Documents and Settings\ssdadm>

[former_member229109]

Hello,

There are options::

1) Need check if you created the xuser entries for control or superdba user

for your database for the OS user. The xuser entries are OS user dependent.

2) Are you SAP customer? Do you have the R/3 system where you created the

connection to the database in /ndb59?

3) Check if you added the database in the DBMGUI and saved the logon user/

pwd in the DBMGUI profile.

4) If you didn't save the passwords using the xuser database tool or database connections

in TA /ndb59 on R/3 system or in DBMGUI profile on your local PC, you have forgotten

both Passwords of the control < DBM user > and superdba < DBA user > users, then

there no options to access the database. It's the security.

… If any above options are not working=> I could only recommend uninstall/install option.

=> We could use the first option to reset the control user password in database ::

C:\Documents and Settings\ssdadm>dbmcli -d SSD -U c_J2EE db_state

OK

State

ONLINE

==> run ::

C:\Documents and Settings\ssdadm>dbmcli -d SSD -U c_J2EE db_offline

C:\Documents and Settings\ssdadm>dbmcli -d SSD -U c_J2EE user_put control password=control

&& test, that you could connect to the database with control user ::

C:\Documents and Settings\ssdadm>dbmcli -d SSD -u control,control db_state

If it's successful, the update of the connection data has to be done.

< If you are SAP customer => SAP notes 25591& 39439 >

Thank you and best regards, Natalia Khlopina