Please do the following:
- Open the Registry Editor on the ESP server.
Always back up the whole registry before making any modifications. Incorrect changes to the registry can cause serious system problems.
- Go to HKEY_LOCAL_MACHINE\SOFTWARE\BigFix\Enterprise Server\Database.
- Take note of the values of the following registry strings:
"User"=<sql_account>"Password"=<password>
-
Ideally, you can use the "sa" DB account credentials so that ESP server has the required dbo and db_creator privileges to the Bigfix database instances.
To verify the default SQL account credentials that you used when you install the ESP server:
- Open the ODBC Data Source Administrator console.
- Go to the System DSN tab and then to the configuration settings of BES system.
This should have the sql_account and its subsequent password to use in the registry strings mentioned above. - Restart all the BES Services.