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 SQL Anywhere or Oracle: After you log into SQL Anywhere or 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 Windows 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;
On Windows: C:\Program Files (x86)\Novell\ZENworks\conf\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 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.