Database connection settings

<< Click to display table of contents >>

Navigation:  Administration > Security settings >

Database connection settings

▪We recommend encrypting the connection to the database server

▪Import server certificate (SQL server)

▪No longer trust servers without a certificate

▪We recommend only accepting encrypted connections in the SQL server

▪We recommend using Windows authentication for the database connection.

(Alternatively, it is also possible to grant permissions to the ticonuser and encrypt the config file. See also: Encryption of the Config file)

To do this, additional parameters must be entered in the connection string in the config file:

Encrypt=True; //only encrypted connections are accepted

TrustServerCertificate=False; ////Servers without a trustworthy certificate are not trusted

Integrated Security=True; ////Windows authentication for the database connection

Please note:

The file config.xml is located in the ProgramData folder of the installed TiCon version, by default at: „%PROGRAMDATA%\MTM\TiCon 4.XX\Config.xml“