System requirements: BlackBerry Enterprise Server databases

Item

Requirement

database management system

Any of the following database management systems:
  • Microsoft® SQL Server® 2005 SP3 (32-bit or 64-bit)
  • Microsoft SQL Server 2005 SP4 (32-bit or 64-bit)
  • Microsoft SQL Server 2005 Express Edition SP3
  • Microsoft SQL Server 2008 SP1 (32-bit or 64-bit)
  • Microsoft SQL Server 2008 SP2 (32-bit or 64-bit)
  • Microsoft SQL Server 2008 Express Edition SP1 (32-bit or 64-bit)
  • Microsoft SQL Server 2008 R2 (32-bit or 64-bit)
  • Microsoft SQL Server 2008 R2 Express (32-bit or 64-bit)

collation setting

To configure collation settings, the following conditions:
  • database server collation configured to default case-insensitive
  • BlackBerry® Configuration Database collation configured to default case-insensitive
  • collation must be the same for the Microsoft SQL Server instance and the database server that hosts the BlackBerry database notification system (BlackBerry Configuration Database)
  • default collations are suggested though non-default collations are supported (for more information, visit www.blackberry.com/go/kbhelp to read articles KB04785 and KB15534)

database connectivity

TCP/IP network protocols turned on

database mirroring

To support database mirroring for the BlackBerry Configuration Database, the following conditions:
  • Any of the following database management systems:
    • Microsoft SQL Server 2005 SP3 Enterprise Edition or Standard Edition (32-bit or 64-bit)
    • Microsoft SQL Server 2005 SP4 Enterprise Edition or Standard Edition (32-bit or 64-bit)
    • Microsoft SQL Server 2008 SP1 Enterprise Edition or Standard Edition (32-bit or 64-bit)
    • Microsoft SQL Server 2008 SP2 Enterprise Edition or Standard Edition (32-bit or 64-bit)
    • Microsoft SQL Server 2008 R2 Enterprise Edition or Standard Edition (32-bit or 64-bit)
  • the mirror database must reside on a different computer from the principal database
  • the Microsoft SQL Server instances for both the principal and mirrored databases must be the same version and edition
  • only use static port number 1433
  • do not use named instances
  • verify that the SQL Server Browser service is running
  • turn off the Named Pipes option in the Microsoft SQL Server Native Client on the computers that host the BlackBerry® Enterprise Server instances

database transactional replication

To support database transactional replication for the BlackBerry Configuration Database, the following conditions:

  • the database server must be Microsoft SQL Server 2005 SP3 or later
  • the database server that hosts the replicated database must use the same version and build as the database server that hosts the primary database

Was this information helpful? Send us your comments.