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

Take back up, and edit the zdm.xml and zenaudit.xml files (located in ZENworks_installation_path\conf\datamodel on Windows and in /etc/opt/microfocus/zenworks/datamodel on Linux), and amedatasource.properties (located in /etc/opt/microfocus/zenworks/antimalware on Linux and %ZENSERVER_HOME%\services\antimalware\conf on Windows 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 name or password of the database is changed, then you must change the user name and password in the following locations:
  1. dmaccounts.properties and zenaudit_dmaccounts.properties files. (located in ZENworks_installation_path\conf\datamodel on Windows and in /etc/opt/microfocus/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. dmmappings.properties located in /etc/opt/microfocus/zenworks/datamodel on Linux and ZENworks_installation_path\conf\datamodel on Windows.
    
    If you have changed the ZEN user name, then update readonly and superuser fields. If you have changed audit user, then change the audit field.
Run the microfocus-zenworks-configure -c GenerateOSPProperties command on all the ZENworks Servers.
(Conditional) If you have enabled Kafka, then Run zman server-role-kafka-recreate-connectors -f true command to recreate the Kafka connectors.

For more information, See Server Commands in the ZENworks Command Line Utilities.
Run microfocus-zenworks-configure -c GenerateContentDatasourceConfigureAction on all the ZENworks servers.
Restart the ZENworks services on all other ZENworks Servers in the Management Zone.

On Windows:
1. Execute the following command at the server prompt:
  
  microfocus-zenworks-configure -c Start
2. Enter the number next to the Start action.
On Linux:
1. Execute the following command at the server prompt:
  
  /opt/microfocus/zenworks/bin/microfocus-zenworks-configure -c Start
2. Enter the number next to the Start action.