We have not found any good documentation about changing the BigFix MSSQL database password.
We try using BESAdmin tool with no success.
We try the method indicated here : https://www.ibm.com/support/knowledgecenter/en/SSKLLW_9.5.0/com.ibm.bigfix.inventory.doc/Inventory/admin/t_reset_db_password.html
But we have not found besserver.config file
BigFix version is 9.5.6.63
Database is MS-SQL 2012
On a Windows BigFix server you should change the Sql database password configuration using ODBC. From the CME prompt type “odbcad32”. You should see an entry related to bfenterprise.
If you wanted to change a Sql acounts password or the Sql sa password, i would recommend using Sql enterprise manager.
I’m pretty sure that in case of using SQL authentication, you also need to set a registry value on the BES server so the root server can authenticate to SQL. I’ll check on that when I’m back in the office Monday.
I believe by default there is no SQL password unless you enable SQL authentication / SA account.
We use SQL authentification.
The solution is just put the password in this key:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\BigFix\Enterprise Server\Database\password
then you recycle all the BES services.