cancel
Showing results for 
Search instead for 
Did you mean: 

SAP* login failed

manoj_nayak2
Participant
0 Kudos

Hi,

i am unable to login through SAP* in XXX client.

ECC -6.0

DB - MS- SQL

Password logon no longer possible- too many failed attempts .

can anybody tell the reason.

manoj

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

hi manoj,

SAP has parameter "login/fails_to_user_lock" which going to lock user after several failed attempt. By default, user which input wrong password for 12 attempt will be lock.

You can unlock using DDIC user or another SAP administrator right user (user which has administrator rights).

ardhian

http://ardhian.kioslinux.com

http://sapbasis.wordpress.com

Former Member
0 Kudos

Hello,

This sounds like the SAP* user got locked.

But don't worry, as long as you're the owner and administrator of the system, there's (at least) this possible solution:

1) Log in to your database server (for simplicity I'll assume you're using Microsoft SQL Server) with an administrative user (sa or some other administrator).

2) run this sql script:

use <DBSID>

go

(the Database on which your sap system is installed, usually the same as your SAPSID)

setuser <sapsid>

go

(your SAPSID in all lower case letters - should be the owner of all sap tables). If this fails, don't worry, there's also the option that the owner is dbo, which means you can skip this step.

delete from [USR02] where [BNAME] = 'SAP*' and MANDT = 'XXX'

go

(XXX stands for the client where your SAP* user is locked)

3) Now make sure that your SAP profile parameter login/no_automatic_user_sapstar is set to 0 (don't log in to the system, just take a look at the file).

If it's set to 1, you'll have to edit the file and change it to 0, and then restart the SAP system.

After you do that, continue to the next step:

4) Log in to your client where you SAP* user was locked, now with the user SAP* and password PASS. This should work, and if not, perhaps you'll get an error message. After logged in, you can go to transaction SU01 and create the SAP* user again.

Be sure that after you recreate the user, you (as soon as possible) revert the login/no_automatic_user_sapstart parameter back to 1 for security reasons.

Regards,

Daniel

former_member186775
Contributor
0 Kudos

Hello,

It would have been better if you gave more information

well try to login into that client with superuser like DDIC

and try to unlock and if you forgot the password reset the

password in SU01,If its an IDES system we can get through

other means too. Is it IDES or DEV system?is it a new

client u r trying to login??.

Regards,

Manjula.

manoj_nayak2
Participant
0 Kudos

hi manjula,

but for your kind information SAP* is the defult user and it is a kernel lebel user.