5.2 Configuring the External ZENworks Database

This section provides instructions for configuring the ZENworks database by running the ZENworks installation program on the database server. This method is required if you are using an external PostgreSQL database. For other databases, this method is useful if your ZENworks administrator and database administrator are not the same person.

Ensure that the server where you plan to install the external database fulfills the requirements in Database Requirements in the ZENworks 2020 Update 3 System Requirements and Prerequisites for External Databases.

  1. On the server where you have installed the external database, insert the ZENworks installation DVD or mount the ZENworks ISO.

    IMPORTANT:If you have not already burned the ZENworks ISO image to a DVD, you need to do so before beginning the installation. Do not extract the ISO image and use it to install.

    If the DVD auto-runs the database installation program, exit the program.

    Enter the following at the command prompt on the external database server:

    DVD_drive:\setup.exe -c

    or

    If ZENworks has already been installed on a device, and if you want to use the device to configure another instance of the ZENworks database (on the same device or on another device) by using the external database installation program, run the following command:

    DVD_drive:\setup.exe -c --zcminstall

  2. On the Select ZENworks Database page, select one of the following:

    • Select ZENworks Database

    • Select Audit Database

    • Select both ZENworks Database and Audit Database

      NOTE:When the ZENworks Database and Audit Database option is selected, you need to create the ZENworks database schema first and then create the audit database schema.

    The supported combinations of ZENworks and Audit database are shown below:

    ZENworks Database

    Audit Database

    Embedded PostgreSQL

    • Embedded PostgreSQL (Default)

    • External PostgreSQL

    External PostgreSQL

    • External PostgreSQL (Default)

    • Embedded PostgreSQL

    Microsoft SQL Server

    Microsoft SQL Server

    Oracle

    Oracle

  3. On the Select Database type page, select one of the following, then click Next:

    • PostgreSQL: Creates a ZENworks database schema on a PostgreSQL Server.

    • Microsoft SQL Server: Creates a ZENworks database schema on a Microsoft SQL Server.

    • Oracle: Specifies a user schema that you can use to set up an external Oracle database schema for use with ZENworks.

    IMPORTANT:The server hosting the database must have time synchronization with all of the Primary Servers in the Management Zone.

  4. Refer to the following section for details on the information that you need to know (you can also click the Help button for similar information):

5.2.1 PostgreSQL Database Information

Installation Information

Explanation

PostgreSQL Server Configuration

Specify the port used by the PostgreSQL database server. By default, port 54327 is used for the ZENworks database and port 54327 is used for the Audit database. Change the default port number if you have a conflict.

PostgreSQL Access Configuration

Defaults are provided for some of the information, which you can change as necessary:

  • Server Address: Specify DNS or IP address of the database server.

  • Port: Specify the port number used by the PostgreSQL database.

  • Username: Specify PostgreSQL administrator user name.

  • Password: Specify PostgreSQL administrator password.

Database File Location

Specify the path where you want to create the ZENworks PostgreSQL database file. By default, the installation program creates the drive:\microfocus\zenworks directory, which you can change. A \database directory is appended to the default directory.

For example, the default path is drive:\microfocus\zenworks\database.

The default path for the Audit database is the same as for the ZENworks database.

Review Database Information

Review the database configuration information.

The Server Address field displays the IP address configured in the hosts file. This does not impact the database installation.

The database driver information is automatically detected by the ZENworks database installer.

Review SQL Scripts

Review the SQL scripts to be executed during the database creation.

5.2.2 MS SQL Database Information

Installation Information

Explanation

External Database Server Configuration

