Installation guide

System Requirements 21
1.4 Database Requirements
If you choose to use a database for the ZENworks database other than the embedded Sybase SQL
Anywhere database that is available as the default for ZENworks 11 , the other database must meet
the following requirements:
Table 1-6 Database Requirements
13331 Used by the zmgpreboot policy, but
will not work across firewall
because it opens random UDP port
for each PXE device.
The zmgpreboot policy is used only
with ZENworks Configuration
Management.
Item Requirements Additional Details
Item Requirement
Database Version
Database Hostname The database hostname should be resolvable by the Domain Name Server
Service
TCP ports The server must allow Primary Server communication on the database port.
For MS SQL, make sure to configure static ports for the database server.
The default ports are:
 1433 for MS SQL
 2638 for Sybase SQL
 1521 for Oracle
IMPORTANT: You can change the default port number if you have a conflict.
However, you must make sure that the port is opened for the Primary Server to
talk to the database.
UDP Ports 1434 for MS SQL (If ZENworks uses named instance of the database)
WAN consideration Primary Servers and the ZENworks database must reside on the same network
segment. Primary Servers cannot write across a WAN to the ZENworks
database.
Default Character Set For Sybase, the UTF-8 character set is required.
For MS SQL, ZENworks Configuration Management does not require any
specific character set. ZENworks Configuration Management supports all
character sets supported by MS SQL.
For Oracle, the NLS_CHARACTERSET parameter must be set to AL32UTF8
and the NLS_NCHAR_CHARACTERSET parameter must be set to
AL16UTF16.
Collation ZENworks 11 Configuration Management is not supported with a case-
sensitive instance of the MS SQL database. Hence, you must make sure that
the database is case insensitive before setting it up.