07-06-2009 01:14 PM
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
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.
I'm rockin the BlackBerry DTEK60, Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook,BT Headset HS-700
07-06-2009 01:48 PM - edited 07-06-2009 01:52 PM
How to move the BlackBerry Configuration Database to a new Microsoft SQL Server instance
BlackBerry Enterprise Server support for Microsoft SQL Server 2005 Express
BESAdmin's, please make a signature with your BES environment info.
BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V
07-07-2009 01:24 AM
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