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