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.
Offline  
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
Default

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'
4>go
1>quit

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.

http://databasejournal.com/features/...le.php/2224361
Offline  
Old 06-05-2006, 09: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
Default

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!
Offline  




Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.