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.
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

3pcs/lot Black Refill Crystal Gel Pen Gel-Ink Pen Stationery
3pcs/lot Black Refill Crystal Gel Pen Gel-Ink Pen Stationery picture15-PCS CRYSTAL FREQUENCY IQD IQDTZ-15.000MHZ 15000 IQDTZ15000MHZ
15-PCS CRYSTAL FREQUENCY IQD IQDTZ-15.000MHZ 15000 IQDTZ15000MHZ pictureCrystal Vision ICM-360 Smoke Evacuation System
Crystal Vision ICM-360 Smoke Evacuation System pictureDurable Crystal Sign Holder For Office
Durable Crystal Sign Holder For Office pictureCRYSTAL CS8900A-CQ 8900 CS8900ACQ
CRYSTAL CS8900A-CQ 8900 CS8900ACQ picture

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