Use system administrator or user with DBA privileges to execute the below commands.
Before changing the password ensure that you shutdown all Primary Servers and Reporting Server.
For Oracle: After you log into Oracle database, run the below SQL statement to change the password for existing user.
ALTER USER <<username>> IDENTIFIED BY <<new password>>
For Microsoft SQL Server: Users with SQL Server authentication, might run the below SQL statement to change the password for existing user.
ALTER LOGIN <<username>> WITH PASSWORD = 'new password' OLD_PASSWORD = 'old password'
Users with authentication, might change the Windows user account password and no changes required in SQL Server.
After changing the database user password, perform the following steps to change the password in all the Primary Servers:
Go to the following path;
/etc/opt/microfocus/zenworks/datamodel
Back up the dmaccounts.properties and zenaudit_dmaccounts.properties files.
Open the dmaccounts.properties and zenaudit_dmaccounts.properties files.
Change the existing password that is in encrypted form.
For example, the existing value is ZENWORKS=@OB@6a7278626bba
and the changed value is ZENWORKS=<<new password>>
Run the microfocus-zenworks-configure -c GenerateOSPProperties command.
Run the microfocus-zenworks-configure -c GenerateContentDatasourceConfigureAction command on all the ZENworks servers.
On all the Primary Servers in the zone, restart the ZENworks services by running the following command: microfocus-zenworks-configure -c Start.
IMPORTANT:Do not encrypt the new password. The new password is encrypted automatically when you restart the ZENworks services.