Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

Reply
Visitor
Posts: 1
Registered: ‎07-06-2009
My Device: Not Specified

Upgrade MSDE to SQL Express

I have a single BES server (4.1 sp6)  hosting about 50 users.  My existing database is a local install of MSDE 2000 SP3.  I'd like to upgrade to SQL Express.  What's the process?  Are there any issues.

 

I'm assuming I backup my existing DB

Stop Services

Run the upgrade using "Default Instance"

 

Can't seem to fine any definite instructions or advice for my given local environment.

 

Any info would be appreciated, even if it's a simple link to a KB article.

 

Thanks!

Guru III
Posts: 32,126
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry PRIV, Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook,BT Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: Upgrade MSDE to SQL Express

[ Edited ]

How to move the BlackBerry Configuration Database to a new Microsoft SQL Server instance

http://www.blackberry.com/btsc/KB03112

 

BlackBerry Enterprise Server support for Microsoft SQL Server 2005 Express

http://www.blackberry.com/btsc/KB12174

Message Edited by knottyrope on 07-06-2009 01:52 PM

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


Highlighted
Forums Veteran II
Posts: 2,744
Registered: ‎04-01-2008
My Device: Bold

Re: Upgrade MSDE to SQL Express

There are no published instructions for this process ... honestly any time I've done this I've backed up the database and then uninstalled MSDE.  I've then installed SQL Express.  The issue with this process is maintaining permissions of the accounts that exist within the server.

 

After taking a backup of the database check out how you have permissions / users configured within sql server (msde) ... just in case you have to uninstall / reinstall and the upgrade fails

 

http://www.valesoftware.com/products-msde-manager.php ... good for a trial download.

------------------------------
If you've found a solution through a post; please mark it as a solution.
If someone's was particularly helpful, give them kudo's!.


Get busy living, or get busy dying.

http://blog.port3101.org/hdawg/