Blackberry Version 5.0 Service Pack 4 manual Microsoft SQL Server 2008 R2 32-bit or 64-bit

Installation and Configuration GuideSystem requirements

Item	Requirement
	• Microsoft SQL Server 2008 R2 (32-bit or 64-bit)
	• Microsoft SQL Server 2008 R2 SP1 (32-bit or 64-bit)
	• Microsoft SQL Server 2008 R2 SP2 (32-bit or 64-bit)
	• Microsoft SQL Server 2008 Express SP3 (32-bit or 64-bit)
	• Microsoft SQL Server 2008 R2 Express SP1 (32-bit or 64-bit)
	• Microsoft SQL Server 2008 R2 Express SP2 (32-bit or 64-bit)
	• Microsoft SQL Server 2012 (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
	• No count option turned off
nested triggers	Nested trigger support turned on. For more information, visit
	msdn.microsoft.com to read article ms178101.
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)

17