20.1 Changing the ZENworks Database User Password

Use system administrator or user with DBA privileges to execute the below commands. For Embedded sybase, zenadmin or zenauditadmin user has DBA privileges.

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'

    User 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:

  1. Go to the following path;

    • On Windows: C:\Program Files (x86)\Novell\ZENworks\conf\datamodel

    • On Linux: /etc/opt/novell/zenworks/datamodel

  2. Back up the dmaccounts.properties and zenaudit_dmaccounts.properties files.

  3. Open the dmaccounts.properties and zenaudit_dmaccounts.properties files.

  4. 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>>

IMPORTANT:Do not encrypt the new password. The new password is encrypted automatically when you restart the ZENworks services.