BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 07-14-2010, 08: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 08:52 AM.
Offline  
Old 07-14-2010, 10:27 AM   #2 (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,215
Post Thanks: 369
Thanked 376 Times in 346 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 your phone here http://freemyblackberry.com/
I am on http://supportforums.blackberry.com
BES 12 running sweet for my DTEK60
Offline  
Old 07-14-2010, 10: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, 12: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, 03: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, 06: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, 07: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

SMAKN� USB Programmer CH341A Series Burner Chip 24 EEPROM BIOS LCD Writer 25
$13.63
SMAKN� USB Programmer CH341A Series Burner Chip 24 EEPROM BIOS LCD Writer 25 picture1PC NEW Mitsubishi FX3G-EEPROM-32L
$100.99
1PC NEW   Mitsubishi FX3G-EEPROM-32L picture10 pcs CAT24C02J-TE3 2Kb SERIAL EEPROM 256x8 SOP 8-Pin Catalyst #E4104
$6.0
10 pcs CAT24C02J-TE3 2Kb SERIAL EEPROM 256x8 SOP 8-Pin Catalyst #E4104 pictureATMEL AT17LV010A-10JC AT17LV010A 1M Bit Altera FPGA EEPROM IC SMD **NEW** Qty.1
$4.99
ATMEL AT17LV010A-10JC AT17LV010A 1M Bit Altera FPGA EEPROM IC SMD **NEW** Qty.1 pictureEZP2010 Bios Chip USB High Speed SPI Programmer Kit EEProm Flash 24Cx 25Cx 93C
$31.95
EZP2010 Bios Chip USB High Speed SPI Programmer Kit EEProm Flash 24Cx 25Cx 93C  picture






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