BlackBerry Enterprise Server software installation does not detect MSDE

[BESadmin]

BlackBerry Enterprise Server software installation does not detect MSDE

Doc ID : KB10200
Last Modified : 2007-04-10
Document Type : Support

Environment

• BlackBerry® Enterprise Server software versions 3.6 through 4.1
• Microsoft® SQL Server™ Desktop Engine (MSDE)

Problem

The installation of the BlackBerry Enterprise Server fails. MSDE is already installed, but the installation program does not detect a default MSDE instance.

Cause

MSDE is already installed with a third-party application, such as Symantec® Backup Exec, Microsoft Small Business Server Monitoring, or Windows Server™ Update Services. However, the installation did not create a default instance.

Resolution

This issue has more than one resolution.

Resolution 1

1. Create the default instance of MSDE manually.
   1. Install the default instance of MSDE.
   2. Download Microsoft SQL Server 2000 Desktop Engine Release A (MSDE 2000a) from the Microsoft downloads web site.
   3. Extract MSDE 2000a to a folder.
2. Navigate to the extracted folder from a command prompt.
3. Run the following command: setup sapwd="<password>" disablenetworkprotocols=0 securitymode=SQL
   where <password> is a strong password assigned to the System Administrator account.
   Note: MSDE will be installed in mixed mode, which is required for later versions of the BlackBerry Enterprise Server software.
4. Restart the computer.

Important: Restarting certain BlackBerry Enterprise Server services will delay message delivery to BlackBerry devices. For more information, see KB04789.

1. In the Windows Services list, start the SQLServerAgent service and set the startup type to Automatic.
2. Resume the installation of the BlackBerry Enterprise Server using the default instance of MSDE.

Resolution 2

1. Install the default instance of MSDE.<LI style="LIST-STYLE-TYPE: none">
   1. Download MSDE 2000A from the Microsoft downloads web site.
   2. Run the MSDE2000A.exe file to create a default instance. It will appear in the Windows Services list as MSSQLSERVER.
2. Create the BlackBerry Configuration Database.
   1. Open a command prompt and browse to the database folder in the BlackBerry Enterprise Server upgrade file location.
   2. Type the following command: createdb besmgmt.cfg
3. In the Windows Services list, start the SQLServerAgent service and set the startup type to Automatic.