BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 07-14-2010, 08:21 AM   #1
Mikey_AGBoston
Thumbs Must Hurt
 
Join Date: Dec 2005
Model: 9330
Carrier: Verizon
Posts: 75
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
knottyrope
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: DT60
OS: 123456789
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,325
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.
__________________
I had to fall
To lose it all
But in the end
It doesn't even matter

Rocking the Motion with out lotion.
Offline  
Old 07-14-2010, 10:29 AM   #3
Mikey_AGBoston
Thumbs Must Hurt
 
Join Date: Dec 2005
Model: 9330
Carrier: Verizon
Posts: 75
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
Mikey_AGBoston
Thumbs Must Hurt
 
Join Date: Dec 2005
Model: 9330
Carrier: Verizon
Posts: 75
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
lion777
New Member
 
Join Date: May 2010
Model: 8520
PIN: N/A
Carrier: Telstra
Posts: 7
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
jjbova
Thumbs Must Hurt
 
Join Date: Sep 2009
Location: Ft. Bragg
Model: 9000
OS: 4.6.0.304
PIN: N/A
Carrier: ATT
Posts: 67
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
Mikey_AGBoston
Thumbs Must Hurt
 
Join Date: Dec 2005
Model: 9330
Carrier: Verizon
Posts: 75
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


PROFACE PFXSP5B10 Processor Module picture

PROFACE PFXSP5B10 Processor Module

$1500.00



Schneider 140CPU65150 Processor/Controller MODICON Quantum NEW picture

Schneider 140CPU65150 Processor/Controller MODICON Quantum NEW

$2899.00



AlphaSmart Neo2 Laptop Word Processor, . picture

AlphaSmart Neo2 Laptop Word Processor, .

$90.00



New Factory Sealed AB 1747-L542 SER B SLC 500 5/04 CPU Processor Unit 1747L542 picture

New Factory Sealed AB 1747-L542 SER B SLC 500 5/04 CPU Processor Unit 1747L542

$278.00



New Allen-Bradley AB 1747-L532 /D SLC 500 SLC 5/03 CPU Processor Unit 1747L532 picture

New Allen-Bradley AB 1747-L532 /D SLC 500 SLC 5/03 CPU Processor Unit 1747L532

$394.70



AB 1756-L73 SER B ControlLogix Logix5573 Processor 1756-L73 New Factory Sealed picture

AB 1756-L73 SER B ControlLogix Logix5573 Processor 1756-L73 New Factory Sealed

$2926.50







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