Skip to Content
author's profile photo Former Member
Former Member

User SAP* Lock in client

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2007 at 07:24 AM

    Hi kumar,

    Refer this link

    client-001--sap-and-ddic-locked

    Regards

    vijay

    (Note: points always encourage me reply!! )

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2007 at 12:29 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.