Skip to Content
Author's profile photo KENAN JADDENE

Change the SA SQL Account Password for SAP Business One 9.2

Go to SQL Server Management Studio (SSMS),

Enter your administrating credentials to connect to the server,

Under the Object Explorer > Security > Logins > sa (double click on it)

A new pop-up window will appear “Login Properties – sa” > General > enter the new password and confirm it,

Click “ok” and your changes is saved,

Now we should go to the SLD – System Landscape Directory to associate this password with the existed databases in the server,

From SAP Business One Service Manager > License Manager > Settings, a new window will appear to you “General Settings” > Configure Security

Enter your credentials to access the
System Landscape Directory – SLD

Enter the (B1SiteUser) user credentials,

Inside the System Landscape Directory – SLD, mark out the Server Name, and click Edit button, then enter the new SA Database User Password,

We’re all set ?

 

hope this one helpful,

to download the documentation:

Change the SA SQL Account Password for SAP Business One 9.2

for your suggestions and inquiries, please feel free to reach me out,

KENAN JADDENY

Assigned tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Richard Whight
      Richard Whight

      I'd probably say don't ever use the sa password. It's a bad practice. Create a specific server login and give it the sysadm server role and use that instead.  Having said this then your process only changes the password for the SAP database and not for the actual SLD service itself (same for B1i). If the SLD was configured to use the sa user and password then the SLD will not be able to read it's own database to then be able to use the credentials you are changing.

      Author's profile photo Paul Vargas
      Paul Vargas

      Does that mean that it is a bad practice to change the password from the SLD as well? Then what would be the best way if you need to change the password of the SQL user?

      Author's profile photo Richard Whight
      Richard Whight

      Hi Paul

      No. By all means the process is good but just to say when installing don't use SA as a login. Create a new SQL Login with the sysadm server role and use that instead.

      Rich