Configure Azure SQL for Equitrac in silent mode
To configure Equitrac to work with Azure SQL silently, do the following:
- 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.
- Open the machine where you want to silently configure ControlSuite.
- 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.
-
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__
-
Specify the Authentication mode: Microsoft Entra ID 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
- 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".