"this system does not let you logon using a password"

[Former Member]

hi all..........

i recently upgrade my kernel ( patch level 71 to 175 )

I started server, work process are running successfully.our system is UP.

While trying to logon ( in to any client & ID ) It's showing an error,

"this system does not let you logon using a password"

I am using sap4.7E ,MS SQL, Windows2003 server.

can any one tell me the why this is happening ?

[former_member190272 · Accepted solution]

Hi ,

If all the users are locked, they can be unlocked by

a)Try this command at ur sql plus query level

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

this will take you to the sqlprompt.

Just execute the earlier commands there.

sqlplus>UPDATE SAP<schema>.usr02 set uflag=0 where mandt=<CLNT NO> and uflag=64; this statement actually unlocks the users of that particular client. So, try for every client in that sap system.

b) You can delete sap* user

Go to cmd prompt.

Sqlplus /nolog

conn /as sysdba

sqlplus>DELETE SAP<SID>.usr02 where mandt='CLIENT.NO' and bname=SAP*;

Note:-

After doing this restart the system. So, that a new user with the name "sap" gets generated with password "pass". Provided the parameter is set .Change profile perameter via RZ10 login/no_automatic_user_sapstar= 0 (Automatic user SAP is permitted).

Reward points if helpful

Thanks

Pankaj Kumar

Message was edited by:

Pankaj Kumar