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


5pcs 12V 4

5pcs 12V 4" WIRE LEADS Waterproof On-Off Push-Button Switch for Motorcycle Car

$7.19



5X Toggle SWITCH Rocker Heavy Duty 30A 125V SPDT 2 Terminal Car Boat Waterproof  picture

5X Toggle SWITCH Rocker Heavy Duty 30A 125V SPDT 2 Terminal Car Boat Waterproof

$6.99



W1209 12V -50-110°C Digital Thermostat Temperature Control Switch Sensor Module picture

W1209 12V -50-110°C Digital Thermostat Temperature Control Switch Sensor Module

$5.89



Toggle SWITCH ON/OFF Heavy Duty 15A 125V SPST 2 Terminal Car Boat Waterproof ORG picture

Toggle SWITCH ON/OFF Heavy Duty 15A 125V SPST 2 Terminal Car Boat Waterproof ORG

$3.49



20PCS ROCKER SWITCH Toggle 12V Led Light Car Auto Boat Round ON/OFF SPST 20 AMP picture

20PCS ROCKER SWITCH Toggle 12V Led Light Car Auto Boat Round ON/OFF SPST 20 AMP

$7.89



5X Black M4 12mm Waterproof Momentary ON/OFF Push Button Round SPST Switch picture

5X Black M4 12mm Waterproof Momentary ON/OFF Push Button Round SPST Switch

$6.95







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