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 theGood Technology Common Servicesservice forBEMSto update any changes.
- By default, the "encrypt=false" property is prepopulated in the Additional properties field, so data between theBEMSand theSQL Serveris 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 betweenBEMSand theSQL Server, it may cause higher than normal CPU usage.
- Import the CA certificate that is signing yourSQL Servercertificate into theJavacertificate store. For more information, see Import the CA certificate into theJavacertificate store in the Installation content.
- 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 theBEMSsoftware.