Skip Navigation
  1. BlackBerry Docs
  2. BlackBerry Enterprise Mobility Server 3.8
  3. Configuring the BlackBerry Docs service
  4. Steps to configure the Docs service in an on-premises environment
  5. Configure the database connection for the BlackBerry Docs service

Configure the database connection for the
BlackBerry Docs
 service

When you configure your
Microsoft SQL Server
 database for the
Docs
 service, 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.
  4. Enter the database name.
  5. In the
    Authentication Type
     drop-down list, select one of the following:
    • If you want to use the credentials of the
      Windows
       service account that was configured for the
      BlackBerry Connect
       service, click
      Windows Authentication
      .
    • If you want to use a
      Microsoft SQL Server
       account, click
      SQL Server Login
       and enter the
      SQL Server
       account username and password.
  6. 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, add the property
    MultiSubnetFailover=true
    .
  7. Click
    Test
     to verify the connection with the
    Microsoft SQL Server
     database.
  8. Click
    Save
    .