IV. Configuration
After installation, configuration of your database instance, as well as the connection settings for vistrax and vistraxWelcome can be undertaken. Administrator permissions are required for this process.
1. Install your instance of the vistrax database
Start vistrax Admin. The dialog box “vistrax Admin Login” will open.
Click “Download & Install” to install a vistrax database instance. Select the database that most fits to your operating system and click “Download”. Select the path for saving the downloaded file and confirm with “Save”.After the download has finished answer the question to open the download with “Yes”.
The access dialog box for the database installation will open.
Important
Note the Standard Password “VxAdmin4DB!” and Login “sa” displayed in the access dialog box. You may change the name of the database instance (“VISTRAX”) as well as the password.Click “Install”. The preconfigured installation of Microsoft SQL Server will open. You just need to apply each step with “Next” and wait until the installation has finished.
Note
If the setup is unsuccessful, the setup bootstrap log file will give more information about the reason. More information and the path to the logfile is available at the following links:- Microsoft SQL Server 2008 R2: https://msdn.microsoft.com/en-us/library/ms143702(v=sql.105).aspx
- Microsoft SQL Server 2012: https://msdn.microsoft.com/en-us/library/ms143702(v=sql.110).aspx
- Microsoft SQL Server 2014: https://msdn.microsoft.com/en-us/library/ms143702(v=sql.120).aspx
- Microsoft SQL Server 2016: https://msdn.microsoft.com/en-us/library/ms143702(v=sql.130).aspx]]
2. Configure your instance of the vistrax database
Start vistrax Admin. The dialog box “vistrax Admin Login” will open. Enter the instance name, the login and the standard password of the SQL database administrator (cp. step 1). The authentication mode “SQL Server” can be left as it is. Click on “Login” and vistrax Admin will open.
Note
With unchanged default installation settings the instance name is composed of the host name followed by “\VISTRAX”. So for example, “MyComputer\VISTRAX”.Note
After installation of the vistrax database instance it can take initially up to 2 minutes until the database can be connected.In the next steps, follow the instructions to create: a) a main database b) a mandator database c) a database login
Regarding a) In order to create a main database for the first time, confirm the request “Would you like to create a new main database?” with “Yes” and click on “Create”. The main database and a Standard User Account will then be created. The standard user account enables subsequent login in vistrax and vistraxWelcome.
Important
Note the user name “admin” and password “admin” for the registration and click on “OK”.Regarding b) By following the instructions in the next step you can create a mandator.
Important
Make an entry in the obligatory field “Name”.Regarding c) In the following step you can create a database login required to access the vistrax program. Choose and enter a login and a password. This information should be noted. Select the standard SQL account and follow the instructions. Database configuration is now fully completed.
Note
If a database login is added manually (e.g. with Microsoft SQL Management Studio), the appropriate rights and roles within the vistrax databases must also be set: The roles “db_datareader”, “db_datawriter” and the right to execute “stored procedures” are required. Ensure that the database login can access the main database and all mandator databases.Note
If you are using a version of the Microsoft SQL Server application from 2012 but less than 2017, you need to pass the parameter -t232 to the database instance. In the SQL Server Configuration Manager, open the properties of the vistrax database instance and switch to the “Startup Parameters” tab. There they add “-t232” via the text field. The SQL Server Configuration Manager can be found in the computer administration under Services and Applications.3. Configuration of network access
Note
If the database was installed using vistraxAdmin, the following settings (a) - © are already done.a) Activate the TCP/IP protocol within the SQL Server instance.
If you have not installed a database instance using vistrax Admin (cp. 1), you must ensure that the TCP/IP protocol in your existing database is activated. To do this, open the SQL server configuration manager on the computer on which your database installation is located (Start menu → Microsoft SQL Server → Configuration Tools → SQL Server Configuration Manager). A tree view is located in the section on the left. Under “SQL Native Client x.x-Configuration (32 Bit)“ and — if present —under “SQL Native Client x.x-Configuration”, select the item “Client Protocols”. The section on the right lists all protocols available. Right-click on “TCP/IP” to open a context menu, and then select the menu item “Activate”. In the tree view, select the relevant database instance under “SQL Server Network Configuration” and use the context menu to activate the item “TCP/IP” here as well. Having competed the changes, the SQL instance must be restarted. This is done by clicking the item “SQL Services” in the tree view. The section on the right lists all SQL instances available on the server. Right-click to open a context menu for the relevant instance and select the item “Restart”.
b) Adjust the firewall rules.
If vistrax installations from other computers are intended to have access to your database, you must ensure that access is not blocked by an installed firewall. For a named instance UDP port 1434, which refers to the SQL Server Service, needs to be opened. In addition, a TCP/UDP Port must be opened for the executable SQL server file. The default path is usually “C:\Program Files\Microsoft SQL Server\MSSQL[Version].[INSTANZNAME]\MSSQL\Binn\sqlservr.exe”. [Version] depends on your MSSQL instance version, [INSTANZNAME]. must be replaced by the name of your database instance.
With a standard instance without a name, TCP port 1433 must be opened.
If you use Windows Firewall, more information is available at the following links:
- Microsoft SQL Server 2008 R2:
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms175043(v=sql.105) - Microsoft SQL Server 2012:
https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/ms175043(v=sql.110)
c) Set the Server-Authentication Mode.
If you have not installed a database instance using vistrax Admin, you need to change the server authentication mode in the security options during the installation. Set the mode to „SQL Server and Windows Authentication mode”.
4. Configuration of vistrax client
Start “vistrax Connection Settings” from the Windows Start Menu. The configuration dialog will be displayed, enter the login and the password from IV. 2. a). By clicking “Test connection”, you are able to test the connection between vistrax and the main database you have created. Apply your settings by clicking “OK”. Now you can start “vistrax” from the Windows Start Menu. The vistrax login opens. To log in to vistrax, enter the standard user account data (cp. IV. 2.a)) and click on “Login”. If you have a valid license, you can activate it by using the configuration dialog.
5. Configuration of vistraxWelcome
Repeat the above steps.
Further information on getting started with vistrax and vistraxWelcome
See the application help.