BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-19-2006, 04:19 AM   #1 (permalink)
mkc
New Member
 
Join Date: Sep 2005
Model: 9300
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Cannot connect to SQL Db

Please Login to Remove!

Hi, Newbie would like some advice if possible please!
I have a BES 4 server that was working fine connecting to another physical server that was running SQL 2000 SP3. All was well.
SQL server had the OS re-installed and from there it all went a bit odd. SQL server was not showing that SQL was installed and just looked like a bare bones setup. I reinstalled SQL over the top of what was there and re-connected the BESMgmt SQL database. I can see this fine in the SQL Enterprise Manager. During the installation of SQL the server changed from ServernameA to ServernameA\ServernamA. No doubt me entering wrong name. So in the SQL Server Service Manaer I can see ServernameA\ServernamA and Services as SQL Server running fine. Now, in BES I cannnot connect to DB when opening the BES Manager. Even if I run Blackberry Server Config Manager, it fails to connect with new details. What is going on!! Any advice or troubleshooting would be great. Kind regards
Offline  
Old 06-19-2006, 09:07 AM   #2 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2005
Model: 8320
Carrier: T-Mobile
Posts: 21
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sounds like the master table is missing entries. Using the Blackberry Server Configuration tool you need to create a blank BESMgmt database on the new instance (to create the master table entries). Then using the same tool create a BESMgmttest database (to unlock the BESMgmt DB). Now restore the original BESMgmt database over top of the existing BESMgmt db on your new SQL instance. Then using the Blackberry Server Configuration tool to connect your BES to this BESMgmt database. See Knowledge base document KB-03112 for more info.
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

20Pcs At24c32 At24c32a 2-Wire Serial Eeprom Memory Dip Ic New I
$2.23
20Pcs At24c32 At24c32a 2-Wire Serial Eeprom Memory Dip Ic New I picture5Pcs At24c32 At24c32a 2-Wire Serial Eeprom Memory Dip New Ic X
$0.99
5Pcs At24c32 At24c32a 2-Wire Serial Eeprom Memory Dip New Ic X pictureArduino DS3231 ZS042 AT24C32 IIC Module Precision RTC Real time Clock Memory
$0.66
Arduino DS3231 ZS042 AT24C32 IIC Module Precision RTC Real time Clock Memory pictureMemory Card Connectors 26P HOST CONN TP MNT ref 10053826-100ABTLF
$800.0
Memory Card Connectors 26P HOST CONN TP MNT ref 10053826-100ABTLF pictureSET OF (2) MR16R0828BN1-CK8 SAMSUNG 256MB TOTAL 2X128MB 800-45 RAM MEMORY
$2.27
SET OF (2) MR16R0828BN1-CK8 SAMSUNG 256MB TOTAL 2X128MB 800-45 RAM MEMORY picture






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