BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-22-2006, 12:49 PM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Apr 2005
Model: 8700
Carrier: Swisscom EDGE
Posts: 24
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default application of a service pack on a BES with a remote SQL database

Please Login to Remove!

Hi,

one of my clients has a BES v 4.0 for Exchange 5.5, with the configuration database installed on a remote SQL server.

The BES is using SQL authentication to access the SQL database.

Everything is going OK since I installed it one year ago.

The problem is : I could only apply the hotfix 1, but NO service pack at all ! Every time I try to apply a service pack, I have an error : DB upgrade fqiled", or something similar. As if the BES was unable to connect to the DB ...

Is it possible to apply a service pack on a BES that has a remote SQL database directly with the setup.exe that comes with the service pack ? Could it be an authentication problem ?
What are the necessary permissions to have on the DB to be able to apply this patch ?

Once, I read about a CreateDB.exe file to run ON the SQL server itself, with a pre-configured CreateDB.cfg file. Is it the only way to patch a remote SQL database, or can it be done with the setup.exe rn from the BES ?
If I use the CreateDB.exe and CreateDC.cfg on the SQL server, do I still need to run the service pack setup.exe on the BES ?

I plan to connect a BES v4.1 on this SQL database, to move users from the 4.0 BES to the 4.1 BES. Is there a minimum level of service pack I have to apply to the database to connect a BES v4.1 on it ?

I hope you understood everything !

I really need some help this time. I usually find my solution in this wonderful forum, but not this time !!!!!

Thanks in advance


connecter un BES 4.1 sur la DB SQL : quel niveau de SP minimum ?
Offline  
Old 06-22-2006, 06:27 PM   #2 (permalink)
Thumbs Must Hurt
 
elgauchogrub's Avatar
 
Join Date: Apr 2005
Location: Seattle, WA
Model: 8800
Carrier: Cingular
Posts: 58
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default CreateDB Utility

You're not alone with the DB upgrade issues, we've done 6-7 of them between service packs and full version upgrades, and not a single one has worked by running setup.exe.

As far as Creatdb.exe, I wish that still worked! I was told by T-Support that it's no longer an option once you're on 4.0. We pretty much used that as the default procedure since setup.exe was so unreliable.

You will need to upgrade your database to version 4.1 in order to run that version of BES. I've been testing the 4.0-4.1 migration the last couple days, and found that unlike previous versions, the setup.exe route actually worked the 2nd time I ran it. The only error I got was on one of the last parts of the database upgrade, and this was resolved by temporairly granting the SQL user account Setup Administrator permissions and running it again.
Offline  
Old 06-26-2006, 09:38 AM   #3 (permalink)
Knows Where the Search Button Is
 
Join Date: Apr 2005
Model: 8700
Carrier: Swisscom EDGE
Posts: 24
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your reply !

I finally could convince the client to install a second BES (that was part of the migration project) with a temporary SRP ID, and I installed it in 4.0.4 hotfix 3 with a local MSDE database.

Once it was up and running, I simply moved the DB to a SQL server. So my client has now a patched BES running with a remote SQL database.

My client will move all users from the first BES to the second (unfortunately, 2 enterprise activations will be needed : one for the first move between BESs, one when I'll put the regular SRP ID on the second BES).

But the client is OK for that.

anyway, even if my problem is solved, could anyone tell me what could be the reason why I couldn't patch this database ?

Thanks
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.