Configure the Microsoft SQL
Server database for the Connect service
Microsoft SQL
Server
database for the Connect
serviceComplete this task the first time that you configure the
Connect
service to specify the Microsoft SQL
Server
location and database for the Connect
service.- In theBlackBerry Enterprise Mobility Server Dashboard, underBlackBerry Services Configuration, clickConnect.
- ClickService Account, enter theBEMSservice account credentials, and clickSave.
- ClickDatabase.
- Enter theMicrosoft SQL Serverand database name.
- In theAuthentication Typedrop-down list, select one of the following:
- If you selectWindows Authentication, theConnectservice uses theWindowscredentials access theMicrosoft SQL Serverdatabase.
- If you selectSQL Server Login, type the username and password used to access theMicrosoft SQL Serverdatabase.
- By default, the "encrypt=false" property is prepopulated in the Additional properties field, so data between theBEMSand theSQL Serveris 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 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, in theAdditional Propertiesfield, typeMultiSubnetFailover=true. Separate additional properties with a semicolon (;). - ClickTestto verify the connection with the database.
- ClickSave.