Configuring connections for the BlackBerry Enterprise Server databases

Installation and Configuration Guide

Search This Document

Download PDF

The BlackBerry® Enterprise Server and BlackBerry Monitoring Service store data in their own databases. The database for the BlackBerry Enterprise Server is the BlackBerry Configuration Database.

You create the BlackBerry Configuration Database when you install a BlackBerry Enterprise Server or BlackBerry Administration Service or when you run the CreateDB executable. You can create the BlackBerry Monitoring Service database during the installation process for the BlackBerry Monitoring Service.

The BlackBerry Enterprise Server and BlackBerry Monitoring Service can connect to their databases on the Microsoft® SQL Server® using Windows® authentication or database authentication. By default, the BlackBerry Enterprise Server and BlackBerry Monitoring Service log in to their databases using the Windows account that you use to complete the installation process or the database credentials you provided during the installation process.

To support database mirroring for the BlackBerry Configuration Database with Microsoft SQL Server 2005 or Microsoft SQL Server 2008, you must use Windows authentication. The BlackBerry Monitoring Service does not support database mirroring.

Specifying permissions when you connect to the BlackBerry Enterprise Server databases using Windows authentication or Microsoft SQL Server authentication

If you connect the BlackBerry® Enterprise Server and BlackBerry Monitoring Service to the BlackBerry Enterprise Server databases using Windows® authentication or Microsoft® SQL Server® authentication during the BlackBerry Enterprise Server installation process, the Windows account or Microsoft SQL Server account that you specify must have database permissions on the database server. The type of permissions that you specify is determined by the setup option that you select and whether you create the BlackBerry Enterprise Server databases on the computer that hosts the BlackBerry Enterprise Server components or on another database server.

Specifying permissions for the Windows account or Microsoft SQL Server account

If you install Microsoft® SQL Server® 2005 Express during the BlackBerry® Enterprise Server installation process, you might need to specify permissions for the Windows® account or Microsoft SQL Server account, depending on the type of authentication you select.

When you select Windows authentication during the BlackBerry Enterprise Server installation process, the setup application automatically assigns the required permissions to the Windows account that you use to complete the installation process.

When you select Microsoft SQL Server authentication during the BlackBerry Enterprise Server installation process, you must assign the required database permissions to the Microsoft SQL Server account that you use to complete the installation process.

Assign permissions to the Windows account or Microsoft SQL Server account

Perform one of the following actions:

If you create the BlackBerry® Enterprise Server databases on the computer that hosts the BlackBerry Enterprise Server and you require the setup application to install Microsoft® SQL Server® Express during the installation process and you choose Windows® authentication, you are not required to assign Microsoft SQL Server permissions to the Windows account. If you want the setup application to install the BlackBerry database notification system, you must assign the Microsoft SQL Server permission for the database system administrator (also called the sysadmin server role in Microsoft SQL Server Management Studio) to the Windows account.
If you create the BlackBerry Enterprise Server databases on the computer that hosts the BlackBerry Enterprise Server and you require the setup application to install Microsoft SQL Server Express during the installation process and you choose Microsoft SQL Server authentication, you must assign the database creator (dbcreator server role) Microsoft SQL Server permission to the Microsoft SQL Server account. If you want the setup application to install the BlackBerry database notification system, you must assign the Microsoft SQL Server permission for the database system administrator (also called the sysadmin server role in Microsoft SQL Server Management Studio) to the Microsoft SQL Server account.
If you create the BlackBerry Enterprise Server databases on the computer that hosts the BlackBerry Enterprise Server and the computer already hosts a Microsoft SQL Server, you must assign the database creator (dbcreator server role) Microsoft SQL Server permission to the Windows account or Microsoft SQL Server account that you use to complete the BlackBerry Enterprise Server installation process. If you want the setup application to install the BlackBerry database notification system, you must assign the Microsoft SQL Server permission for the database system administrator (also called the sysadmin server role in Microsoft SQL Server Management Studio) to the Windows account or Microsoft SQL Server account.
If you create the BlackBerry Enterprise Server databases on a computer that does not host the BlackBerry Enterprise Server, you must assign the database creator (dbcreator server role) Microsoft SQL Server permission to the Windows or Microsoft SQL Server account that you use to complete the BlackBerry Enterprise Server installation process. If you want the setup application to install the BlackBerry database notification system, you must assign the Microsoft SQL Server permission for the database system administrator (also called the sysadmin server role in Microsoft SQL Server Management Studio) to the Windows account or Microsoft SQL Server account.

