Contents

    Video

    Installing JTL-Wawi

    In this video, we explain how to install JTL-Wawi.

    Installing JTL-Wawi on an individual workstation

    Your task/initial situation

    You would like to install JTL-Wawi on an individual computer for the first time. In the scenario below there is no pre-existing MS SQL Server installed on your computer. Please note that there may be deviations if an MS SQL Server is already running on your computer or if several computers are to have access to the JTL-Wawi database.
    When updating from 0.99923, always update to 1.0. first! Newer versions can only be updated from version 1.0.0.0 . If you are using an older JTL-Wawi version, first install version 1.0.0.0.
    As of JTL-Wawi 1.7: SQL Server 2014 or higher required. Version 1.6 is the last version that is compatible with SQL SERVER 2012. As of version 1.7, the 2012 version of the SQL Server will no longer be supported. You will then need SQL Server 2014 or higher. We recommend using SQL Server version 2019, since the Express Edition offers several benefits.

    System requirements

    Workstations/Clients (JTL-Wawi)

    System requirements for workstations/clients (JTL-Wawi)

    JTL-Wawi requires the Microsoft .Net Framework 4.8

    • Windows 7
    • Windows 8.1
    • Windows 10

    Database server (MS SQL 2014 Express)

    JTL-Wawi requires at least one MS SQL Server 2012 (as of JTL-Wawi 1.7: at least MS SQL Server 2014). MS SQL Express is automatically downloaded and installed when setting up JTL-Wawi if no version of MS SQL Server pre-exists on the system. The following system requirements apply:


    JTL-Wawi requires Microsoft .Net Framework 4.8, which is generally included in Windows 10 and does not have to be installed separately.


    Operating system

    • Windows 7
    • Windows 8.1
    • Windows 10
    • Windows Server 2008 R2
    • Windows Server 2012/2012 R2

    Processor: Intel-compatible processor with at least 1 GHz or higher

    RAM: At least 512 MB of RAM for SQL Server Express with Tools and SQL Server Express with Advanced Services as well as 4 GB for Reporting Services installed with SQL Server Express with Advanced Services.

    Hard drive space: 4.2 GB of hard drive space + sufficient space for the JTL-Wawi SQL database

    Limitations: Microsoft SQL Server Express supports 1 physical processor, 1 GB memory and 10 GB storage.
    Attention: Please be sure to keep in mind the storage capacities. Otherwise, irreparable errors may occur in your database, leading to data loss.

    Note: The database and the client can also be installed on the same computer (so-called individual workstation version). 32-bit and 64-bit operating systems are supported. Source and further details: Microsoft Developer Network

    If all the requirements are met, proceed as follows:

    Step 1: Running the JTL-Wawi setup

    1. Download the current version of JTL-Wawi from the JTL website .
    1. Start the JTL-Wawi setup by running the downloaded file.
    2. Please note that you should start the installation of JTL-Wawi as a Windows administrator. Right-click on the file and select Run as administrator from the context menu.
    1. Follow the instructions of the setup wizard on the screen.

    If you have not set up an SQL server, you must first install and set up an MS SQL Server for JTL-Wawi.

    1. Click Fertigstellen (Finish) after the installation is completed. The setup wizard automatically starts JTL-Wawi for the first time.

    Step 2: Installing the database server

    No database connection will be found when JTL-Wawi is called up for the first time. You must first switch to the Datenbankverwaltung (Database administration) of JTL-Wawi.

    1. Open the JTL-Wawi Datenbankverwaltung (JTL-Wawi database administration).
    2. Click Neues Profil (New profile) to create a new database profile.
    1. Name your profile, for example JTLWAWI, and enter a description if necessary. Since you have not yet installed a Microsoft SQL Server, click Neuen SQL-Server installieren (Install new SQL Server). An entirely new MS SQL Server will be installed (not simply a new instance).
    Please note: You can also download the installer directly from Microsoft. In this case, however, you must configure the SQL server manually. For more information on this topic click here.

    Options

    • Pre-existing SQL service: If you already have access to an SQL service because of a different application, that service is displayed under Gefundene SQL-Instanzen (Found SQL instances).
    • Network installation: If you want to run JTL-Wawi as a network installation, the Servername (Server name) you enter must be the one of the SQL Server to which you want to connect.

    After downloading the MS SQL Server, you need to configure it. The download can take anywhere from a few minutes to up to an hour, depending on various conditions. The configuration of the MS SQL Server can be very complex. When you download the MS SQL Server with JTL-Wawi, the configuration is already simplified and reduced to the essentials. You will only see the Instanzenname (Instance name) and Passwort (Password). Attention: Be sure to write down both the instance name and the password!

    1. Write down the Instanzenname (Instance name) and Passwort (Password).

    Benutzername (Username): You can use the default username or enter a different one. Write down the name!


    Passwort (Password): You can use the default password. However, we recommend choosing your own password. Write down your new password! Please note: Only you have access to this password. This means that even JTL customer service cannot help you if you have forgotten the password and have not written it down.

    Attention: The predefined user is sa and the predefined password is sa04jT14. We strongly recommend changing the password since the default password is commonly known. The data could otherwise be used by others to gain unauthorized access to your SQL Server.

    Komplettes Paket inkl. SQL Management Studio installieren: If you tick this check box, the Microsoft SQL Server Management Studio will be downloaded and installed along with the Microsoft SQL Server. We recommend installing the Microsoft SQL Server Management Studio, as it allows our support team to access the database.


    1. After the configuration has been completed, start the installation of MS SQL Server by clicking Weiter (Next). The MS SQL Server setup wizard will then be downloaded and executed.
    1. Follow the instructions of the setup wizard. You can generally use the predefined default settings. The pages Instanzkonfiguration (Instance configuration) and Datenbankmodulkonfiguration (Database module configuration) are very important. On these pages you will find the configurations made at the beginning in the JTL-Datenbankverwaltung (JTL-Database administration). Generally, you do not have to make any changes, since JTL-Wawi has already transferred the configuration data automatically.
    1. Complete the configuration of the MS SQL Server. Should any errors arise on the feedback page, please have a look at our FAQs and contact the JTL Support team or your service partner if necessary.

    JTL-Wawi now creates the SQL instance and configures the profile. This may take a few minutes. After the configuration, the SQL instance will appear in the selection.

    Step 3: Setting up the JTL database

    1. Select the instance and click Weiter (Next).
    1. Log in to the instance as SQL user.

    Benutzer (User): Use the default system administrator password for the MS SQL server: SA or sa.


    Passwort (Password): This is the password which you wrote down during the installation of MS SQL Server Step 2 > Point 4.


    1. You will be asked to create the eazybusiness database. Follow the instructions on the screen and close the JTL-Datenbankverwaltung (JTL-Database administration) by clicking Fertig (Finish). Should any errors occur at this point, please read our FAQs and contact JTL customer service or your JTL service partner if necessary.

    Step 4: Setting up JTL-Wawi

    1. The JTL-Wawi login opens. Log in with the standard JTL username and password.
    Please note: We strongly recommend changing the password to an individual password. You can change the password via the user administration, see Benutzer einrichten (Setting up users).

    User name: admin


    Password: pass


    1. The JTL setup wizard opens. Follow the instructions on the screen. Just below the screenshot you will find a flyout help page with information on the setup wizard.

    Step 5: Setting up printers

    1. When the setup is completed by the JTL setup wizard, JTL-Wawi will be restarted, and you will have to log in again.
    2. The printer administration opens. Adjust your printer settings here. If you do not want to use a printer, close the dialogue box by clicking Abbrechen (Cancel).

    Step 6: Using JTL-Wawi

    You have now successfully installed and set up JTL-Wawi. JTL-Wawi is a complex application that offers you a variety of settings.

    1. If you are new to JTL-Wawi, it is best to start by reading the introductory pages of the JTL-Guide. All essential processes and important aspects are documented there. Starting with JTL-Wawi.

    Video

    Installing JTL-Wawi

    In this video, we explain how to install JTL-Wawi.