Skip Navigation

Configure the database connection for the
BlackBerry Docs
service

When you configure your
Microsoft SQL Server
database for
BEMS
-
Docs
, you can use either
Windows
Authentication or SQL Authentication for granting access to the database by
BEMS
. The information is prepopulated with the information entered during installation.
  1. In the
    BlackBerry Enterprise Mobility Server Dashboard
    , under
    BlackBerry Services Configuration
    , click
    Docs
    .
  2. Click
    Database
    .
  3. Enter the
    Microsoft SQL Server
    name and password.
  4. In the
    Authentication Type
    drop-down list, select one of the following:
    • If you select
      Windows Authentication
      , the credentials for the
      Windows
      service account configured for the
      BlackBerry Connect
      service are used.
    • If you select
      SQL Server Login
      , enter the
      Microsoft SQL Server
      username and password.
  5. By default, the encrypt=false property is prepopulated in the Additional properties field during the installation and upgrade process. Existing properties that you have set are retained. Data that is sent between
    BEMS
    and the
    SQL Server
    is not encrypted. If your environment requires data to be encrypted and the TLS certificate to be verified, complete the following steps: 
    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.
    2. Change the encrypt property to true and add trustServerCertificate=false separated by a semicolon (no space before or after the semicolon).
    If your organization uses AlwaysOn support for SQL Server, type
    MultiSubnetFailover=true
    .
  6. Click
    Test
    to verify the connection with the
    Microsoft SQL Server
    database.
  7. Click
    Save
    .
  8. Restart the
    Good Technology Common Services
    service.