Skip Navigation

Configure the
Microsoft SQL Server
database for the
Connect
service

Complete this task the first time that you configure the
Connect
service to specify the
Microsoft SQL Server
location and database for the
Connect
service.
  1. In the
    BlackBerry Enterprise Mobility Server Dashboard
    , under
    BlackBerry Services Configuration
    , click
    Connect
    .
  2. Click
    Service Account
    , enter the
    BEMS
    service account credentials, and click
    Save
    .
  3. Click
    Database
    .
  4. Enter the
    Microsoft SQL Server
    and database name.
  5. In the
    Authentication Type
    drop-down list, select one of the following:
    • If you select
      Windows Authentication
      , the
      Connect
      service uses the
      Windows
      credentials access the
      Microsoft SQL Server
      database.
    • If you select
      SQL Server Login
      , type the username and password used to access the
      Microsoft SQL Server
      database.
  6. 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: 
    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, in the
    Additional Properties
    field, type
    MultiSubnetFailover=true
    . Separate additional properties with a semicolon (;).
  7. Click
    Test
    to verify the connection with the database.
  8. Click
    Save
    .