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?
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
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts

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.
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,143
Post Thanks: 354
Thanked 361 Times in 336 Posts

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
I am on
BES 12 running sweet for my Privates
Old 09-10-2009, 08:53 PM   #4 (permalink)
BlackBerry Genius
hdawg's Avatar
Join Date: Aug 2006
Model: hdawg
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts

Mikey -

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

1/4" AC110V Pneumatic Aluminum Electric Solenoid Air Valve 3 Way 2 Position H9S5
1/41PC ASCO Solenoid Valve 8263H210 24/DC
1PC ASCO Solenoid Valve 8263H210 24/DC pictureTunze USA 7074.400 Solenoid Valve for Co2, 12-volt, New,
Tunze USA 7074.400 Solenoid Valve for Co2, 12-volt, New,  picture1PC Parker solenoid valve 121M14-8993-488980C2
1PC Parker solenoid valve 121M14-8993-488980C2 picture1PC SMC solenoid valve SYJ5240-5G
1PC SMC solenoid valve SYJ5240-5G picture

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