Username/password

[Former Member]

Made an new sap instance and choose dbm/dba passwords.

I took a backup .bak file (without log).

Restored it with initialisation in admin mode.

Database goes online, everything looks ok.

However when I want to use sql studio or i.e. the database tune check I run into an invalid username/password. It seems not possible to access the database because of that.

I don't know the passwords, if any, of the backup. How can I reset this?

Gunther

[Former Member]

you try to use authority check according to your values

[Former Member]

You should access sql studio with a schema user, not dbm/dba.

Kind regards,

Mark

[Former Member]

Can you please more specific how to do that? By means of cli?

Note: I don't have any login data (this is an very old backup .bak file we had still around), also not from other (schema) users.

I 've seen somewhere an advices to empty the log volume of the new instance before restore the backup. Does that do the trick?

Gunther

[former_member229109]

Hello Gunther,

-> What is the version of the database?

-> Connect to the target database as dbm user using dbmcli tool:

dbmcli u2013d <SID> -u dbm,<pwd>

<enter>

and run

dbmcli on <SID>>sql_execute select * from users

post the results.

-> What is the SYSDBA user of the source database?

You should be able to connect using SQL studio to the target database with SYSDBA user and password of the source database.

-> u201CI don't know the passwords, if any, of the backup. How can I reset this?u201D

What do you mean? How did you get the database backup?

You have the databackup of the database instance.

Check with the database administrator of this database instance the database users/passwords.

Thank you and best regards, Natalia Khlopina

[Former Member]

Natalia,

Thx for your reply, i will come back later to you on the first technical part of your answer and use the dbmcli tool this weekend.

For your understanding. This is an old back up ( I can find out which version of maxdb also later), the original SAP installation is way gone. The database manager is probably retired ny now.

We like to have a look if we can still get data out of the back-up by looking at/export the tables. For that I installed maxdb and found out that I have to make a new installation/instance with sufficient volume space for the logs and data and I could recover with ease. Get database also online, but get in the database manager/sql studio login/authentification messages when I want to use it.

Gunther

-> What is

the version of the database?

-> Connect to the target database as dbm user using dbmcli tool:

dbmcli u2013d <SID> -u dbm,<pwd>

<enter>

and run

dbmcli on <SID>>sql_execute select * from users

post the results.

-> What is the SYSDBA user of the source database?

You should be able to connect using SQL studio to the target database with SYSDBA user and password of the source database.

-> u201CI don't know the passwords, if any, of the backup. How can I reset this?u201D

What do you mean? How did you get the database backup?

You have the databackup of the database instance.

Check with the database administrator of this database instance the database users/passwords.

Thank you and best regards, Natalia Khlopina

[former_member229109]

Hello Gunthero,

-> If you are SAP customer => create the ticket on this issue.

-> If the standard passwords are worked, we could check.

If not and you have only the database backup file, the database was already uninstalled,

try contact the Database administrator < who created the database >.

The access to the database application data will be not possible if you have only the databackup files and the SYSDBA and DBA users passwords are lost.

Thank you and best regards, Natalia Khlopina