Installing the BlackBerry Enterprise Server
Management console with a remote database
Originally posted: March 2002Affected software versions
BlackBerry™ Enterprise Server version 2.1 for Microsoft Exchange with Service Pack 1
Summary
This document explains how to install the BlackBerry Enterprise Server Management console (Microsoft
Management Console [MMC] Snap-in) for the BlackBerry Enterprise Server and point to a remote SQL server. This document assumes the same system requirements as the BlackBerry Enterprise Server installation.
Explanation
After the BlackBerry Enterprise Management console is installed, a directory is created that is named Database. This directory contains five files:
Createdb.exe is used to call the Createdb.sql with the correct parameters. Createdb.sql is used to create the initial BESMgmt database.
Errors.sql is used to add errors to the master sysmessages table.
Stored proc.sql is used to create all the stored procedures in the admin database. Tables.sql is used to create the initial BlackBerry Admin Server tables.
When these files are run on the production SQL server, they create the database that is required for the BlackBerry Enterprise Server Management console. The BlackBerry Enterprise Server Management console can then be pointed to the database using an Open Database Connectivity (ODBC) connection that is created on the BlackBerry
Enterprise Server.
Installing the BlackBerry Enterprise Server Management console installation
The following steps explain how to install the BlackBerry Enterprise Server Management console for the BlackBerry Enterprise Server for Microsoft Exchange 2000.
Figure 2: BlackBerry Enterprise Server Management Welcome screen 2. Click Next to begin the installation. The License Agreement screen appears.
Figure 3: BlackBerry Enterprise Server Management License Agreement screen 3. If you accept the terms of the License Agreement, click Yes to proceed with the installation. The Database
Figure 4: BlackBerry Enterprise Server Management Database Information screen 4. In the Database Information section, in the Server Name field, type the SQL server NetBIOS name.
5. In the Database Information section, clear the Create BlackBerry Enterprise Server Management database check box.
6. In the Database Authentication section, in the Password field, type the password if the SQL server has a password set for the system administrator (sa) account.
7. In the Database Authentication section, for the Database Authentication Method, select SQL Server Authentication.
Figure 6: BlackBerry Management Console database directory on the BlackBerry Enterprise Server
2. Open a command prompt on the SQL server computer and change the directory to the temporary directory that stores the database files.
Figure 7: Command prompt with the temporary directory for the BlackBerry Enterprise Server Management console
Figure 8: Command prompt with the Createdb.exe file run 4. After the database is created successfully, the following message appears.
Figure 9: Command prompt with the Createdb.exe file completed
Figure 11: ODBC Data Source Administrator window—System DSN tab The Create New Data Source window appears.
Figure 12: Create New Data Source window
Figure 13: Create a New Data Source to <driver> window—Screen 1 4. In the following fields, type the appropriate information:
Name: Leave this value as BesMgmt, because it was specified in the installation of the BlackBerry Enterprise Server Management console.
Description: Information is not required in this field, but can contain a description of the DSN. Server: This field must specify the SQL server on which you have created the database. 5. Click Next. The second screen of the Create a New Data Source to <driver> window appears.
Figure 14: Create a New Data Source to <driver> window—Screen 2
6. Select the Change the default database to check box and, in the text box, specify the BesMgmt database on the SQL server.
Figure 15: ODBC Data Source Test window
9. If any problem occurs, it must be corrected before proceeding. After the test completes successfully, the BlackBerry Enterprise Server Management console can be started and the BlackBerry Enterprise Server can be added to the list.
Part number: TAE-00046-001
© 2002 Research In Motion Limited. All rights reserved. The BlackBerry and RIM families of related marks, images and symbols are the exclusive properties of Research In Motion Limited. RIM, Research In Motion, 'Always On, Always Connected', the “envelope in motion” symbol and the BlackBerry logo are registered with the U.S. Patent and Trademark Office and may be pending or registered in other countries. All other brands, product names, company names, trademarks and service marks are the properties of their respective owners. The handheld and/or associated software are protected by copyright, international treaties and various patents, including one or more of the following U.S. patents: 6,278,442; 6,271,605; 6,219,694; 6,075,470; 6,073,318; D,445,428; D,433,460; D,416,256. Other patents are registered or pending in various countries around the world. Please visit www.rim.net/patents.shtml for a current listing of applicable patents.
