SAP* Passwords is not working

[Former Member]

Hello,

I do to set the parameter login/no_automatic_user_sapstar=0 in instance profile.

I delete the entry with :

delete from usr02 where mandt='<client>' and bname='SAP*';

After that i restart the SAP server but i can't login with sap* login through the password : PASS or 06071992.

My system is a SAP PI 7.00

Thanks in advanced.

[Former Member · Accepted solution]

Hi,

    Please perform the following .

1. execute select bname,mandt from <schemaid>.usr02 where bname='SAP*' and mandt=client number;

check if the sap* is existing. if not replace SAP* with sap* and check whether the user exists.

If exists, try to delete using the following command

delete from schema id.usr02 where bname = 'SAP*' and mandt = 'client number '

Example  :  delete from SAPDAT.usr02 where bname = 'SAP*' and mandt = '500'

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

I verified again but I already deleted the entry in the SAP*.

[HuseyinBilgen · Accepted solution]

Hi

Password must be pass not PASS as PI 7.x systems are case sensitive for passwords.

[Former Member · Accepted solution]

I tried both in case but i don't working

[HuseyinBilgen · Accepted solution]

Hi Sarah,

Can you please share the profile value screen at RZ11.

[Former Member · Accepted solution]

I do not have access to SAP.

I have to create the admin accounts on machines when they have not been provided

I access a instance file

DX1_DVEBMGS00.txt.zip

[HuseyinBilgen · Accepted solution]

Profile looks ok, did you check USR02 table with Joseph's command (select ...)?

[Former Member · Accepted solution]

Is it possible can you send the screenshot of the output of the following sql command.

select bname,mandt from <schemaid>.usr02 where bname='SAP*' and mandt=client number;

put the client number in which you want to login with sap* user.

As well as, I would suggest you to stop all the SAP services + oracle services + listener . den start listener-> oracle services and finally SAP serivces and check whether you are able to login.

Thanks and Regards,

Vimal

[Former Member · Accepted solution]

I rebooted the system with all but I'm on windows and SQL server so I rebooted saposcol services and others services.
I do not really know the listener in sql server.

[HuseyinBilgen · Accepted solution]

Hi Sarah,

you're trying to logon client 000 right?

Because the screen shows only the client 000 entries in USR02.

[Former Member · Accepted solution]

Yes, i tried to logon client 000, i tried too on client 001 but i don't show all entry of table.

[Former Member · Accepted solution]

Hi Sarah,

Try to restart SQL server too.

Please try to remove the spaces/blanks  in the end of the profile. Try to add the following parameter in the the  DEFAULT profile

login/no_automatic_user_sapstar=0

Restart SAP as well as SQL and try to login and provide your status.

Thanks and Regards,

Vimal

[HuseyinBilgen · Accepted solution]

also please share the logon screen capture when you got the error. Take full GUI screen please

[Former Member · Accepted solution]

Hi Sarah,

Try this below command , before running change the Schema Id & Client No for which you want to reset the SAP* password

1.     select bname,bcode,uflag,mandt from <schemaid>.usr02 where bname like 'SAP*%';

2.     update sapsr3.usr02 set bname='SAP*.OLD' where bname='SAP*' and mandt= <CLIENT NO>;

3.     commit;

Now login to the client which you want with SAP* & password pass. Also provide the output

Hope it solve your problem

Punit

[Former Member · Accepted solution]

Hi

Unlock SAP* Procedure

1) Adding Parameter

Go to USR/SAP/SID/SYS/Profile  here you have to add the parameter as follows

Login/no_automatic_user_sapstar =0 then save it

2) Deleting password

open Sql management Studio and write the query as follows to delete

delete from serverid.USR02 where BNAME ='SAP*' and MANDT='Client id'

Example

delete from SID.USR02  where BNAME =’SAP*’ and  MANDT =’000’

then execute

3) update password

Update serverid.USR02 set UFLAG =0 where BNAME='SAP*' and MANDT = client no

Example

Update SID.USR02 set UFLAG =0  where BNAME =’SAP*’ and  MANDT =000

Thanks

Ravi

[Former Member]

Problem solved.

I put the line login/no_automatic_user_sapstar=0 in instance profile instead of Default profile.

Thank you all