BlackBerry Push Notifications

database requirements

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.

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.

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

.