How to create a new Microsoft SQL Server Desktop Engine database instance

Article ID: KB17627

Type: Support Content

Last Modified: 05-08-2009

 

Product(s) Affected:

  • BlackBerry® Enterprise Server for Microsoft® Exchange
CollapseOverview

The following error appears during the database creation section of the BlackBerry Enterprise Server or the BlackBerry Professional Software installation:

Database server not found, please verify the information

CollapseEnvironment
  • BlackBerry® Enterprise Server version 4.1
  • BlackBerry® Professional Software
  • Microsoft® SQL Server® Desktop Engine (MSDE) 2000 Release A
CollapseCause

MSDE or Microsoft® SQL Server® 2005 Express Edition is already installed, but the installation process did not create a default instance.

CollapseResolution

Create a new database instance by completing the following steps:

  1. Download and run MSDE 2000 A. This will extract the files to C:\MSDERelA by default.
  2. Open the command prompt by typing cmd in the Run command window, and then pressing Enter.
  3. Browse to the following directory: C:\MSDERelA>
  4. Run the following command: setup INSTANCENAME=<instance_name> SECURITYMODE=SQL SAPWD=<sa_password>.
    Where <sa_password> is the service account password and <instance_name> is the name of the instance created.
  5. Once the above installation is complete, run the BlackBerry Enterprise Server setup again.
  6. At the database screen, type the database information as <server_name>\<instance_name>.

Note: Once the instance has been created, make sure that the MSSQL$<instance_name> service is running under Start > Programs > Administrative Tools > Services prior to running the database creation section in the BlackBerry Professional Software installation.

CollapseAdditional Information

MSDE 2000 A can be found by searching for "MSDE 2000 download" at http://www.microsoft.com.

Disclaimer

By downloading, accessing or otherwise using the Knowledge Base documents you agree:

   (a) that the terms of use for the documents found at www.blackberry.com/legal/knowledgebase apply to your use or reference to these documents; and

   (b) not to copy, distribute, disclose or reproduce, in full or in part any of the documents without the express written consent of RIM.


Visit the BlackBerry Technical Solution Center at www.blackberry.com/btsc.