Blackberry Version 5.0 Service Pack 4 Description, Expand Microsoft SQL Server Security Logins

Page 78

Installation and Configuration Guide

Postinstallation tasks

Configuring minimum Microsoft SQL Server permissions for the Windows account

The BlackBerry Enterprise Server setup application requires the Windows account that it uses during the installation process or upgrade process to have Microsoft SQL Server permissions to create or upgrade the BlackBerry Configuration Database. The setup application requires the Windows account to have more Microsoft SQL Server permissions to install the BlackBerry Enterprise Server than the BlackBerry Enterprise Server requires to run.

After the installation or upgrade process completes, you can change the Microsoft SQL Server permissions of the Windows account to the Microsoft SQL Server permissions that the BlackBerry Enterprise Server requires to run. When you change the Microsoft SQL Server permissions of the Windows account, you can use Microsoft SQL Server security to minimize the operations that the Windows account can perform on the BlackBerry Configuration Database.

The following table describes the Microsoft SQL Server permissions for the setup application and the Windows account that the BlackBerry Enterprise Server uses to run.

Server and database roles	Description

db_owner	The setup application requires this role to upgrade the BlackBerry Configuration Database.
	This role is the default permission in Microsoft SQL Server for running the BlackBerry
	Enterprise Server.

rim_db_bes_server	The setup application or the createDB executable creates the role automatically when it
	creates the BlackBerry Configuration Database.
	This role is the minimum permission in Microsoft SQL Server for running the BlackBerry
	Enterprise Server.

Configure minimum Microsoft SQL Server permissions for the Windows account

You can configure the minimum Microsoft SQL Server permissions for the Windows account that the BlackBerry Enterprise Server uses to run.

1.Open the Microsoft SQL Server console.

2.Expand Microsoft SQL Server > Security > Logins.

3.Right-click the Windows account that the BlackBerry Enterprise Server uses to run. Click Properties.

4.Map the Windows account to the BlackBerry Configuration Database.

78

Image 78

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 Administration Service Installing the BlackBerry Attachment ServiceInstalling the BlackBerry Collaboration Service Installing the BlackBerry MDS Connection ServiceInstalling the BlackBerry Router Hardware requirements BlackBerry Enterprise Server RequirementHardware requirements BlackBerry Enterprise Server System requirements System requirements BlackBerry Enterprise ServerExchange Server version System requirements BlackBerry Enterprise Server databases Microsoft SQL Server 2008 R2 32-bit or 64-bit System requirements BlackBerry Attachment Service Operating system Any of the following operating systemsSystem requirements BlackBerry Collaboration Service Windows Server IBM Sametime Novell GroupWise MessengerMicrosoft Lync Server System requirements BlackBerry MDS Connection Service System requirements for your organizations environment Network servicesSystem requirements BlackBerry Router HigherBrowser Browser settings for Windows Internet Explorer Installation and Configuration Guide System requirements Messaging server System requirements FirewallSupported features and environments System requirements Instant messaging serverBlackBerry Enterprise Server Unsupported environments DescriptionBlackBerry Attachment Service Preinstallation tasks Configuring a Microsoft Exchange 2010 messaging environmentAfter you finish Before you begin Turn off client throttling in Microsoft Exchange Type New-ThrottlingPolicy BESPolicyInstallation and Configuration Guide Configuring a Microsoft Exchange 2007 messaging environment After you finish Click Check Names Configuring a Microsoft Exchange 2003 messaging environment Group membership Domain UserClick 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 Type CreateDB.exe BESMgmt.cfg Property DescriptionDbms 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 standby BlackBerry Enterprise Server Install a primary BlackBerry Enterprise ServerAfter you finish Postinstallation tasks Test the BlackBerry Enterprise Server installationInstall the BlackBerry database notification system Best practice Running the BlackBerry Enterprise Server Open the NotifyMasterInstall.sql fileOpen the NotifyInstall.sql file Best practice DescriptionConfiguring support for Unicode languages Type regeditType regedit Type regedit Type regedit Installation and Configuration Guide After you finish Click Edit component There is a problem with this websites security certificate Click View certificates Configuring communication with distributed componentsOn the Security tab, click Local Intranet Click Trusted Root Certification Authorities. d Click OKClick Edit instance Attachment.Server.host=attachmentserverhostnameChange AllowRemoteServices to Component view, expand BlackBerry Enterprise Server Click Restart instanceType regedit Configuring a computer for monitoring Click Start Run Expand Microsoft SQL Server Security Logins Changing the BlackBerry Configuration Database Change the Database role membership to rimdbbesserverRun the BCSProvisioner.exe file Click Provision BCSAdding or removing BlackBerry 9 Enterprise Server components Component OptionsIf you installed remote components, you can add a BlackBerry Add or remove a BlackBerry Enterprise Server component After you finish Click Component view Removing the BlackBerry Enterprise Server software Remove the BlackBerry Enterprise Server softwareDelete registry keys BlackBerry Enterprise Server registry keys Key LocationOpen the NotifyUnInstall.sql file Removing the BlackBerry database notification systemInstallation and Configuration Guide Failed to write License Key to the Database Previous version detected but no database availablePossible solution On the BlackBerry Server tab, click Edit Mapi profile Possible cause Page You cannot access the BlackBerry Administration Service Possible solutionPossible cause Possible cause Possible solution Text in the license agreement is not readable Related resources Guide InformationGlossary13 Messaging server Name Service Provider InterfaceMessaging Application Programming Interface Network interface cardLegal notice 102 Installation and Configuration Guide