Unknown user name/password combination

[Former Member]

Hi,

I have a simluar problems as discribed in some of the other threads but haven't been able to solve it .

I wanted to move the Solution Manager 4.0 datatbase from a 32-bit windowds to an 64-bit windows system.

I installed a new SOL version on the 64-bit machine. The installtion process asks only for 2 passwords, one master passwrod and on for the system users. I've entered both and know what they are.

I then took a backup of the 32-bit database en performed and recovery with initialization on to the 64-bit system.

When trying to connect to the database afterwards i found out that the control password was not control anymore but the master password from the installation.

If created all the xusers as per note 39439 but have still the problem that I can't get SAP connecting to the database.

Any suggestions?

[Former Member]

Thanks Thomas,

I could successfully changed the passwords, meaning I didn't get an error doing this, but do I need to change XUSER as well before I can connect to the database wiith the new passwords and do i need to stop the database

Regards

hans

[TTK]

Hello Hans

Without warranty:

I think, stopping the db is not necessary but maybe reloading of the systemtables

i.e.: dbmcli ... load_systab

If the DBA is not in XUSER, there should be no need for adjusting.

Greetings Thomas

[Former Member]

Hi Thomas,

thanks for you help so far . I get the impression that there is something very wrong with this database or the installation. When trying the usre_rename I am getting the following error:

dbmcli on SOL>user_rename sapsol newsol

ERR

-24951,ERR_USRREAD: Could not read DBM operator data

20178,Profile for sapsol not found

[Former Member]

Sorry,

but I am getting the following error trying the sql_execute command

dbmcli on SOL>sql_execute alter password sapsol ******* user_sysdba superdba ******

-24988,ERR_SQL: SQL error

-3014,Invalid end of SQL statement

(*****) are the passwords

Hans

[TTK]

My answer was probably not sufficient.

With following sequence I can change the DBA-user. Controluser is DBM password DBM, sysdba is DBA, DBA:

dbmcli -d v76 -u dbm,dbm

> user_rename dba dba2

> sql_connect dba2,dba

> sql_execute alter password dba2 dba2

> user_sysdba dba2,dba2

> quit

dbmcli -d v76 -u dba2,dba2 load_systab

In your case, maybe

dbmcli -d v76 -u dbm,dbm

> user_sysdba dba2,dba2

would be sufficient (of course, replacing your control and dba user names and passwords).

Regards Thomas

[Former Member]

results are

OK

CONTROL

SUPERDBA

[TTK]

Hello Hans

maybe resetting the password for the dba works:

with dbmcli as dbm:

sql_execute alter password <dba user> <pwd>

user_sysdba <dba user> <pwd>

HTH Thomas

[Former Member]

Hi Markus,

That's is when it get the following error:

ERR

-24907,ERR_DBAWRONG: wrong SYSDBA

regards

Hans

[markus_doehr2]

I must admit - I have no more idea. I´ve done a lot o system copies in the last 10 years but I have never faced that problem as it´s showing...

What do you get when you execute

dbmcli -u control, user_getall

Markus

[Former Member]

Hi

Tried it with both without success. Is the password defined in xuser the password that is used or does the database store this in the system tables?

Hans

[markus_doehr2]

Strange.

it´s stored (also) in dbm.upc and also in the database.

What happens if you give the whole command on command line?

dbmcli -u control, -ud domain

Markus

[Former Member]

When trying to load the system tables following error occurs:

ERR

-24907,ERR_DBAWRONG: wrong SYSDBA

regards

Hans

[markus_doehr2]

Which superdba password did you use? The "old" or the "new" one?

Markus

[Former Member]

Hi Markus,

I thought that should use the old passwrds but when I try to connect via DBMGUI I can only do this using the new password for contro

regards

Hans

[markus_doehr2]

The control password is not stored in the database.

Did you already load the system tables?

If the old password work, then you can set it using

xuser -U c -u <controluser>,<controlpw> -d <SID> -n <hostname> set

Markus

[Former Member]

I had the same problem:

I found a solution in this thread:

http://lists.mysql.com/maxdb/25356

It worked for me. Please post your experience.

good luck

Edited by: Christian on Dec 17, 2007 10:30 PM

[Former Member]

The old passwords are the maxdb standards (as far as I now)

[markus_doehr2]

If you copy a database the control and superdba are copied with them - so did you try those passwords instead of the new ones?

--

Markus

[markus_doehr2]

Did you try the "old" passwords from the source system?

--

Markus