Configure the database connection for the BlackBerry Docs service
BlackBerry Docs
serviceWhen 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.- In theBlackBerry Enterprise Mobility Server Dashboard, underBlackBerry Services Configuration, clickDocs.
- ClickDatabase.
- Enter theMicrosoft SQL Servername and password.
- In theAuthentication Typedrop-down list, select one of the following:
- If you selectWindows Authentication, the credentials for theWindowsservice account configured for theBlackBerry Connectservice are used.
- If you selectSQL Server Login, enter theMicrosoft SQL Serverusername and password.
- 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 betweenBEMSand theSQL Serveris 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 betweenBEMSand theSQL Server, it may cause higher than normal CPU usage.
- Import the CA certificate that is signing yourSQL Servercertificate into theJavacertificate 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, typeMultiSubnetFailover=true. - ClickTestto verify the connection with theMicrosoft SQL Serverdatabase.
- ClickSave.
- Restart theGood Technology Common Servicesservice.