BlackBerry Push Notifications database requirements

Note: Verify that 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, see KB 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 of 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.