Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

Reply
New Member
Posts: 1
Registered: ‎09-07-2008
My Device: Not Specified

BES connect to SQL2005 DB problem

Hi folks,

 

We are running 2 BES 4.14(Prod and DR) and 2 SQL2005 DB(Prod and DR). In norma day, both BESs connect to Prod DB and only 1 BES server will start blackberry service.

Today we ran a drill with steps as below
1. Restore the BES DB from Prod DB server to DR DB server
2. Stop services in Prod BES and change database connection to DR DB server
3. Restart server and start service

I found the all service can start and have all existing users but I cannot perform user maintenance e.g. user activation and send IT policy while the mail service normal. In additional, the hostname(not instant name) in Blackberry Manager didn't update automatically.
The problem resume after database connection Prod DB server.

The strange problem was when we changed DR BES DB connection from Prod DB to DR DB same as above, all service and function run fine.

The problem is why Prod BES connect to DR DB with error while DR BES connect to same DR DB work fine.

Could someone help me on this, many thanks

Highlighted
Forums Veteran II
Posts: 2,744
Registered: ‎04-01-2008
My Device: Bold

Re: BES connect to SQL2005 DB problem

Did you follow the procedure listed in the KB article below entirely?  Specifically task 2, step 4

 

KB03112 - How to move the BlackBerry Configuration Database to a new Microsoft SQL Server or instanc...

------------------------------
If you've found a solution through a post; please mark it as a solution.
If someone's was particularly helpful, give them kudo's!.


Get busy living, or get busy dying.

http://blog.port3101.org/hdawg/