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:
    Note: 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.