Upgrading a BES 5.0.2 MSDE installation to BES 5.0.3

BrightPoint GB

BrightPoint GB

Device Lifecycle Services.

Delivered.

Plan. Market. Customize. Move. Recycle.

More...
Samsung Galaxy S III

Samsung Galaxy S III

Designed For Humans

Inspired By Nature

This sleek and innovative smartphone has the enhanced intelligence to make everyday life easier.

More...
BlackBerry Curve 9320

BlackBerry Curve 9320

Socially Connected

3G capable

Featuring all of the core messaging and social features to keep you connected.

More...
HTC One X

HTC One X

Technology Leader

Quad Core Android 4.0

Perfect for gaming, watching videos and surfing the net

More...
HTC One V

HTC One V

Iconic Design

A great all-rounder

ImageSense technology, Beats Audio, wireless media streaming, cloud storage and more...

More...
ZTE Tania

ZTE Tania

Windows Phone Mango

Fully equipped

Great for business and pleasure

More...
BlackBerry Bold 9790

BlackBerry Bold 9790

BlackBerry OS7

Powerful & Fully Featured

Smooth performance for browsing the web, running apps, working with documents, and enjoying multimedia

More...
HTC Sensation XL

HTC Sensation XL

Feel every beat

With Beats Audio

A multimedia superstar with Beats earphones included.

More...
HTC Titan

HTC Titan

Unlike anything you've ever held before

Office on the move

Windows Phone 7.5 (Mango). With a 4.7-inch screen and big virtual keyboard, the Titan is perfect for both work and play.

More...
HTC Radar

HTC Radar

Real time close

Windows Phone 7.5 (Mango)

Pull all your contacts and social networks together into one place to stay connected with friends and share instantly.

More...
BlackBerry Bold 9900

BlackBerry Bold 9900

Slim yet powerful

Touch and Type in harmony

The Bold 9900 is RIM's thinnest BlackBerry smartphone yet and as lightweight and durable as it is feature-packed.

More...
ZTE Libra

ZTE Libra

Affordable Android

WiFi hotspot, Exchange email, Google Maps and much, much more all at an attractive price.

More...
ZTE MF30/MF60

ZTE MF30/MF60

Portable Internet

USB & WiFi for Windows and Mac

High speed, portable Internet access in your pocket.

More...
Motorola Defy +

Motorola Defy +

Lifeproof

Faster, smarter, richer

Scratch, dust and water-resistant. 1GHz processor, 5MP camera and great pre-loaded apps.

More...
BlackBerry Curve 9380

BlackBerry Curve 9380

BlackBerry OS7

The 1st all-touch Curve

Easily capture and share your favourite moments with family, friends and colleagues.

More...
Samsung Galaxy S2

Samsung Galaxy S2

Faster. Slimmer. Brighter.

Prepare yourself for the Galaxy S II, Samsung's thinnest smartphone.

More...
HTC Sensation XE

HTC Sensation XE

With Beats Audio

Designed to impress

With custom Beats headphones, engineered to deliver extraordinary sound.

More...
ZTE Skate

ZTE Skate

Affordable Android

WiFi hotspot, Exchange email, Google Maps and much, much more all at an attractive price.

More...
HTC Explorer

HTC Explorer

A design that fits your lifestyle

Keep in touch with the people who matter

Jump right into what's most important to you thanks to an improved lockscreen design.

More...
ZTE Tureis

ZTE Tureis

Full Qwerty 2.6-inch touchscreen

Android Gingerbread

Business and social features in a slim package.

More...
Frontpage Slideshow (standalone) | Copyright © 2006-2011 JoomlaWorks Ltd.

With the release of BlackBerry Enterprise Server 5 Service Pack 3 (5.0.3), RIM have dropped support for the Microsoft SQL Desktop Engine (MSDE).
If you have upgraded a previous version 4.x BlackBerry server to version 5.x and wish to upgrade to 5.0.3, you will receive an error message stating that you do not have a supported database platform and the upgrade will not proceed any further.

The MSDE installation must be upgraded to SQL Server 2005 Express or later in order to install BES 5.0.3
In this article I shall run through how I installed SQL Server Express 2008 in order to upgrade from BES 5.0.2 and MSDE to BES 5.0.3 - note this is not an official RIM solution.

Stop and disable all BlackBerry services

Open the Service Control Manager (Start --> Run --> "services.msc").
Stop all running BlackBerry services.
Edit the properties of all BlackBerry services that have a Startup Type of "Automatic", and set them to "Disabled".

Upgrading a BES 5.0.2 MSDE installation to BES 5.0.3

Download and install SQL Server Express 2008

NOTE - you will also need to download and install Windows Installer 4.5 in order to run the SQL installer.
Install a new SQL instance rather than upgrading the existing installation. Select the option to install the management tools (selected by default).

Backup the BESMgmt Database

Open the SQL Management Studio and connect to the MSDE instance (normally the servername).
Take a full backup of the BESMgmt database to a file location.

Upgrading a BES 5.0.2 MSDE installation to BES 5.0.3

If you receive an error that the file is in use, stop the running MSDE instance.

Upgrading a BES 5.0.2 MSDE installation to BES 5.0.3

Restore the BESMgmt Database

Still within the SQL Management Studio, disconnect from the MSDE instance and connect to the SQL 2008 instance (normally servername\sqlexpress)
Right click on Databases and select the option to Restore Database.
Enter a name for the new database, such as BESMgmt2
Select the option to restore from Device, and add the backup file you created earlier.

Upgrading a BES 5.0.2 MSDE installation to BES 5.0.3

Ensure the restore operation completes successfully and then close the SQL Management Studio.

Enable SQL TCP/IP connectivity

Open the SQL Configuration Manager. Browse to SQL Server Network Configuration --> Protocols for SQLExpress.
Right click on TCP/IP and Enable it.

Upgrading a BES 5.0.2 MSDE installation to BES 5.0.3

Close the SQL Configuration Manager.
Stop the MSDE instance from running at startup.

Upgrading a BES 5.0.2 MSDE installation to BES 5.0.3

Reboot the server.

Re-enable BlackBerry services

Open the Service Control Manager and change the Startup type for all BlackBerry services we disabled earlier back to Automatic. Do not start the services at this time.

Install BES 5.0.3

Start the MSDE SQL instance.
Now launch the BES 5.0.3 installer.
Set the database server to the SQL 2008 instance (servername\sqlexpress)
Set the name of the configuration database to the database you created earlier from the backup.
Set the Port configuration to "Dynamic"

Upgrading a BES 5.0.2 MSDE installation to BES 5.0.3

The installation will now proceed.