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 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."
Note: 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."