BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 09-10-2009, 08:27 AM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Dec 2005
Model: 9330
Carrier: Verizon
Posts: 75
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default MSDE to SQL

Please Login to Remove!

Planning on making the move from MSDE to SQL

Here are my stats:
Domino: 6.5.4 FP3
BES: 4.1.6 MR7
Users: 292

Going to be using a MSSQL 2005 server

So, beyond KB12247..

Anything noteworthy?
Experiences?
Offline  
Old 09-10-2009, 08:54 AM   #2 (permalink)
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Default

KB12247 is a good guide except that it never check:-

(1) if port 1433 is open from BES computer to your SQL server 2005
(2) if named pipe and tcpip is enabled on your SQL server 2005 (as BES is now a remote client to your SQL server)

Backup all your data, by that I mean backing up:-

(1) BES folder
(2) BESMgmt database
(3) Document your SRP ID, SRP Auth Key and CAL keys

Good luck, should be simple and straight forward.
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 09-10-2009, 09:48 AM   #3 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: PRIV
OS: 5.1.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,137
Post Thanks: 353
Thanked 354 Times in 331 Posts
Default

Also log in to SSMS as BESAdmin so permissions do not change when restoring the database. You can change the permissions back if logged in with diff account.
__________________
unlock your phone here http://freemyblackberry.com/
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Passport, Z30, Z10 and Q10
Online  
Old 09-10-2009, 08:53 PM   #4 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Mikey -

Print off the KB article and use it as a checklist. Don't skip steps ... please.
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

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

RARE Western Digital WD33C93A-PL Proto SCSI IC NEW Leftover for Amiga 3000 Etc
$39.95
RARE Western Digital WD33C93A-PL Proto SCSI IC NEW Leftover for Amiga 3000 Etc pictureCommodore AMIGA VISION Authoring System (Interactive Multimedia Software) 4 disc
$28.0
Commodore AMIGA VISION Authoring System (Interactive Multimedia Software) 4 disc pictureSMPTE Output Studio 16 Extras The Complete SMPTE Generator For Your Amiga
$14.99
SMPTE Output Studio 16 Extras The Complete SMPTE Generator For Your Amiga pictureMACROSYSTEM CASABLANCA-RARE-Amiga/Draco Video-Editor-PowersUp-NonProfit Org
$200.0
MACROSYSTEM CASABLANCA-RARE-Amiga/Draco Video-Editor-PowersUp-NonProfit Org pictureSaronix 33Mhz Crystal Oscillator 33.3000 Mhz Half Can NEW Amiga Apple PC NOS
$2.75
Saronix 33Mhz Crystal Oscillator 33.3000 Mhz Half Can NEW Amiga Apple PC NOS picture






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