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,197
Post Thanks: 368
Thanked 374 Times in 344 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 12 running sweet for my DTEK60
Offline  
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

Cinderella pink slippers waitress server waiter waist apron 3 pockets
$11.0
Cinderella pink slippers waitress server waiter waist apron 3 pockets pictureBlack apron Tennessee Vols waitress server waiter waist apron 3 pockets
$11.0
Black apron Tennessee Vols waitress server waiter waist apron 3 pockets pictureBlack apron Multicolor dot splash waitress server waiter waist apron 3 pockets
$11.0
Black apron  Multicolor dot splash waitress server waiter waist apron 3 pockets pictureUpdate International Sup-R-Serv Stainless Steel Push Button 8 Cup Coffee Server
$27.99
Update International Sup-R-Serv Stainless Steel Push Button 8 Cup Coffee Server pictureMOXA DE-311 NPort Express RS-232/422/485 Device Server, Lof of 2 = 80$
$79.9
MOXA DE-311 NPort Express RS-232/422/485 Device Server, Lof of 2 = 80$ picture






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