Skip Navigation
  1. BlackBerry Docs
  2. BlackBerry UEM 12.17
  3. Installation and configuration
  4. BlackBerry UEM Installation and Upgrade
  5. Preinstallation and preupgrade tasks
  6. Creating or upgrading a BlackBerry UEM database using CreateDB
  7. CreateDB.properties file

CreateDB.properties file

The following properties apply to the CreateDB.properties file, which contains configuration information for CreateDB.
Property
Description
Database type (
BlackBerry UEM
)
This property specifies the type of database for
BlackBerry UEM
.
By default, the database type property is "configuration.database.ng.type=
SQL_SERVER
".
You should not modify this property as it is a default setting.
Database server name (
BlackBerry UEM
)
This property specifies the database server name that hosts the database to create or upgrade to
BlackBerry UEM
.
By default, the database server name property is "configuration.database.ng.server=
localhost
".
Database instance name (
BlackBerry UEM
)
This property specifies the database instance name to create or upgrade to
BlackBerry UEM
.
If you use a
Microsoft SQL Server
 instance name; by default, the database instance name property is "configuration.database.ng.instance=
Microsoft_SQL_Server_instance name
".
The default
Microsoft SQL Server
 instance name in the CreateDB.properties file is
UEM
.
If you use another
Microsoft SQL Server
 instance name than
UEM
, configure the database instance name property to change
UEM
 to your Microsoft SQL Server instance name.
If you do not use a
Microsoft SQL Server
 named instance, verify that the
Microsoft_SQL_Server_instance name
 value is deleted.
Database port (
BlackBerry UEM
)
This property specifies the port that the database server uses.
If you use a dynamic port configuration, verify that you have no ports listed for this property.
By default, the database port property uses a dynamic port configuration and you do not need to configure this property.
If you use a static port configuration, configure your database port as "configuration.database.ng.port=
static_port_number
".
If you specify a static port, leave the database instance name property blank.
Database name (
BlackBerry UEM
)
This property specifies the name of the
Microsoft SQL Server
 database for
BlackBerry UEM
.
By default, the database name property is "configuration.database.ng.name=
UEM
".
Authentication type (
BlackBerry UEM
)
This property specifies the authentication type as follows:
  • Windows
     authentication - by default, configured as
    INTEGRATED
    in this properties file
  • Microsoft SQL Server
     authentication - can be configured as
    USER
     in this properties file
If you use
Windows
 authentication, by default your authentication type is "configuration.database.ng.authenticationtype=
INTEGRATED
".
If you use
Windows
 authentication, you do not need to configure a user and password in the createdb.properties file.
If you use
Microsoft SQL Server
 authentication, configure your authentication type as "configuration.database.ng.authenticationtype=
USER
".
Username and Password -
Microsoft SQL Server
 authentication (USER) (
BlackBerry UEM
)
If you use
Microsoft SQL Server
 database authentication, these properties specify the username and password for the database account that has database creator permissions.
By default, the username property you configure for
Microsoft SQL Server
 authentication (USER) is "configuration.database.ng.user=
user_name
".
By default, the password property you configure for
Microsoft SQL Server
 authentication (USER) is "configuration.database.ng.password=
password
".