Skip to content

How To change SQL Admin Account (SA Account) password on HyWorks Controller setup

This article describes the steps to be followed for changing or re-configuring SQL Admin (SA) account on HyWorks Controller setup.

Steps

  1. Download the EncryptDecryptAppConfigFile tool from the link below on the Controller.

    https://propalmsnetwork-my.sharepoint.com/:u:/g/personal/manoj_gaikwad_accops_com/EWZXD_Gz94lPknbzkf70CQYBgnkG49sxyqy3acEq3kPLcw?e=MUMb4U

  2. Extract it and open the EncrypDecryptAppConfigFile > Click on the three dots to browse. Go to location C:\Program Files (x86)\Accops\HyWorks\Service\EDC.Service.exe on the Controller machine (use mstsc) and select the EDC service file.

  3. Click on Decrypt Config.

  4. Refer the image below:

  5. From the file that opens, search text 'password'. Copy the value of the password and save it elsewhere for later use.

  6. Connect to HyWorks DB from SQL Server Management Studio with SQL Authentication.

  7. Go to Security > Logins > sa (refer diag below)

  8. Right click on Properties > Change the credentials as shown in screenshot below and save the changes.

  9. Change sa password in edc service file.

  10. Restart SQL express service.

  11. Restart HyWorks Controller service.