Skip Navigation

BEMS-Core database

You can access the
BEMS-Core
database screen in the
BEMS
Dashboard (
BEMS
System Settings >
BEMS
Configuration > Database). It is prepopulated with the information that you entered during the
BEMS
software installation and requires a
Microsoft SQL Server
database that is available for
BEMS
. The information includes the
SQL Server
and database name, the authentication type used for
BEMS
to authenticate with the database, and any additional SQL properties that are required in your environment. By default, no changes are required on the Database Configuration screen. However, if you choose to make changes to it, consider the following:
  • You must restart the
    Good Technology Common Services
    service for
    BEMS
    to update any changes.
  • By default, the "encrypt=false" property is prepopulated in the Additional properties field, so data between the
    BEMS
    and the
    SQL Server
    is not encrypted. Existing properties that you have configured are retained.  If your environment requires data to be encrypted, and requires verification of the TLS certificate, complete the following:
    If you enable encryption for all data that is sent between
    BEMS
    and the
    SQL Server
    , it may cause higher than normal CPU usage.
    1. Import the CA certificate that is signing your
      SQL Server
      certificate into the
      Java
      certificate store. For more information, see Import the CA certificate into the
      Java
      certificate store in the Installation content
      .
    2. Change the encrypt property to true and add trustServerCertificate=false separated by a semicolon (no space before or after the semicolon).
  • You can use the information to verify the database settings by clicking the Test button after you install the
    BEMS
    software.