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. 

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.

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.

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

.