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

Page 17

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

Image 17

Contents Installation and Configuration Guide Published 2014-01-14 SWD-20140114180405595 Contents Installing a standby BlackBerry Enterprise Server Adding or removing BlackBerry Enterprise Server components 101 Overview BlackBerry Enterprise Server Planning a BlackBerry Enterprise Server installation Installing the BlackBerry Attachment Service Installing the BlackBerry Administration ServiceInstalling the BlackBerry MDS Connection Service Installing the BlackBerry Collaboration ServiceInstalling the BlackBerry Router Requirement Hardware requirements BlackBerry Enterprise ServerHardware requirements BlackBerry Enterprise Server System requirements BlackBerry Enterprise Server System requirementsExchange Server version System requirements BlackBerry Enterprise Server databases Microsoft SQL Server 2008 R2 32-bit or 64-bit Operating system Any of the following operating systems System requirements BlackBerry Attachment ServiceSystem requirements BlackBerry Collaboration Service IBM Sametime Novell GroupWise Messenger Windows ServerMicrosoft Lync Server System requirements BlackBerry MDS Connection Service System requirements BlackBerry Router Network servicesSystem requirements for your organizations environment HigherBrowser Browser settings for Windows Internet Explorer Installation and Configuration Guide System requirements Firewall System requirements Messaging serverBlackBerry Enterprise Server Supported features and environmentsSystem requirements Instant messaging server Description Unsupported environmentsBlackBerry Attachment Service After you finish Preinstallation tasksConfiguring a Microsoft Exchange 2010 messaging environment Before you begin Type New-ThrottlingPolicy BESPolicy Turn off client throttling in Microsoft ExchangeInstallation and Configuration Guide Configuring a Microsoft Exchange 2007 messaging environment After you finish Click Check Names Group membership Domain User Configuring a Microsoft Exchange 2003 messaging environmentClick Check Names Configure permissions for the Windows account Add the Windows account to the local administrators group Installation and Configuration Guide Perform one of the following actions Property Description Type CreateDB.exe BESMgmt.cfgDbms Installation and Configuration Guide Select the Create associated pointer PTR record check box Installation and Configuration Guide Installation and Configuration Guide Socket connections for each instant messaging session Microsoft SQL Server 2008 R2 Express Edition Installing the BlackBerry Enterprise Server software Install the BlackBerry Enterprise Server software Click Check Name After you finish Before you begin Click Check Name Install a standalone BlackBerry Router Installing a standby BlackBerry 7 Enterprise Server Install a primary BlackBerry Enterprise Server Install a standby BlackBerry Enterprise ServerAfter you finish Install the BlackBerry database notification system Postinstallation tasksTest the BlackBerry Enterprise Server installation Open the NotifyInstall.sql file Open the NotifyMasterInstall.sql fileBest practice Running the BlackBerry Enterprise Server Best practice DescriptionType regedit Configuring support for Unicode languagesType regedit Type regedit Type regedit Installation and Configuration Guide After you finish Click Edit component There is a problem with this websites security certificate On the Security tab, click Local Intranet Configuring communication with distributed componentsClick View certificates Click Trusted Root Certification Authorities. d Click OKAttachment.Server.host=attachmentserverhostname Click Edit instanceChange AllowRemoteServices to Click Restart instance Component view, expand BlackBerry Enterprise ServerType regedit Configuring a computer for monitoring Click Start Run Expand Microsoft SQL Server Security Logins Change the Database role membership to rimdbbesserver Changing the BlackBerry Configuration DatabaseClick Provision BCS Run the BCSProvisioner.exe fileComponent Options Adding or removing BlackBerry 9 Enterprise Server componentsIf you installed remote components, you can add a BlackBerry Add or remove a BlackBerry Enterprise Server component After you finish Click Component view Delete registry keys Removing the BlackBerry Enterprise Server softwareRemove the BlackBerry Enterprise Server software Key Location BlackBerry Enterprise Server registry keysRemoving the BlackBerry database notification system Open the NotifyUnInstall.sql fileInstallation and Configuration Guide Previous version detected but no database available Failed to write License Key to the DatabasePossible solution On the BlackBerry Server tab, click Edit Mapi profile Possible cause Page Possible cause You cannot access the BlackBerry Administration ServicePossible solution Possible cause Possible solution Text in the license agreement is not readable Guide Information Related resourcesGlossary13 Messaging Application Programming Interface Name Service Provider InterfaceMessaging server Network interface cardLegal notice 102 Installation and Configuration Guide