?
Solved

BES talking to MS SQL 2000

Posted on 2008-11-17
6
Medium Priority
?
730 Views
Last Modified: 2012-05-05
Hi All,

For one reason or another, we are going through a process of changing every password on our network. Everything is going to plan, until we get to BES.

We have 2 servers, BES and SQL Server 2000, of which they both talk to eachother. The majorty of the Blackberry services on BES use a domain 'Log On' account. This password has been changed successfully without issue.

I have since logged into the SQL Sever and changed the 'sa' password. As soon as that happens, BES stops working, and the event logs show the error:

"Unable to open BESMgmt database: Login failed for user 'sa'"

I cannot for the life of me find where I need to tell BES the new 'sa' password. I would have thought it shouldn't need it because of the domain service accounts - but it's obviously not the case. If it helps, we run a Lotus Domino email client.

Any help is very welcome. Many thanks,

Pete
0
Comment
Question by:PeterHing
  • 3
  • 3
6 Comments
 
LVL 11

Expert Comment

by:ALogvin
ID: 22980083
On your BES, run the BlackBerry Server Configuration Utility. There should be a section where you specifiy your database, and you can change the authentication username and password there.
0
 
LVL 2

Author Comment

by:PeterHing
ID: 22980536
Hi ALogvin,

You're Right, there is a 'Database Connectivity' tab which states the database and authentication method. At the moment, the authentication method is 'Windows (Trusted)'.

This is why i'm confused as to why BES fails to work when I change the 'sa' password locally on the SQL Server. It's using it somewhere - I just can't see where!

Any further ideas or if you can see where i'm going wrong, please don't be afraid to shout!

Pete
0
 
LVL 11

Expert Comment

by:ALogvin
ID: 22984690
I found this...

1.       Open the SQL Server Configuration Manager. (Start | All Programs | Microsoft SQL Server 2005 | Configuration Tools)

2.       Select the SQL Server 2005 Service node and then select the SQL Express instance that is no longer working.

3.       Open the Property dialog for the instance. (Right-click menu or Action | Properties)

4.       Change the 'Log on as:' selector to Local System and click Apply.

5.       Once the server has restarted, change the 'Log on as:' selector back to Network Service and click Apply.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 2

Author Comment

by:PeterHing
ID: 22985375
Hi ALogvin - Thanks for your reply.

We're currently using SQL Server 2000, so can't find that option unfortunately.

I have been digging a little more throughout the day, and ran SQL Profiler on the BESMgmt database. It appears it's the Blackberry Messaging Agent that's using the 'sa' credentials to access the database. Everything else appears to be using the network account for the database.

I now can't find anything referencing the Messaging Agent and a password? Does that help or give you any ideas?

Thanks again for your help so far.

Pete
0
 
LVL 11

Accepted Solution

by:
ALogvin earned 1600 total points
ID: 22985645
DOMINO!

http://www.blackberry.com/btsc/articles/750/KB03543_f.SAL_Public.html

http://www.blackberryforums.com/bes-admin-corner/13966-problem-bes-connecting-sql-server.html

This is a domino specific problem, which is why it took me so long to find it ;)


Looks like you will need to add a registry key to fix it. I've never done this...
0
 
LVL 2

Author Comment

by:PeterHing
ID: 22992512
ALogvin,

It worked perfectly, and allowed me to fix the problem. Thanks for sticking around to the end - a great help!

For anyone coming back to this post: You need to set the password in:
HKEY_USERS\.DEFAULT\Software\Research In Motion\BlackBerry Enterprise Server\Database
It's probably best to also restart BES after the change to ensure the Domino Connector works correctly

Thanks again,

Pete
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Once again I push the limits of my phone.  An introduction to the Android Google Now Launcher.
Let Bitmoji into your life. Now is the time to learn a new language of smartphone messaging with this brief introduction.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Loops Section Overview
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question