SAP* user was deleted from table USR01 and USR02 on SQL server database

[Former Member]

Dear All,

I try to login to client 800, it's an IDES BI 7.0 netweaver. After fresh installation, I do not know any user name, so I tried to login with SAP* and DDIC password.

Unfotunately both users are now locked for client 800.

I tried to reset SAP* by deleting both from table USR01 and USR02. This morning, I browse internet and found out that I have deleted not only USR02, but also USR01.

Now I realize that USR02 is enough. I delete only information regarding to MANDT = 800

I also delete user DDIC from USR01 and USR02, also only for client 800.

But, I still cannot login.

My question:

1. What informations are damaged because i delete from 2 tables, instead of 1 table ?

2. Why I still cannot login to client 800 ?

3. Is there any other way to login to IDES client 800 ?

Many thanks and point will be awarded.

Dex R. Soeprijadi

[Former Member · Accepted solution]

Hi,

i assume that you delete sap* user from client 800 table usr02 and usr01

login into client 000 with sap* user with password that you provide during installation.

set following instance profile parameter using RZ10

login/no_automatic_user_sapstar = 0

save profile and activated it .

restart sap server.

now login into client 800 with sap* user and password 'pass'

regards,

kaushal

[Former Member · Accepted solution]

Yes it solved my problems