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 SP2 (32-bit or 64-bit)
  • Microsoft SQL Server 2005 Express Edition SP2

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

collation setting

The following conditions on the database server:
  • collation set to default case-insensitive
  • BlackBerry® Configuration Database collation set to default case-insensitive

remote database conditions

Named pipes and 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 SP2 (32-bit or 64-bit)
  • the mirror database must be located 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 theBlackBerry® Enterprise Server instances

database transactional replication

To support database transactional replication for the BlackBerry Configuration Database or the BlackBerry MDS Integration Service database, the following conditions:
  • the database server must be Microsoft SQL Server 2000 SP3a or later
  • the database server that hosts the replicated database must use the same version and build as the primary database
  • if your organization's database server is Microsoft SQL Server 2000 SP3a, the "FIX: Distribution Agent Fails with 'Violation of Primary Key Constraint' Error Message" hotfix installed (for more information about installing the hotfix, visit www.support.microsoft.com to read article 813494)

Was this information helpful? Send us your comments.