BlackBerry Forums Support Community               

Closed Thread
LinkBack Thread Tools
Old 01-04-2008, 12:06 AM   #1 (permalink)
New Member
Join Date: Jan 2008
Location: Brisbane, Australia
Model: None
Carrier: --
Posts: 3
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Changing SQL Password

Please Login to Remove!

Sorry guys - I'm fairly new to this BES admin lark!

We have a remote MSSQL2k database, and I'm attempting to change the SQL Password we use for the Blackberry configuration.

The password is easy enough to change on the SQL Server, but when we restart the SQL Services (on the SQL Server) we start to get error messages in the SQL Server Enterprise Manager: "Login failed for user 'svc_bb1_configuration'."

I have checked the Blackberry Server Configuration app on the BES, and we apparently are using Windows Authentication (according to the Database Connectivity tab). At a hunch, I checked the Registry and found the old password there..

My question is - do I just make the change to all of the relevant entries directly through regedit, or is there somewhere in a/the GUI where I can change this..? (I'm hesitant to make the change directly to the Registry) What process should I follow to change this password (both on the BES and SQL Server), as I'd like to document this process for future use..??

Thanks so much for your help with this..!
Old 01-04-2008, 02:37 AM   #2 (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
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts

If you are using Windows Authentication for BES, there is no SQL password. The password is that Windows Admin account's rather. Which SQL password have you changed exactly? More details will be good.
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Old 01-08-2008, 05:54 PM   #3 (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

Are you using MSDE or are you using the full version of SQL? If MSDE, there are instructions online on how to change the sql db password and to ensure it is authenticating with windows and sql password.

If its Full version of sql, you can look in the database properties and also ensure the logins are correct.

Also, re-run the blackberry setup on the server--Start-Programs-BlackBerry Enterprise Server-Blackberry Configuration and ensure you have the authentication working properly and able to connect to the database.

By the way, after changing the password, dont forget to re-start the sql services.

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