BES and SBS2003 MSDE SQL

If your going to run BES on SBS2003 then you will need to check what version of MSDE SBS is using.

You can do this by looking in c:\program files\Microsoft SQL Server\<instance>

If your using MSDE2000, then use the following steps:

1. Manually install an MSDE instance for the BlackBerry Enterprise Server by completing the following steps:
   1. Go to the Microsoft Support Center and download MSDE 2000 Release A. Make sure to read the MSDE2000RelA release notes.
   2. Double-click the downloaded file to extract the MSDE Release A installation files.
   3. Locate the directory to which the files were extracted. The default directory is C:\MSDERelA.
   4. Open a command prompt window and change directory to the folder identified in step 3.
   5. Type setup sapwd=<password> instancename=BlackBerry, where <password> is the strong password you want to specify for the sa account.
2. Run the BlackBerry Enterprise Server software installation program.
3. When prompted, restart the BlackBerry Enterprise Server.
4. When prompted to specify BlackBerry Configuration Database information, type the configuration settings listed in the table below.
   

   BlackBerry Configuration Database details	Configuration setting
   Database location	Local
   Database information	<server_name>\BlackBerry where <server_name> represents the NetBIOS name of the computer in which the MSDE instance was installed.
   Database name	BESMgmt
   Data Directory	C:\Program Files\Microsoft SQL Server\MSSQL$BlackBerry\Data
   Backup Directory	C:\Program Files\Microsoft SQL Server\MSSQL$BlackBerry\Backup
   Database authentication	Windows (Trusted)

5. Continue the installation and start the BlackBerry Enterprise Server services when prompted.

If your using MSDE 2005

1) Download the software to C:\Downloads
2) Open a command prompt and go to C:\Downloads
3) Run this command C:\Downloads\SQLEXPR32.exe -X
4) A prompt will open asking you where to Extract the program (C:\MSDE2005)
5) From the SAME command prompt browse to C:\MSDE2005
6) Run this command setup INSTANCENAME=”blackberry” SAPWD=”password” (this is a copy/paste from a blackberry support e-mail from 2005)
7) *VERY IMPORTANT* When it opens the installer for MSDE 2005 UNCHECK the Hide Advanced Options. Continue clicking next in the install until it comes to the point where it asks about Authentication. Selected MIXED MODE and enter “password” as the password.
8) When it comes time in the install you will see SERVERNAME you add \blackberry to make it SERVERNAME\blackberry

Advertisement