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

[Former Member]

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

[Former Member]

Hi!

Execute this query on SQL server and send the result.

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

[Former Member]

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

[Former Member]

Hi

I don't think you can retrieve the password with any SQL because it's stored with Encryption.

You can check the following links:

Regards

[Former Member]

Hello Darpal Thiarha,

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

Thats the better way.

Thanks,

Srujal Patel

[Former Member]

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