Using the Database Configuration Tool (DBConfig.exe)

The DBConfig.exe tool allows users to change the user account, password, and the database name for the Control Manager database.

The tool offers the following options:

  • DBName: Database name

  • DBAccount: Database account

  • DBPassword: Database password

  • Mode: Database authentication mode (SQL Server Authentication or Windows Authentication)

    Note:

    The default database authentication mode is SQL Server Authentication mode. However, Windows Authentication mode is necessary when configuring for Windows authentication.

  1. Open a command prompt on the Control Manager server.
  2. Use the following command to locate the directory which contains the DBConfig.exe file:

    cd <Control Manager installation directory>\DBConfig

  3. Type dbconfig and press ENTER.

    The DBConfig tool interface appears.

  4. Specify which settings you want to modify:
    • Example 1: DBConfig -DBName="db_your_database>" -DBAccount="sqlAct" -DBPassword="sqlPwd" -Mode="SQL"

    • Example 2: DBConfig -DBName="db_your_database>" -DBAccount="winAct" -DBPassword="winPwd" -Mode="WA"

    • Example 3: DBConfig -DBName="db_your_database>" - DBPassword="sqlPwd"