8.2 Performing the External ZENworks Database Installation

This section provides instructions for installing the ZENworks database by running the ZENworks installation program on the database server. This method is required if you are using a remote OEM Sybase database. For other databases, this method is useful if your ZENworks administrator and database administrator are not the same person.You can also install your external ZENworks database when you install the ZENworks Primary Server software on the target Windows server. If you want to use this method, skip this section and go to Section 9.0, Installing a ZENworks Primary Server on Windows.

Ensure that the server where you plan to install the external database fulfills the requirements in Section 2.0, Database Requirements and Prerequisites for External Databases.

  1. On the server where you want to install the external database, insert the Novell ZENworks 2017 installation DVD.

    IMPORTANT:If you have not already burned the ZENworks 2017 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 2017 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 first and then create the audit database.

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

    ZENworks Database

    Audit Database

    OEM Sybase SQL Anywhere

    • OEM Sybase SQL Anywhere (Default)

    • External Sybase SQL Anywhere

    External Sybase SQL Anywhere

    • External Sybase SQL Anywhere (Default)

    • OEM Sybase SQL Anywhere

    Microsoft SQL Server

    Microsoft SQL Server

    Oracle

    Oracle

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

    • OEM Sybase SQL Anywhere: Installs the default Sybase database for ZENworks. It is configured as a service, the database user is created, and the required tables for the Primary Server are established.

      You must also select the Remote Sybase SQL Anywhere option during installation of the Primary Server.

    • External Sybase SQL Anywhere: Sets up an existing Sybase database for writing ZENworks information to it.

    • Microsoft SQL Server: Creates a ZENworks database 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 information for details on the installation data that you need to know (you can also click the Help button for similar information):

8.2.1 OEM Sybase SQL Anywhere Database Installation Information

Installation Information

Explanation

Sybase Database Installation

Specify the path where you want to install the OEM copy of the Sybase SQL Anywhere database software. On the target Windows server, only the drives that are currently mapped on the server are available.

The default path is drive:\novell\zenworks, which you can change. The installation program creates the \novell\zenworks directory for the installation of Sybase.

Sybase Installation Path

Specify the path where you want to copy the Sybase installation file. The default path is: drive:\Program Files(x86)\Novell\ZENworks.

Sybase Server Configuration

Specify the port used by the Sybase SQL Anywhere database server. By default, port 2638 is used for the ZENworks database and port 2639 is used for the Audit database. Change the default port number if you have a conflict.

Sybase Access Configuration

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

  • Database Name: Specify a name for the database to be created. Do not use zenworks as the database name.

  • Username: Specify a name to create a new user who can access the database.

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

  • Database Server Name: Specify a name for the Sybase SQL Anywhere database server.

Database File Location

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

For example, the default path is drive:\novell\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 hosts file is located in the c:\windows\system32\drivers\etc directory.

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.

Review Database Creation Command

Review the commands used to create the database.

NOTE:

Ensure that the ports used for ZENworks database and Audit database are included in firewall exception list. Run the following command:

netsh firewall set prtopening protocol = All port = <port number> name = <port name> mode = enable

Where:

  • port number: By default it is 2638 for ZENworks and 2639 for Audit or any alternate port number that is configured. This command has to be executed separately for ZENworks database port and Audit database port.

  • port name: Specify the name used for the port.For example, ZENworks database port.

net start mpsSvc

8.2.2 External Sybase SQL Anywhere Database Installation Information

Installation Information

Explanation

Sybase Server Configuration

  • Server name: 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 Sybase SQL Anywhere database server. The default is port 2638. For the Audit database, the default is port 2639. Change the default port number if you have a conflict.

Sybase Access Configuration

This server must have a Sybase SQL Anywhere database installed. Defaults are provided for some of this information, which can be changed as necessary:

  • Database Name: Specify the name of the existing database

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

  • Password: Specify the password of an existing user with read/write permissions to the database.

  • Database Server Name: Specify the name of your Sybase SQL Anywhere database server.

Review Database Information

Review the database configuration information.

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

Review SQL Scripts

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

Review Database Creation Commands

Review the database commands used to create the database.

8.2.3 MS SQL Database Installation 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.

8.2.4 Oracle Database Installation 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.