Configure Azure SQL for Equitrac in silent mode

To configure Equitrac to work with Azure SQL silently, do the following:

  1. Run Configuration Assistant on a single machine. After configuration, the cs-config.txt file is generated with all of the configured properties. The cs-config.txt file is found in C:\ProgramData\Nuance\ControlSuite\cs-config.txt.
  2. Open the machine where you want to silently configure ControlSuite.
  3. Copy the cs-config.txt file from the first machine to a folder on the C drive of the second machine for the properties file path. For example: C:\cs_automation\cs-config.txt.
  4. Open the cs-config.txt file and specify the following Azure SQL configuration parameters:
    equitrac.db.dbtype=SqlServerAzure
    equitrac.db.sqlserverinstance=__Azure_SQL_server_name_hostname__
    equitrac.db.databasename=__Azure_SQL_Database_name__
  5. Specify the Authentication mode: Azure Active Directory account or Azure SQL Server account.
    equitrac.db.azuresqlauth=ActiveDirectoryPassword
     OR
    equitrac.db.azuresqlauth=SqlPassword
    
    equitrac.db.dbusername=__account_name__
    equitrac.db.dbuserpassword=__account_password__
    equitrac.db.encryptedconnection=true
    equitrac.db.validateservercert=true
    equitrac.db.serverprotocol=tcp
    equitrac.db.serverport=1433
    equitrac.db.connecttimeout=30
  6. Open a command prompt, and run C:\Program Files\Kofax\Configuration Assistant\ConfigurationAssistant.exe --noui --propertiesfile:"<path to properties file>". For example: C:\Program Files\Kofax\Configuration Assistant\ConfigurationAssistant.exe --noui --propertiesfile:"c:\cs_automation\cs-config.txt".