BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 10-22-2005, 03:09 AM   #1 (permalink)
RK1
New Member
 
Join Date: Oct 2005
Location: Washington, DC
Model: 8800
Carrier: Cingular
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Question SQL Error with BES 4.0 with Domino 6.5.1

Please Login to Remove!

I am testing BES 4.0 with Domino. I am getting this Error when I launch Domino: Unable to open BESMgmt database: [Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.[SqlState 08001][ODBCDatabase::Connect]Unable to connect to BESMgmt

Any help would be really appreciate it. I have been trying to fix this issue for 2 days now. I have spent 3 hours with RIM today with no luck.

Thank you.
Offline  
Old 10-22-2005, 08:31 AM   #2 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

did you enable TCP/IP for the SQL connection? i've never even seen it attempt a connection through Named Pipes.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 10-24-2005, 02:08 AM   #3 (permalink)
Talking BlackBerry Encyclopedia
 
boma0021's Avatar
 
Join Date: Jan 2005
Location: LE
Model: Pearl
Carrier: T-Mobile
Posts: 202
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

are the SQL access permissions set correct
Offline  
Old 10-24-2005, 10:55 AM   #4 (permalink)
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Post Thanks: 0
Thanked 17 Times in 16 Posts
Default

Assuming everything (Domino and SQL) is working fine and your using SQL authentication but you cannot connect to the SQL server try this.

On the BES check for these keys:

HKEY_USERS\.DEFAULT\Software\Research In Motion\BlackBerry Enterprise Server\Database\Login (Value should be the SQL login username)

HKEY_USERS\.DEFAULT\Software\Research In Motion\BlackBerry Enterprise Server\Database\Password (Value should be the SQL login password)

I originally had this problem upgrading to BES 4.0 I assumed they fixed it by now.
Offline  
Old 10-25-2005, 09:22 AM   #5 (permalink)
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Default Set SQL Server to use "Mixed Mode"

If you have initially used "Windows Trusted" authentication and then switched to "SQL authentication", set your SQL server to use mixed mode. For more details, go to www.blackberry.com/support and search for mixed mode, there is a KB article on it...

Good luck - null_name
Offline  
Old 10-26-2005, 01:26 PM   #6 (permalink)
RK1
New Member
 
Join Date: Oct 2005
Location: Washington, DC
Model: 8800
Carrier: Cingular
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you all very much.
I have tried the MIX Mode. and the new Keys in the Registry
HKEY_USERS\.DEFAULT\Software\Research In Motion\BlackBerry Enterprise Server\Database\Login (Value should be the SQL login username)

HKEY_USERS\.DEFAULT\Software\Research In Motion\BlackBerry Enterprise Server\Database\Password (Value should be the SQL login password)

Now Everything is working great.
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

Murrelektronik 85660 Rectifier module *FREE SHIPPING*
$49.99
Murrelektronik 85660 Rectifier module *FREE SHIPPING* picture20PCS HER208 2A 1000V Rectifiers Diode
$0.99
20PCS HER208 2A 1000V Rectifiers Diode pictureWORLD WIDE WWW156 3A 1000V GENERAL RECTIFIER DIODE NTE156 ECG156 LOT OF 10PC
$8.0
WORLD WIDE WWW156 3A 1000V GENERAL RECTIFIER DIODE NTE156 ECG156 LOT OF 10PC pictureNTE NTE170 SI BRIDGE RECTIFIER DIODE 1000V 2A ECG170 LOT OF 10PC
$15.0
NTE NTE170 SI BRIDGE RECTIFIER DIODE 1000V 2A ECG170 LOT OF 10PC   pictureNTE NTE5312 SILICON BRIDGE RECTIFIER 8A 100V ECG5312
$3.5
NTE NTE5312 SILICON BRIDGE RECTIFIER 8A 100V  ECG5312 picture






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