BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 07-14-2010, 09:21 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 Changing SQL instances in 5.0.2

Please Login to Remove!

There are two ways to cut over to a different ( mirrored ) SQL instance in 5.0.2

1. We either have to edit 4 registry keys for DatabaseServerMachineName
However we have been told by RIM that while they don't support this method of fail over, it should work

or

2. Rerun the installer

Thoughts, comments?
__________________
BES: 5.0.2, SQL 2005 (remote)/ WIN2K8,R2 / EXCHANGE 2010, RTM+RU4

Last edited by Mikey_AGBoston : 07-14-2010 at 09:52 AM.
Offline  
Old 07-14-2010, 11:27 AM   #2 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Passp
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,817
Post Thanks: 287
Thanked 305 Times in 287 Posts
Default

In BlackBerry Enterprise Server 4.0 and 4.1, the Change Database button is available in the BlackBerry Server Configuration Panel. This option is no longer available as of BlackBerry Enterprise Server version 5.0.
To configure the BlackBerry Enterprise Server to use a new BlackBerry Configuration Database or a new database server, the BlackBerry Enterprise Server setup application must be run again. The default location of the setup executable is C:\Research In Motion\BlackBerry Enterprise Server 5.0.0\setup.exe
NOTE: After the setup has completed and the services restarted, message flow and organizer synchronization will continue as usual. No interaction is required by the BlackBerry smartphone users.


looks like a tough choice, I would rerun the installer.
__________________
unlock you phone here http://cellunlocker.net/blackberry-unlock.php
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Passport, Z30, Z10 and Q10
Offline  
Old 07-14-2010, 11:29 AM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Dec 2005
Model: 9330
Carrier: Verizon
Posts: 75
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

if the installer is rerun, are SPs and MRs required again, as well?
__________________
BES: 5.0.2, SQL 2005 (remote)/ WIN2K8,R2 / EXCHANGE 2010, RTM+RU4
Offline  
Old 07-14-2010, 01:32 PM   #4 (permalink)
Thumbs Must Hurt
 
Join Date: Dec 2005
Model: 9330
Carrier: Verizon
Posts: 75
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have just tested the SQL db failover to a new instance name, by means of editing the registry entries for DatabaseServerMachineName and it did work.
__________________
BES: 5.0.2, SQL 2005 (remote)/ WIN2K8,R2 / EXCHANGE 2010, RTM+RU4
Offline  
Old 08-18-2010, 04:28 AM   #5 (permalink)
New Member
 
Join Date: May 2010
Model: 8520
PIN: N/A
Carrier: Telstra
Posts: 7
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Mikey,

I thought of this solution in the morning. You have wrote that "have to edit 4 registry keys", can you provide the path for 4 registry keys.

Cheers!!
Offline  
Old 08-18-2010, 07:55 AM   #6 (permalink)
Thumbs Must Hurt
 
Join Date: Sep 2009
Location: Ft. Bragg
Model: 9000
OS: 4.6.0.304
PIN: N/A
Carrier: ATT
Posts: 67
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

My question is, instead of switching DB's, what if I wanted to use the same DB on SQL, but I wanted a fresh install of BES 5.0.1? Basically we are having issues with our server, and want to re-image the box, reload BES, and point it at the DB, will this cause any issues or will the users/DB pick right back up?
Offline  
Old 08-18-2010, 08:37 AM   #7 (permalink)
Thumbs Must Hurt
 
Join Date: Dec 2005
Model: 9330
Carrier: Verizon
Posts: 75
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by lion777 View Post
Hi Mikey,

I thought of this solution in the morning. You have wrote that "have to edit 4 registry keys", can you provide the path for 4 registry keys.

Cheers!!
HKEY_CURRENT_USER
> SOFTWARE
>>RESEARCH IN MOTION
>>>BLACKBERRY ENTERPRISE SERVER
>>>>DATABASE
=====DatabaseServerMachineName:

HKEY_LOCAL_MACHINE
> SOFTWARE
>>Wow6432Node
>>RESEARCH IN MOTION
>>>BLACKBERRY ENTERPRISE SERVER
>>>>DATABASE
=====DatabaseServerMachineName:

HKEY_USERS:
>S-1-5-21-1600150946-976098915-2076119496-17392
>> SOFTWARE
>>>RESEARCH IN MOTION
>>>>BLACKBERRY ENTERPRISE SERVER
>>>>>DATABASE
=====DatabaseServerMachineName:

HKEY_USERS:
>S-1-5-21-1600150946-976098915-2076119496-500
>> SOFTWARE
>>>RESEARCH IN MOTION
>>>>BLACKBERRY ENTERPRISE SERVER
>>>>>DATABASE
=====DatabaseServerMachineName:
__________________
BES: 5.0.2, SQL 2005 (remote)/ WIN2K8,R2 / EXCHANGE 2010, RTM+RU4
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





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