Configure the Microsoft SQL Server database for the Connect service
- In the BlackBerry Enterprise Mobility Server Dashboard, under BlackBerry Services Configuration, click Connect.
- Click Service Account, enter the BEMS service account credentials, and click Save.
- Click Database.
- Enter the Microsoft SQL Server and database name.
- 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.
- 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: 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.
- 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.
- 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 (;).
- Click Test to verify the connection with the database.
- Click Save.