Skip Navigation
  1. BlackBerry Docs
  2. BlackBerry Enterprise Mobility Server 3.8
  3. BEMS Installation Guide
  4. Preinstallation and preupgrade requirements for on-premises BEMS
  5. Configuring connections for the BEMS databases
  6. Create the BEMS services databases

Create the
BEMS
 services databases

Depending on the configuration of your environment (for example, you plan to install all the
BEMS
 services), you must create one or more
Microsoft SQL Server
 databases.
Verify that the
Microsoft SQL Server
 account or the
BEMS
Windows
 service account has db_owner privileges to the databases. For more information, see KB 42661.
The following table is an example of a small deployment that has all of the
BEMS
 services installed on one server. For an example of a large and small deployment that has all of the
BEMS
 services installed on one server, see Example of a small BEMS deployment.
Services
Databases
All BEMS services on the same server
  • Create a blank SQL database for the
    BlackBerry
     Push Notifications service and call it "BEMS_Core".
  • Create a blank SQL database for the
    Connect
     service and call it "BEMS_Connect."
  • Create a blank database for the Docs service and call it "BEMS_Docs."
If this is the first server in the
BEMS
 cluster, create the databases. If this is an additional server for the same
BEMS
 cluster, new databases are not required. Record the existing database names for the
BEMS
 services.
The following table is an example of a large deployment that has the
BEMS
 services installed on separate servers. When you create a separate database for each service, you create a new cluster for that service. The push notifications are included in the Core database. If you create separate databases, select the appropriate database for the service. For an example of a large deployment that has the
BEMS
 services installed on separate servers, see Example of a large BEMS deployment.
Services
Databases
BlackBerry Push Notifications service (
Mail
 service) on one server
Create a blank database and call it "BEMS_Core1".
Connect
 service and
Presence
 service on one server
Create two blank databases. Call one "BEMS_Core3" and call one "BEMS_Connect."
The
Presence
 service does not require a separate database when it is installed on a server with a service that uses a database.
Connect
 service only on one server
Create two blank databases. Call one "BEMS_Core3" and call one "BEMS_Connect."
Presence
 service only on one server*
Create a blank database and call it "BEMS_Core2."
Docs service only on one server
Create two blank databases. Call one "BEMS_Core4" and call one "BEMS_Docs."