Steps to take when security policies require a SQL DBO password change for the ZAM database

Document ID:3005937
Creation Date:07-Mar-2008
Modified Date:27-Apr-2012
- Micro Focus Products:
  ZENworks Asset Management

Environment

Novell ZENworks 7.5 Asset Management - ZAM7.5

Novell ZENworks Asset Management 7 - ZAM7

Situation

Steps to take when security policies require a SQL DBO password change for the ZAM database.

Resolution

If the database owner password in SQL Enterprise Manager has been changed, it is necessary to complete these additional steps to:

1. Update the password in the database

2. Modify the ODBC settings

3. Update the Web console startup file.

1. Update the ZENworks Asset Management Database and Modify the ODBC Settings

Go to the machine where ZENworks Asset Management was initially installed

Browse to the installation directory, by default this is C:\Program Files\Novell\ZENworks\Asset Management\bin

Locate the file named 'UpdateAppConnect.exe' [If this is a StandAlone ZAM installation, this file is not present and it will be necessary to contact Novell Tech Support]

Launch 'UpdateAppConnect.exe' and when prompted with a login box (as if logging into the ZAM Manager, enter the database owner password, in a default installation this account is NCSystem you may have specified a different user.

Enter the new password that you created

Click OK

You should get a message saying the database has been updated

Click OK

2. Update the Webconsole Settings

Novell Support has a tool that allows you to encrypt the password for the WebConsole in thertrsetup.xmlfile. Due to the secure nature of this tool, it is necessary to open a Support Request with Novell Support for this step. If the Support Request is used only for this purpose, it will be credited back.