cancel
Showing results for 
Search instead for 
Did you mean: 

SAP B1 DB Username and DB Password correction .

Former Member
0 Kudos

SAP B1 DB Username and Password.


Dear Gurus,


I am having challenge changing the siteuser password for my client SAP B1 as the data administrator for the company cannot find the database credentials: DB Username and PW used at point of installations.


Kindly help me on how to resolve this problem to enable change the siteuser password and possibly the DB username and password for us to be able to carry out some other need that may arise in the future.


Regards,

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please refer SAP note:

1410560 - How to Recovery B1 Site User Password

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

The note is very helpful but I have tried this before and get stuck at the DB Password as that is not readily available also. I only know the DB user name is SA and the SAP default or advised password SAPB1Admin is not working for it.

How did you think this can be resolve.

Thanks for your swift response.

Best regards,

What other means would I do to retrieve this

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try manager as password.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

manager as password did not also work.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please conform that you have followed same solution as described in above note. There is no need of old password as per SAP note.

Check this link http://scn.sap.com/community/business-one/blog/2013/05/20/how-to-create-a-new-password-b1siteuser-in...

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hello Nagarajan,

Thank you for your response. The note specify the DB username as SA and DB password hypothetically SAPB1Admin but mine is unknown and I seek help to rectify this as we also intend to upgrade from 8.81 to 9.0 version of SBO.

Regards,

Former Member
0 Kudos

Hello Nagarajan,

I cannot continue because I am stucked at the DB Password beauce I don't have it.

Regards,

Former Member
0 Kudos

HI Nagarajan,

I have tried all SAP suggested password to access the DB using sa and yet access is denied. Please what best solution do you think I can adopt to avoid service failure.

Kind Regards,

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please raise ticket to SAP support.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Dear Gurus,

I have been able to overcome the challenge through the below link;

http://sigkillit.com/2013/01/02/recover-sa-password-on-microsoft-sql-server/

I am really grateful for all your responses. Should anyone have this issue, kindly refer to the above link or to me for clarifications.

Kind regards,

Answers (0)