Skip to Content
avatar image
Former Member

Retrieve Password for "Manager" User on SAP Business One Database

Hi

I would like to logon to a SAP B1 database , however I do not know the manager password and have tried the usual passwords.

Does anyone know the query I can use in SQL Server , to retrieve the manager password please.

Thanks in advance

D

Edited by: Darpal Thiarha on Nov 19, 2011 1:35 AM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Nov 19, 2011 at 02:23 AM

    Hello,

    First time user name and password id manager and manager.

    and if you have important info on that database then

    make a new company and copy the password column value form OUSR table form SQL and paste in Old company it will work same manager and manager.

    Thanks

    Manvendra Singh NIranjan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 19, 2011 at 07:05 AM

    Hello Darpal Thiarha,

    You have to logein with other Professional User and change manager password.

    Thats the better way.

    Thanks,

    Srujal Patel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 19, 2011 at 09:53 AM

    Hi Darpal Thiarha,

    There are two ways to retrieve the password as suggested by Mr. Manvender & Mr. Suraj. i am just elaborating these two ways in detail:-

    1. In case, if you have any other Super User in that company, then login with that user and then you are able to change the password of manager user.

    2. If you don't have any other super user in the same company, then create a new company and open it using credentials username - "manager" & password "manager". The company opens and then a pop up window open asking to enter new password. Enter new password and remember it.

    After that go to sql and write a query " select * from ousr " using your new company and copy password of manager user.

    Then open a new query window and select the company of which you forgot the password and use this query " update OUSR set password = ' paste the new password here which you copy from the new company database in single quotes ' where userid = '1' ". This query will update the new password for the user manager and you will able to login in that company using new password.

    Hope it works for you.

    Regards

    ARYA

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 20, 2011 at 07:03 PM

    Sorry

    I forgot to say.

    I cannot create a new company database ( Not allowed too)

    Thanks, but had already tried the usual Manager , manager password and other usual passwords

    But, I do remember once using an query in sql servr mgt , where you can retireve passwords which have been fogotten.

    Just cant recall the query ;-(

    Thanks for help

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 21, 2011 at 03:56 AM

    Hi!

    Execute this query on SQL server and send the result.

    Select Userid,Password,user_code,U_name,Superuser,Lastpwds from OUSR 
    

    Add comment
    10|10000 characters needed characters exceeded