10-28-2013 02:15 AM
It's always good to check the manuals first. I'm attaching one for your convenience.
SQL passwords must be changed on the DB server (ask your DBA)
BSM Installation Guide
Appendix 3: Server Deployment and Setting Database Parameters
For information on
assigning a Windows user to run the BSM service, see "Changing BSM Service Users" on page 81.
For information on adding a Windows user to MS SQL Server, see "Using Windows Authentication
to Access Microsoft SQL Server Databases" in the BSM Database Guide
Hope this helps,
10-28-2013 09:53 AM
Passwords for BSM users are stored as encrypted strings, so you can't change them directly in the database with a SQL statement.
To change the "admin" user password, what you need to do is stop BSM, then run the configuration wizard again.
Just attach to the existing databases you've already created, and then you will get to a screen that will let you set the admin user password.
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution."