BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 01-03-2008, 11:06 PM   #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, 01: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, 04: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





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