Configuring Sys.ini

The Sys.ini file contains information about the database used in the AMT software and the authorized user to access that database. A sample of this file with default settings can be found in the root directory of your environment.

Navigate to the root directory of the AMT environment.
Copy and Paste the Sample_Sys.ini file found in this directory and rename the copied file to Sys.ini.

Open the Sys.ini file in a text editor and configure the settings listed below.

In the section [DATABASE SERVER]:

ENVIRONMENT (the name to give to the environment)
SYSTEMBASEPATH (the path to the directory of the AMT environment)
SERVER TYPE (the type of database server to use)
SERVER NAME NET (the database server)
DATABASE NAME (the name of the database found on the server)
DBUSER (the username of the account with authorized access to the database)

DBPSSW (the password for the account with authorized access to the database)

[DATABASE SERVER]

ENVIRONMENT=COBOL

SYSTEMBASEPATH=C:\AMT\COBOL

SERVER TYPE=MSSQL

SERVER NAME NET=NB1000\MSSQL2019

DATABASE NAME=AMT-COBOL_SYSTEM

DBUSER=MyDbUsername

DBPSSW=MyDbPassword

Save the file.


The entries DBUSER and DBPSSW for the username and the password will be encrypted after the first reorganization of the system database has been performed.

Depending on your configuration, one or more entries described in the table below should be added to the Sys.ini file.

Setting Name	Description
COMMANDTIMEOUT	The number of seconds before an SQL Command sent to the system database times out.
CONTROLCENTERBLURL	The URL of the Control Center Business Logic.
CUSTOMSIGNENCODING	When using a custom sign encoding, this setting is used to define the sign encoding. Also see Overpunch Encoding.
DATABASE NAME	MSSQL: The name of the system database. ORACLE: The name of the Tablespace used for the system database. By convention, this should be AMTSYSTEM_<SystemName>, e.g. AMTSYSTEM_SAT.
DBPSSW	The password for the user ID. This entry will be encrypted upon first access to the file.
DBUSER	The user ID used to access the database. This entry will be encrypted upon first access to the file.
ENVIRONMENT	A free to choose name for this instance of the AMT system.
FILEGROUP	The MSSQL servers the Filegroup where all the tables of the system database go to.
INDEXFILEGROUP	The Filegroup or Tablespace where all the indexes of the system database go to.
INTEGRATEDSECURITY	If set to TRUE, the Windows account the program or service is running under is used to access the system database and the user/password combination is ignored.
KEEPORIGINALFILEBEFORESQLITE	This item controls the backup behaviour when converting files to SQLite files. If set to TRUE, the original file is backed up to a directory named "OriginalFileBeforeSqlite" by the File Controller. This setting is disabled by default, which will not backup the file.
LOCKTIMEOUT	The number of seconds the system waits until a lock of a system table is released.
MAXPOOLSIZE	The maximum number of connections to the ADO.NET connection pool.
MSSQLFAILOVERPARTNER	If using a replicated server for an MSSQL system database, this should be set to the failover partner.
ORACLECOSTBASED	If set to TRUE, while using the ORACLE Server Type, access to the system database is cost based.
ORACLEWRAPPER	If the Server Type is ORACLE, this entry overrides the Windows System Environment variable ORACLEWRAPPER.
SCHEMA	When using ORACLE database servers, this should be set to the User Schema used in the system database tablespace. For MSSQL database servers, this should be set if a schema different from dbo is used for the system database tables.
SERVER NAME NET	This value is the name and instance of the database which contains the system information. MSSQL: The server\SQLInstanceName where multiple SQL Server instances exist on the same database server, e.g. LionServer\MSSQL2005.
SERVER TYPE	The type of the database server, e.g. MSSQL or ORACLE.
SYSTEMBASEPATH	The location of the root of the AMT system. This is typically the path to the directory where the Sys.ini configuration file is located, e.g. C:\AMT.
USEDBSSLCONNECTION	If set to TRUE, a SSL/TLS connection has to be used for access to the system database.
AMTCALLDLLNET48	Enter the name of one or several DLL files (separated by commas) which needs to be called by .NET Framework 4.8 instead of the .NET version used by AMT. Used for both reports and online forms.
AMTCALLDLL	Enter the name of one or several DLL files (separated by commas) which needs to be called by a specific .NET (core) version instead of the .NET version used by AMT. warning This setting can only be used after receiving the required .NET files from AMT Customer support, by default these are not contained in an AMT release.

The DBUSER and DBPSSW entries in the Sys.ini can be entered as plain text. When the system starts they will automatically be encrypted as long as the system permissions are set to allow this.


If the Sys.ini file has been misconfigured in such a way that no logging file is written, error messages are always written to the Windows Eventlog. Therefore, in the scenario that the system does not start, please check the Window Eventlog for more information.