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

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.

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.