Configuring the local system account in an IBM Lotus Domino environment

Add Windows credentials to the local system account

You can configure the local system account to access the BlackBerry® Enterprise Server, install the BlackBerry Configuration Database on a computer that is separate from the computer that hosts the BlackBerry Enterprise Server, and use Windows® authentication to connect to the BlackBerry Configuration Database.

In the Microsoft® SQL Server® Enterprise Manager or Microsoft SQL Server Management Studio, create a new user account with the following properties:

user name that is the same as the name of the BlackBerry Enterprise Server computer, and uses the format <Domain>\<computer_name>$
authentication configured to Windows authentication
roles assigned that are required to change the BlackBerry Configuration Database

Create a BlackBerry Configuration Database

If the security required by your organization does not allow applications to have permissions to create or upgrade databases, you can run the CreateDB executable on the database server to create the BlackBerry® Configuration Database instead of using the setup application. After you create or upgrade the BlackBerry Configuration Database using the CreateDB executable, you can run the setup application using a Windows® account with minimum requirements to the database server.

Before you begin: Verify that the appropriate permissions are configured on the database server.

Log in to the computer that hosts the database server using a local administrator account or a Windows account that has SQL administrator permissions.
Copy the BlackBerry® Enterprise Server installation media to the database server that you want to configure as the host server for the BlackBerry Configuration Database.
Extract the contents to a folder on the computer.
Navigate to <extracted_folder>\Database.
Open the BesMgmt.cfg file in a text editor.
Change the file to include information that is specific to your organization's environment.
Save and close the file.
Open a command prompt window.
Change to <extracted_folder>\Database.
Type CreateDB.exe BESMgmt.cfg.

BESMgmt.cfg properties

Property	Description
CMD	This property specifies the type of action that the CreateDB executable must complete (for example, whether to install or upgrade the BlackBerry® Configuration Database).
DATABASE_NAME	This property specifies the name of the BlackBerry Configuration Database.
SERVER	This property specifies the name of the database server that hosts the BlackBerry Configuration Database. If a database instance hosts the BlackBerry Configuration Database, follow the format `database_server_name`\`database_instance_name`.
USERID	If you use database authentication, this property specifies the user name of the database account that has server administrator permission and database creator permission.
PASSWORD	If you use database authentication, this property specifies the password for the database account.
SCRIPT_ROOT	This property specifies the path to the DBInstallScripts folder. By default, this folder is in the same root folder that the CreateDB.exe file is located in.
LOG_DIR	This property specifies the path to the folder that you want to create log files in. By default, this folder is in the same root folder that the CreateDB.exe file is located in.
DBMS	This property specifies the database management system that your organization uses.
DB_FILE_DIR	This property specifies an existing folder that you want to save the database files in. By default, this folder is in the same root folder that the CreateDB.exe file is located in.
BACKUP_DIR	This property specifies an existing folder where you want to save the database backup in. By default, this folder is located in the same root folder that the CreateDB.exe file is located in.
BES_TYPE	This property specifies the messaging server that your organization uses.

Next topic: Install the SNMP service for monitoring by the BlackBerry Monitoring Service

Previous topic: Configure the Server document to permit the BlackBerry Enterprise Server to move user accounts within a BlackBerry Domain

Was this information helpful? Send us your comments.

Global Navigation

Installation and Configuration Guide

Local Navigation