BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 01-04-2006, 02:27 PM   #1
jrowland
New Member
 
Join Date: Dec 2005
Model: 7105T
Posts: 1
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
T-Roy
CrackBerry Addict
 
T-Roy's Avatar
 
Join Date: Jan 2005
Model: 8800
Carrier: Darth Vader
Posts: 704
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
doni
Knows Where the Search Button Is
 
Join Date: Sep 2005
Model: 8830
Carrier: Verizon
Posts: 43
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  
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


BISSELL 3-in-1 Turbo Lightweight Stick Vacuum, 2610 (Black) picture

BISSELL 3-in-1 Turbo Lightweight Stick Vacuum, 2610 (Black)

$36.06



Bissell 3-in-1 Lightweight Corded Stick Vacuum 2030 picture

Bissell 3-in-1 Lightweight Corded Stick Vacuum 2030

$27.44



Shop Vacuum upholstery extractor conversion kit auto vac detail carpet or home.  picture

Shop Vacuum upholstery extractor conversion kit auto vac detail carpet or home.

$192.00



4.5 CFM Single-Stage Rotary Vacuum Pump HVAC/Auto AC 4.5CFM 1/3HP 1/4

4.5 CFM Single-Stage Rotary Vacuum Pump HVAC/Auto AC 4.5CFM 1/3HP 1/4"ACME inlet

$59.89



3 CFM Air Vacuum Pump HVAC Manifold Gauge Set AC A/C Refrigeration Kit picture

3 CFM Air Vacuum Pump HVAC Manifold Gauge Set AC A/C Refrigeration Kit

$49.50



DZ-260C Chamber Vacuum Sealing Packing Machine 320W Commercial Vacuum Sealer picture

DZ-260C Chamber Vacuum Sealing Packing Machine 320W Commercial Vacuum Sealer

$289.99







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