BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-19-2005, 08:49 AM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2005
Model: 7230
Posts: 16
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem with BES connecting to SQL server

Please Login to Remove!

I am setting up a 2nd BES 4.0 server which will connect via SQL to an existing BES config db on a separate SQL server. After setting up the server and configuring, I can connect fine from the Blackberry Server Configuration to the existing SQL database. I have also followed the instructions in the Install manual that talks about adding the username and password for the SQL account login to the Default section in the registry. In addition, I have gone in on the ODBC section and done the same and was able to connect fine from there. When I start the BES, the error that comes up is:
"Unable to open BESMgmt database [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '[null]". Reason: Not associated with a trusted SQL Server connection.[SQLState 28000]
[ODBCDataabaseConnect]Unable to connect to bESMgmt on machine MOXBE5.

The SQL server is set to authenticate using SQL credentials, so that eliminates a Windows login being the issue. All ODBC settings from the new server are set to use SQL authentication. Somewhere it is not picking up the username to use to connect. Any help would be appreciated, as this is a test server and our RIM support contract doesn't cover support for test servers. I need to nail this down in order to document how to install a new BES server in our environment. Thanks.
Offline  
Old 08-19-2005, 10:20 AM   #2 (permalink)
CrackBerry Addict
 
rsun's Avatar
 
Join Date: Oct 2004
Location: Delaware, USA
Model: 8320
Carrier: at&t/T-Mobile/Verizon
Posts: 747
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

is this BES Domino or BES Exchange? We had this problem with BES Domino and in one of the read me's it says there's a bug where you have to hard code something in the registry for it to connect.
__________________
Richard Sun
[email address]
Offline  
Old 08-19-2005, 05:24 PM   #3 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: May 2005
Model: 7100
Carrier: T-Mobile
Posts: 299
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Is you SQL Server set up for Mixed Authentication?
Offline  
Old 08-19-2005, 07:35 PM   #4 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2005
Location: Denmark
Model: 7230
Carrier: TDC
Posts: 102
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

If its domino you have to add username/password to the registry manually because its trying to use the computeraccount to login with (due to local system).

As a little side point

what the .... are RIM thinking when they require a high elevated sql account to be typed in clear text in the registry

<shake head>
Offline  
Old 08-22-2005, 06:40 AM   #5 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2005
Model: 7230
Posts: 16
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Answers to questions

Yes, this is a Domino server. I'm running 6.5.4 on it. As far as Mixed Authentication, it shouldn't come into play, as we are using SQL Authentication to the SQL server. My understanding is that this is only an issue if you are using Windows credentials to authenticate to the SQL server. As to the comment on the readme, do you know what registry entry must be changed (or added). I did add an entry for the username and password in the .Default section as indicated in the install manual.

I am just amazed that there is this much tinkering under the hood for the installation that, in my mind, should take care of it all. Is it just me or are the RIM installs just not ready for prime time? Thanks all for the responses.
Offline  
Old 08-22-2005, 08:16 AM   #6 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2005
Model: 7230
Posts: 16
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem solved

I was able to get things going once I got the correct registry key set up. I do find it amazing that they key has to be set manually, though. Particularly one so important that the BES server will not even start up without it.
Offline  
Old 11-07-2005, 09:41 AM   #7 (permalink)
Knows Where the Search Button Is
 
Join Date: Apr 2005
Model: 8800
Carrier: Vodafone
Posts: 15
Post Thanks: 0
Thanked 0 Times in 0 Posts
Angry Help

So can someone confirm what the registry keys are?

I've seen the other post listing them but that path doesn't exisit on my server. The RIM keys are under HKEY_LOCAL_MACHINE\Software\Research In Motion\BlackBerry Enterprise Server\Database

I added the Login and Password Values under the Database key here but I still get the

Unable to open BESMgmt database: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed ###########'.[SqlState 28000][ODBCDatabase::Connect]Unable to connect to BESMgmt on machine ######
Offline  
Old 11-07-2005, 09:48 AM   #8 (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

Quote:
Originally Posted by tickler
So can someone confirm what the registry keys are?

I've seen the other post listing them but that path doesn't exisit on my server. The RIM keys are under HKEY_LOCAL_MACHINE\Software\Research In Motion\BlackBerry Enterprise Server\Database

I added the Login and Password Values under the Database key here but I still get the

Unable to open BESMgmt database: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed ###########'.[SqlState 28000][ODBCDatabase::Connect]Unable to connect to BESMgmt on machine ######
That's the wrong location. It belongs in HKEY_USERS\.DEFAULT\Software\Research In Motion\BlackBerry Enterprise Server\Database

This is not a pre-existing key. You have to create it.
Offline  
Old 11-08-2005, 11:39 AM   #9 (permalink)
Knows Where the Search Button Is
 
Join Date: Apr 2005
Model: 8800
Carrier: Vodafone
Posts: 15
Post Thanks: 0
Thanked 0 Times in 0 Posts
Talking Working

I've got this working now and I left the keys where they were in HKEY_LOCAL_MACHINE\Software\Research In Motion\BlackBerry Enterprise Server\Database

The problem was with the LocalSystem account that Lotus Domino Server service starts with.

See this KB article KB-03543 at the BlackBerry Technical Knowledge Center


Only problem is that you can't have the service interact with the desktop when you change the account that the service starts with so you don't get a console when the server starts. I've got around this by using a Java Console.

Add -jc to the end of the cmd line for the service, you have to do this via registry

HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\L otus Domino Server (LotusDominoData)

Add -jc to the end of the ImagePath value

You then run the jconsole.exe to see it

Hope this helps anyone.

Last edited by tickler : 11-08-2005 at 11:44 AM.
Offline  
Old 11-16-2005, 11:19 AM   #10 (permalink)
New Member
 
Join Date: Nov 2005
Model: 7520
Carrier: Nextel
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Windows 2000 vs. 2003

I initially installed BES v4.0 and Lotus Domino 6.5.4 on a Windows 2003 server and connected it to a SQL server running on a separate Windows 2000 server. Lotus Domino ran as a service using the Local System account. All was fine running this way. I simply added DOMAIN\<computer>$ to the SQL database to use NT Authenication. Not too long ago, our DB Admins moved the SQL server to a Windows 2003 Server. At that point my BES v4.0 server could no longer connect to it. I grudgingly changed the Lotus Domino Server Service to run as a domain account and things started to work. To me this points to a problem with SQL and Windows.

Why would it work the preferred way with SQL on Windows 2000 but not Windows 2003?
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.