See also: BlackBerry
I haven't tried this myself (and hope never to have to!) so use at your own risk.
Credit to Giovanni on the SBSUsers mailing list for sharing this.
I found these instruction for creating a Named Instance of a database which worked beautifully.
I’ve included them here and hopefully they might help someone.
Follow these instructions to create the database
As for the SQL install I have stopped using MSDE 2000a and moved over to MSDE 2005 Express.
There is no need to download this file as the Blackberry Professional installation comes with a copy that is sitting in the Tools folder in the installation directory.
This is what you do to make it simple.
- Download the software to C:\Downloads
- Open a command prompt and go to C:\Downloads
- Run this command C:\Downloads\SQLEXPR32.exe -X
- A prompt will open asking you where to Extract the program (C:\MSDE2005)
- From the SAME command prompt browse to C:\MSDE2005
- Run this command setup INSTANCENAME="blackberry" SAPWD="insert strong password here" (this is a copy/paste from a blackberry support e-mail from 2005)
- *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 " insert strong password here" as the password.
- When it comes time in the install you will see SERVERNAME you add \blackberry to make it SERVERNAME\blackberry
