17
2: System requirements
Checklist: Database environment settings
Considerations
Install one of the following database programs on the computer on which you plan to install the BlackBerry Configuration
Database:
•Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
•Microsoft SQL Server 2000 SP3a
•Microsoft SQL Server 2005 (Standard, Enterprise, or Express)
•DB2 UDB Version 8.2 (Express or Enterprise)
Notes: If you are installing BlackBerry MDS Services, you cannot use Microsoft SQL Server 2005 Express as your database
program.
You can install MSDE 2000 during the BlackBerry Enterprise Server installation.
Install one of the following MDAC versions on the computer on which you plan to install the BlackBerry Configuration Database:
•MDAC Version 2.8 with Security Patch MS04-003 (Version 2000.85.1025.00)
•MDAC Version 2.8 SP2 (Version 2000.86.1830.00)
MDAC Version 2.8 SP2 is shipped only with Microsoft Windows Server 2003 SP1.
You must manage the BlackBerry Configuration Database using a BlackBerry Manager that is configured to support the database
management system (DBMS) type. You select the DBMS type of the BlackBerry Manager during the BlackBerry Enterprise Server
installation.
The version of MSDE 2000 (MSDE 2000 Release A) provided with the BlackBerry Enterprise Server does not support upgrading
from a previous version of MSDE. Visit www.support.microsoft.com/kb/829925 for more information.
If you are using Microsoft SQL Server, install the program using the default case-insensitive collation setting. The collation setting
for the BlackBerry Configuration Database must be the same as the collation setting for the database server.
If you are using Microsoft SQL Server, you can install the BlackBerry Configuration Database on a nondefault instance. During
the installation process, you can specify servername\instancename.
If you are using Microsoft SQL Server and if you are using Windows authentication between the BlackBerry Enterprise Server and
the BlackBerry Configuration Database, you must set the Microsoft SQL Server to run under the Local System account.
If you are using DB2 UDB, do not install the database program on a mainframe computer.
If you are using DB2 UDB and you want to create the BlackBerry Configuration Database using an account name that is longer
than the database schema name (by default, BESADMIN), you must first apply DB2 UDB Version 8.2 FixPak 5 to your database
server. Visit www-1.ibm.com/support/docview.wss?uid=swg1LI70002 for more information.
If the BlackBerry Configuration Database is on a remote computer or you want to use a remote BlackBerry Manager, you must
enable named pipes and TCP/IP network protocols.
If you are installing the BlackBerry MDS Services, you must install the BlackBerry MDS Services databases on the same DBMS and
on the same database server as the BlackBerry Configuration Database.
If you are installing the BlackBerry MDS Services and if you are using Microsoft SQL Server, the Microsoft SQL Server must support
mixed-mode authentication. If you install the BlackBerry Configuration Database on MSDE 2000, you receive a prompt to accept
this change in authentication.
If you are installing the BlackBerry MDS Services and if you are using DB2 UDB, you must create the database user account before
you create the BlackBerry MDS Services databases.