CHAPTER 4: Connection Settings

The connection settings are performed with the input dialog “vistraxWelcome Connection Settings”. This dialog opens when vistraxWelcome is started for the first time after installation. To open the dialog again in order to change settings at a later stage, start “vistraxWelcome 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 vistraxWelcome.

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 for SQL Server (SQLOLEDB): Supports TLS v1.0 only (default).
  • Microsoft OLE DB Driver for 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.

• Datenbase

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 servers: Authentication via a database login (default).
  • Windows integrated security: Authentication via a Windows domain user.

• Login and Password

• 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