The database server must have an MS SQL database installed. Defaults are provided for some of this information, which can be changed as necessary:

  • Server Address: We recommend that you identify the server by its DNS name rather than its IP address, to be in sync with certificates that are signed with DNS names.

    IMPORTANT:If you change your database server’s IP address or DNS name at a later time, ensure that your corporate DNS server is updated with this change to keep DNS for the database server in sync.

  • Port: Specify the port used by the MS SQL database server. The default is port 1433. Change the default port number if you have a conflict.

  • Named instance: This is the name of the SQL server instance that is hosting the existing ZENworks database. You must specify the named instance if you want it to be something other than the default of mssqlserver.

  • Database Name: Specify the name of the existing MS SQL database on which you want to host the ZENworks database. This option is available only for an existing database.

  • Username: Specify the user who can modify the database. The user must have read/write permissions to modify the database.

    NOTE:Ensure that the special character ' is not part of the database name.

    For Windows authentication, provide a user name on the current device or in the domain.

    IMPORTANT:The installer wizard continues without validating the credentials; therefore, ensure that the correct credentials are provided. Else, the installation might fail towards the end of the installation process.

    For SQL authentication, provide a user name that matches that of a valid SQL user.

  • Password: Type the password of the user specified in the Username field.

  • Domain: It is important to know whether you installed the SQL Server by using SQL authentication, Windows authentication, or mixed. Ensure that you select the option that coincides with your SQL Server options; otherwise, the authentication will fail.

    If you are using MS SQL with Windows Authentication, the host name (not FQDN) of Active Directory is used.

    If you are using Windows authentication, specify the Windows domain where the user you specified in the Username field exists. If you are not using a Windows domain, specify the server’s short name.

External Database Configuration > Database Location (applicable only for the new database)

Specify the path of the existing MS SQL database file on the SQL server. By default, it is c:\database.

NOTE:Ensure that the specified path exists on the device hosting the database before the installation starts.

Review Database Information

Review the database configuration information.

Review SQL Scripts

Review the SQL scripts to be executed during the creation of the database. You can only view the scripts.

5.2.3 Oracle Database Information

Installation Information

Explanation

Oracle User Schema Options

During ZENworks installation, you can select to create a new user schema or specify an existing schema that resides on a server in your network. To use an existing user schema, the user schema must be created separately by using the ZENworks database installation method (setup.exe -c).

ZENworks requires tablespaces to be created on the Oracle database. A tablespace can be created either by ZENworks or Database Administrator. For an existing user schema, specify the information for the tablespace that is already created by using ZENworks database installation method.

Oracle Server information

The database server must have an Oracle database installed. Defaults are provided for some of this information, which can be changed as necessary:

  • Server Address: We recommend that you identify the server by its DNS name rather than its IP address, to be in sync with certificates that are signed with DNS names.

    IMPORTANT:If change your database server’s IP address or DNS name at a later time, ensure that your corporate DNS server is updated with this change to keep DNS for the database server in sync.

  • Port: Specify the port used by the database server. The default is port 1521. Change the default port number if you have a conflict.

  • Service Name: For a new user schema, specify the instance name (SID) on which the user schema is to be created. For an existing user schema, specify the instance name (SID) on which the user schema has been created.

Oracle Administrator (applicable only for the new user schema)

  • Username: Specify the user who can modify the database. The user must have read/write permissions to modify the database.

  • Password: Specify the password to be used to the access the database.

Oracle Access User

  • Username: For a new user schema, specify a name. For an existing user schema, specify the name of the user schema that already exists in the Oracle database.

  • Password: For a new user schema, specify a password to be used to access the database. For an existing user schema, specify the password used to access the user schema that already exists in the Oracle database.

  • Tablespace: For a new user schema, select one of the following tablespace options:

    • Let ZENworks create the tablespace: Select this if you want ZENworks to create the tablespace.

    • Let DBA create the tablespace: Select this if you want your database administrator to create the tablespace.

      The following details are required to create a new tablespace:

      IMPORTANT:If you are using Automatic Storage Management(ASM) or some other Disk storage, select Let DBA create the tablespace.

      • Tablespace name for Tables (Ensure Tablespace name is unique and it should start with [a-z] | [A-Z].Oracle tablespace naming convention has to be followed.)

      • Tablespace name for Indexes (Ensure Tablespace name is unique and it should start with [a-z] | [A-Z].Oracle tablespace naming convention has to be followed.)

      • DBF File location for Tables

      • DBF File location for Indexes (The specified physical path of the DBF file should be an existing path. The file name must have the .dbf extension.)

    For an existing user schema, specify the following information:

    • Tablespace name for Tables: Specify the tablespace name for the tables that are associated with the existing database user specified in the Username field.

    • Tablespace name for Indexes: Specify the tablespace name for the indexes that are associated with the existing database user specified in the Username field.

Review Database Information

Review the database configuration information.

Review SQL Scripts

Review the SQL scripts to be executed during the creation of the database.