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,177
Post Thanks: 361
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

1PCS Intel E10G42BFSR Ethernet Server Adapter 10Gbps Dual Port PCI-E X520-SR2
$129.99
1PCS Intel E10G42BFSR Ethernet Server Adapter 10Gbps Dual Port PCI-E X520-SR2 picture University of Miami waitress server waiter waist apron 3 pockets
$11.0
 University of Miami waitress server waiter waist apron 3 pockets pictureBlue apron Winnie Eeyore Tigger waitress server waiter waist apron 3 pockets
$11.0
Blue apron Winnie Eeyore Tigger waitress server waiter waist apron 3 pockets pictureLets go fishing waitress server waiter waist apron 3 pockets
$11.0
Lets go fishing waitress server waiter waist apron 3 pockets pictureBlack reversible NFL Eagles apron waitress server waiter waist apron 3 pockets
$12.0
Black reversible NFL Eagles apron waitress server waiter waist apron 3 pockets  picture






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