User SAP* Lock in client

[Former Member]

Hi

How i unlock user Sap* in client. I am wok on MSSQL Server 2005 and Window. I have also change parameter login/no_automatic_user_sapstar = 0.

But system give message sap* is locked. Please tell me how i unlock this via database level.What is process through USR02 Table.

Thanks

Kumar

[Former Member]

Unlock the user with any other user you have in that client via SU01.

If you dont have a user account delete the user from the table USR02. The systax above is for oracle, not SQL., so ignore the first part and simply open up a querry window.

[Former Member]

Hi kumar,

Refer this link

Regards

vijay

(Note: points always encourage me reply!! )