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
PIN: N/A
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..!
Scott
Offline  
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
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Default

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

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

2000 PCS THOMSON MC392KYC .003MF 10% 400V CAPACITORS
$3.99
2000 PCS THOMSON MC392KYC .003MF 10% 400V CAPACITORS picture50pcs 110uf 320V 110UF 10x38mm Nippon NCC Photo Flash PH capacitor
$15.79
50pcs 110uf 320V 110UF 10x38mm Nippon NCC Photo Flash PH capacitor picture12x10PCS Electrolytic Capacitor Package Capacitance Set #F8s
$2.45
12x10PCS Electrolytic Capacitor Package Capacitance Set  #F8s pictureLot of tiny old various picofarad capacitors 100v 50v monolithic mlcc caps pf nf
$25.0
Lot of tiny old various picofarad capacitors 100v 50v monolithic mlcc caps pf nf pictureEFD SP2558 20uf +5% 400 VEFF 00/3 660 2-Plug Capacitor + Free Priority Shipping
$20.0
EFD SP2558 20uf +5% 400 VEFF 00/3 660 2-Plug Capacitor + Free Priority Shipping picture






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