29.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:

29.6.1 Preparing to Move the Data

Before configuring the ZENworks 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 10 Asset Management Installation Guide.

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

  • 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. Specify the number next to the Stop action, then press Enter.

    • On Linux: Do the following:

      1. Execute the following command at the server prompt:

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

      2. Specify the number next to the Stop action, then press Enter.

29.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 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. Specify the number next to the Start action, then press Enter.

    • On Linux: Do the following:

      1. Execute the following command at the server prompt:

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

      2. Specify the number next to the Start action, then press Enter.

  4. (Conditional) If you have installed ZENworks Reporting Server, continue with Section 29.6.3, Configuring ZENworks Reporting Server to Point to the New MS SQL Database.

29.6.3 Configuring ZENworks Reporting Server to Point to the New MS SQL Database

Do the following to point ZENworks Reporting Server to the new database (MSDB2):

Configuring ZENworks Reporting Server to Point to the New MS SQL Database on Windows

  1. Ensure that the data has been moved to MSDB2 and the ZENworks Server points to MSDB2 as explained in Section 29.6.2, Configuring the ZENworks Server to Point to the New MS SQL Database.

  2. On the ZENworks Server, click Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC) on a 32-bit device, and click Start > Programs > ZENworks Reporting Server > ZENworks Reporting Server > 32-bit Data Sources (ODBC) on a 64-bit device.

  3. Click System DSN.

  4. Click ZENworks Database > Configure.

  5. In the Which SQL Server do you want to connect to field, specify the IP address of the new database (MSDB2), then click Next.

  6. Specify the login ID and the password to connect to MSDB2, then click Next.

  7. Click Next > Finish.

  8. Click Test Data Source to verify the connection to the new database.

    A message appears indicating that the connection is successful.

  9. Click OK twice.

ZENworks Reporting Server now points to the new database.

Configuring ZENworks Reporting Server to Point to the New MS SQL Database on Linux

  1. Ensure that the data has been moved to point to the new MS SQL database as explained in Section 29.6.2, Configuring the ZENworks Server to Point to the New MS SQL Database.

  2. Edit the /opt/novell/zenworks/share/boe/bobje/odbc.ini file to set the value of IPaddress to the IP address and port number of MSDB2.

  3. Save the file.

  4. Run the novell-zenworks-configure -c UpdateBOE command.

ZENworks Reporting Server now points to the new database.