Views:

Please do the following:

  1. 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.
  2. Go to HKEY_LOCAL_MACHINE\SOFTWARE\BigFix\Enterprise Server\Database.
  3. Take note of the values of the following registry strings:

    "User"=<sql_account>

    "Password"=<password>

  4. 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:

    1. Open the ODBC Data Source Administrator console.
    2. 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.
    3. Restart all the BES Services.