The Connection settings are performed with the input dialog “vistrax Connection Settings”. This input dialog opens when vistrax is started for the first time after installation. To open the input dialog again in order to change settings at a later stage, start “vistrax Connection Settings” from the Windows Start Menu.

The input dialog is divided into two sections. It allows you to save database connection data (“Microsoft SQL Server”), and to save the connection data required for LDAP / ADS authentication (“LDAP / ADS Authentication Section”).

LDAP / ADS authentication configuration is optional. Configuration is only required if you wish to make use of the possibility to authenticate during user login in vistrax.

To set up the database connections the following fields must be filled in:

• Driver: Here you can choose the database driver::
  • Microsoft OLE DB Provider für SQL Server (SQLOLEDB): Microsoft OLE DB Provider for SQL Server (SQLOLEDB): Supports TLS v1.0 only (default).
  • Microsoft OLE DB Driver für SQL Server (MSOLEDBSQL): Supports TLS v1.0 and newer, as well as self-signed certificates.

• Name: This entry corresponds with the information entered during the installation of the database instance and/or the path to an existing instance of Microsoft SQL.

• Port: Port, to connect to the Microsoft SQL instance (default: 1433).
• Packet Size: The network packet size in bytes which is used for the database connection. The value must be between 512 and 32767. The maximum network packet size for encrypted connections is 16383. The default network packet size is 4096.

• Database: Select either “VISTRAX” if you have not yet set up a main database, or the database name of an existing vistrax main database.
• Authentication Mode: Select the mode to be used for login to the SQL instance:
  • Microsoft SQL Server: Authentication via a database login (default).
  • Windows Integrierte Sicherheit: Authentication via a Windows domain user.

• Login and Password: Here you should use the data entered during installation of the database instance, or the login data of an existing database login.

• Encrypted Database Connection: Select the mode to be used to encrypt the database connection:
  • Disabled: An unencrypted connection is used (default).
  • Automatic (encryption preferred): If an encrypted connection can be established, it will be used. Otherwise, an unencrypted connection is used.
  • Forced: An encrypted connection is always used.
  • Forced: All server certificates are accepted for the encrypted connection (including self-signed ones; MSOLEDBSQL is required)

In order to configure and use LDAP / ADS authentication you must fill in the following fields:

• Path: The LDAP path refers to the LDAP/ADS server. Example: The server IP is 192.168.1.1. In this case the LDAP path is formulated as follows:

  ldap://192.168.1.1

  (it is also possible to resolve from the DNS name rather than using the IP address).

• Domains: In this field you should enter the domain names of the domains to be used.