15.2 Configuring the ZENworks Server to Point to the New MS SQL Database

To configure the ZENworks Server to point to the new database (MSDB2), perform the following tasks on the ZENworks Server:

  1. Edit zdm.xml and edit zenaudit.xml (located in ZENworks_installation_path\conf\datamodel on Windows and in /etc/opt/novell/zenworks/datamodel on Linux) to do the following:

    • Ensure that the value of the Port entry key is the port number on which the MS SQL database is running.

    • Set the value of the Server entry key to the IP address of the MSDB2 device.

    • Set the value of the Database entry key to path of the database directory of the MSDB2 device.

    • If user password of the database is changed, then you must change the password in the dmaccounts.proprities and zenaudit_ dmaccounts.proprities files. (located in ZENworks_installation_path\conf\datamodel on Windows and in /etc/opt/novell/zenworks/datamodel on Linux). It is recommended that do not use the SA user for ZENworks database access.

      username=password

      The password will be encrypted automatically when you restart the ZENworks services.

  2. Restart the ZENworks services.

    • On Windows:

      1. From the Windows desktop Start menu, click Settings > Control Panel.

      2. Double-click Administrative Tools > Services.

      3. Start the following services: Novell ZENworks Server, Novell ZENworks Services Monitor, and Novell ZENworks Agent Service.

    • On Linux: At the console prompt, enter the following commands:

      • /etc/init.d/novell-zenmntr restart

      • /etc/init.d/novell-zenserver restart

      • /etc/init.d/novell-zenloader restart

  3. Start the ZENworks Services on all other ZENworks Servers in the Management Zone. For more information, see Step 2.c in the Section 3.1, Backing Up the Embedded Sybase SQL Anywhere Database on a Windows or Linux Server.