Skip Navigation

BlackBerry Push Notifications
 database requirements

You must create a blank SQL database for the 
BlackBerry Push Notifications
 service. The recommended name for this database is BEMS_Core. If you install the 
BlackBerry Push Notifications
 service (Mail services on one computer) and other services (for example, the 
Presence
 service) on another computer, call the database BEMS_Core1. 
Make sure the Collate property is set to CI (case insensitive). This is the default collation setting when you create a new database. If you are upgrading an existing database, verify the collation setting.
BEMS
 connects to the 
Microsoft SQL Server
 using TCP/IP. If your environment uses 
Microsoft SQL Server
 Express, the TCP/IP protocol is not enabled by default. For instructions on how to enable TCP/IP on 
Microsoft SQL Server
 Express, visit support.blackberry.com/community and read article 63994.
BEMS
 supports the use of dynamic ports when connecting to the 
SQL Server
. Dynamic ports is the default setting for 
SQL Server
 Express installations and other more complex 
SQL Server
 installations. The 
SQL Server
 Browser service must be started for 
BEMS
 to use 
SQL Server
 dynamic ports. 
BEMS
 connects to the 
SQL Server
 Browser service over port 1434 to obtain the current dynamic port of the 
SQL Server
 instance to use. By default, the 
SQL Server
 Browser service is disabled in 
SQL Server
 Express installations.

Verify the case sensitivity of the 
BlackBerry Push Notifications
 database

Run the following SQL query: 
SELECT DATABASEPROPERTYEX('
dbname
', 'Collation')
Where 
dbname
 is the name for the 
BlackBerry Push Notifications
 database. For example, GEMSDB. 
Verify the return value.
  • SQL_Latin1_General_CP1_CI_AS, CI indicates that the database is case insensitive.
  • SQL_Latin1_General_CP1_CS_AS, CS indicates that the database is case sensitive.

Change the 
BlackBerry Push Notifications
 case type to insensitive

To change the case sensitivity, type 
alter database [dbname] collate SQL_Latin1_General_CP1_CI_AS
During installation, you will be prompted to specify the database server and SQL instance. When this information is entered, the 
BEMS
 installer will automatically create the schema required by 
BlackBerry Push Notifications
.