BlackBerry Forums Support Community               

Closed Thread
LinkBack Thread Tools
Old 01-04-2006, 02:27 PM   #1 (permalink)
New Member
Join Date: Dec 2005
Model: 7105T
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Exclamation Upgrading from MSDE 7 to MSDE 2000. Please help

Please Login to Remove!

I am in the process of upgrading my BES 3.6 to BES 4.0 and have been reviewing tons of documentation and I have the BES upgrade down pretty clear. However, I am still unclear as to the process of upgrading from MSDE7 to MSDE2000. I have searched microsoft and here for instructions but have not come up with anything that concisely documents the procedure. Does anyone have instructions on how to upgrade from MSDE 7 to MSDE 2000? What impact will this upgrade be on the BES during that time? Any assistance would be greatly appreciated.
Old 01-04-2006, 09:25 PM   #2 (permalink)
CrackBerry Addict
T-Roy's Avatar
Join Date: Jan 2005
Model: 8800
Carrier: Darth Vader
Posts: 704
Post Thanks: 0
Thanked 0 Times in 0 Posts

Uninstall MSDE 7
Install MSDE 2000a (setup.exe SAPWD="<password you choose>")
Start MSSQL Server Service
Attach Database:
Run osql -E
1>EXEC sp_attach_db @dbname = 'besmgmt',
2>@filename1 = 'C:\MSSQL7\Data\besmgmt.mdf',
3>@filename2 = 'C:\MSSQL7\Data\besmgmtlog.ldf'

Keep in mind your files maybe named different or in a different path.

Upgrade happy!

No impact on 3.6 BES as long as you do not stop/start the BES Services, but should still be done in a maintence window if problems arise.
Old 06-05-2006, 10:23 PM   #3 (permalink)
Knows Where the Search Button Is
Join Date: Sep 2005
Model: 8830
Carrier: Verizon
Posts: 43
Post Thanks: 0
Thanked 0 Times in 0 Posts

Trying to upgrade MSDE 7 to MSDE 2000a, completed the steps above (double-checking database names and paths), but receive event errors from BES service that cannot log in to the database. Seems to be an authentication error? I have made no other changes and I have enabled TCP/IP with the SQL tool (per KB article). Ideas? Thanks!
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Copyright 2004-2014
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.