How to unlock SAP* user in Ms SQL database

Whenever SAP* user got locked (mainly in 000 Client), in most cases we are supposed to unlock the SAP* User in database level.

Before logging into SAP system using SAP* user, be aware whether the parameter login/no_automatic_user_sapstar is set to value 0 (Zero).

If the value of parameter login/no_automatic_user_sapstar is set to 1, it will not allow the SAP* user to login to the SAP system.

Steps to Unlock the SAP* user (DB level)

1. Try login SAP system with SAP* user

SAP* user got locked due to too many attempts with wrong password.

2. Login to Ms SQL Database,

3. Execute the query:

select * from er1.USR02

The status of the user is locked/Not locked is identified in the field UFLAG.

In the above screenshot, value of UFLAG is 128 for the user SAP*, means the SAP* user got locked.

Note : If the value of UFLAG results in a Non-Zero value, then it means that the user got locked.

4. Execute the query:

select * from er1.USR02 where BNAME=‘SAP*’ and MANDT=‘000’ to find the details of only SAP* user.

For Unlocking the user, the value of UFLAG should be set to 0 (Zero).

5. Execute the query:

update er1.USR02 set UFLAG=‘0’ where BNAME=‘SAP*’ and MANDT=‘000’

6. Now execute the query :

select * from er1.USR02 where BNAME=‘SAP*’ and MANDT=‘000’

Now the Value of UFLAG has been altered to 0.

SAP* user has been unlocked.

==========================================================

14 Comments

You must be Logged on to comment or reply to a post.

Eduardo Rezende September 2, 2013 at 4:29 pm

Hi Dino,

Nice document. Very detailed!

Regards,

Eduardo

like (0)
1. Dino Shiju Post authorSeptember 3, 2013 at 4:25 am
  
  Thanks a Lot Eduardo Rezende 🙂
  
  Warm Regards,
  
  Dino
  
  like (0)
S Sriram September 5, 2013 at 12:52 pm

Hi

Good one 😎

Thanks

Ram

like (0)
Nicolas VANDER AUWERA September 9, 2013 at 12:40 pm

Bookmarked and liked !

like (0)
Mohammad Sabry November 3, 2013 at 4:58 am

thanks Dino, you did a grate Job 😉

like (0)
Aravind Thirunavukkarasu March 27, 2015 at 12:18 pm

kindly confirm if i follow the above procedure do i need to restart the system.

like (0)
1. Gaurav Rana March 27, 2015 at 12:21 pm
  
  Hi Aravind,
  
  No need to restart the system.
  
  like (0)
  1. Aravind Thirunavukkarasu March 27, 2015 at 12:24 pm
    
    thanks gaurav
    
    like (0)
Kavitha Rajan April 1, 2015 at 4:05 pm

Thanks for sharing the procedure

like (0)
Oluwaseye Adeboye April 12, 2015 at 12:09 am

eXcellent documentation, thanks a lot.

like (0)
Javed Khan June 12, 2015 at 5:19 pm

Can any1 explain for Oracle database in Windows environment..???

Regards,

Javed

like (0)
1. Luis Darui June 12, 2015 at 9:24 pm
  
  Hi Javed, you should seek similar information in the following space:
  
  SAP on Oracle
  
  I don’t work with Oracle but it seems to me that the tables are the same, so you would need to use sqlplus or other Oracle tool to connect to DB.
  
  like (0)
  1. Joshua Lacroix June 15, 2015 at 5:03 pm
    
    Google it, Ive done it tons of times on Oracle, its very common on many sites.
    
    like (0)
Arun Jacob January 25, 2016 at 4:19 am

Thanks Dino, this was really helpful.

like (0)