System requirements: BlackBerry Enterprise Server databases

Item

Requirement

database management system

Any of the following database management systems:
  • MSDE 2000 SP3
  • 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 Express Edition SP1 (32-bit or 64-bit)

For all versions of the Microsoft SQL Server earlier than Microsoft SQL Server 2005 SP3, install the security update described in Microsoft Security Bulletin MS09-004 (for more information, visit technet.microsoft.com to read article 960082).

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/btsc 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 or BlackBerry MDS Integration Service database, the following conditions:
  • the database server must be 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), or Microsoft SQL Server 2008 SP1 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
  • the SQL Server Browser service must be running
  • the Named Pipes option must be turned off 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 or BlackBerry MDS Integration Service 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 edition as the database server that hosts the principal database

Was this information helpful? Send us your comments.