30.6 Configuring the ZENworks Server to Point to the New MS SQL Database Containing Data Moved from Another MS SQL Database

If you move the data from one MS SQL database to another MS SQL database, the Windows or Linux ZENworks Server must be configured to point to the new MS SQL database.

The following sections provide detailed information:

30.6.1 Preparing to Move the Data

Before configuring the server to point the new MS SQL database, do the following:

  • Make sure that the ZENworks Server is configured to an MS SQL database. The database can be installed on the ZENworks Server or on a different device. Assume that the device that currently host the MS SQL database is called MSDB1.

  • Make sure that you have another Windows device with an MS SQL database installed. Assume that this device is called MSDB2. For more information on how to install an MS SQL database, see Installing an External ZENworks Database in the ZENworks 11 Server Installation Guide.

  • Stop all the ZENworks Services on all the ZENworks Servers in the Management Zone.

    • On Windows: Do the following

      1. Execute the following command at the server prompt:

        novell-zenworks-configure -c Start

      2. Enter the number next to the Stop action.

    • On Linux: Do the following:

      1. Execute the following command at the server prompt:

        /opt/novell/zenworks/bin/novell-zenworks-configure -c Start

      2. Enter the number next to the Stop action.

  • Move the data from MSDB1 to MSDB2. For more information about moving the data, see the MS SQL database documentation.

30.6.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 (located in ZENworks_installation_path\conf\datamodel on Windows and in /etc/opt/novell/zenworks/datamodel on Linux) to do the following:

    • Make sure 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.

  2. Restart the ZENworks services.

    • On Windows: Do the following:

      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 all the ZENworks Services on all the other ZENworks Servers in the Management Zone.

    • On Windows: Do the following

      1. Execute the following command at the server prompt:

        novell-zenworks-configure -c Start

      2. Enter the number next to the Start action.

    • On Linux: Do the following:

      1. Execute the following command at the server prompt:

        /opt/novell/zenworks/bin/novell-zenworks-configure -c Start

      2. Enter the number next to the Start action.