BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 01-24-2008, 02:45 PM   #1 (permalink)
New Member
 
Join Date: Jan 2008
Model: 7100T
PIN: N/A
Carrier: T-Mobile
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Blackberry Manager prompts for SQL database password

Please Login to Remove!

I recently updated a client's BES from 4.1.2 to 4.1.4. I made a few mistakes in the update process (I didn't use the bes service account to do the update) but believe I have corrected all of those issues...

My one remaining problem is that I'm being prompted for the sa password when I open the Blackberry manager regardless of which account I'm logged in with. When I did the update I mistakenly chose ot use Windows Authentication to the SQL 2000 database. I've corrected the issue in the blackberry server configuration utility, tested the connection successfully and have followed this blackberry kb article to add the password to the registry:

BlackBerry Search Results

The server's been restarted several times since the update... Any thoughts on how I can get the server to cache the sa password for the BESMgmt DB on the SQL box?
Offline  
Old 01-24-2008, 04:25 PM   #2 (permalink)
BlackBerry Extraordinaire
 
gibson_hg's Avatar
 
Join Date: Dec 2007
Model: NA
PIN: 80081ES
Carrier: NA
Posts: 1,006
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try this KB:

BlackBerry Search Results

The reg key at the end is what you want check.

Hopefully that'll get ya workin.
Offline  
Old 01-24-2008, 05:36 PM   #3 (permalink)
New Member
 
Join Date: Jan 2008
Model: 7100T
PIN: N/A
Carrier: T-Mobile
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks but that didn't do the trick...

When I opened the BES management console with a user who has administrative priviledges on the BES I received a popup message stating that the trusted credentials failed to access the database.

The database connection window then appears and I have to type in the SQL dbowner username/password to access the database.

I spoke with the DBA's who added a new account to the BESMGMT database and made it a dbowner. The same symptoms occur when I configure the BES to use these credentials in the Blackberry Server Configuration utility.

Do I need to add the windows user name(s) or security group to the BESMgmt database for "pass thru" authentication to occur? If so what permissions do I need to give these users/groups?
Offline  
Old 01-24-2008, 05:40 PM   #4 (permalink)
CrackBerry Addict
 
amukhey's Avatar
 
Join Date: Sep 2004
Location: Los Angeles
Model: 9700
Carrier: T-Mobile
Posts: 750
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Under Tools-Options in the BES manager, does it show you Windows or Database Authentication?

I would create a group in AD for a BlackBerry_Admin group and then add this group to the sql db. This way, everyone can use their windows authentication.
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.