Skip to end of metadata
Go to start of metadata


  • Both Joget DX 7 and MSSQL 2019 are installed in the same Windows 10 operating system.
  • Joget DX 7 uses "mssql-jdbc version 9.4.0.jre8" JDBC driver.


  1. We will need to first obtain the dll file needed for integrated authentication. Go to, scroll down to "Download the DLLs" to obtain the link to Microsoft Download Center. At the point of writing, the link is Download the zip by clicking on "Download Microsoft JDBC Driver 9.4 for SQL Server (zip)"
  2. Unzip, and find "sqljdbc_9.4\enu\auth\x64\mssql-jdbc_auth-9.4.0.x64.dll". Copy it and paste it in a location accessible by Joget, i.e. "C:\Joget-DX7-Enterprise\wflow\library"
  3. Edit "joget-start.bat" and append "-Djava.library.path=./wflow/library" into JAVA_OPTS.

    Your joget-start.bat may look like this now.

    REM Start MariaDB
    ECHO == Starting MariaDB ==
    CALL .\mariadb-start.bat
    REM Start Tomcat
    set JAVA_HOME=.\jre11.0.2
    set CATALINA_HOME=.\apache-tomcat-8.5.65
    set JAVA_OPTS=-Xmx768M -Dwflow.home=./wflow/ -javaagent:./wflow/aspectjweaver-1.8.5.jar -Djava.library.path=./wflow/library -javaagent:./wflow/glowroot/glowroot.jar
    REM set JAVA_OPTS=-XX:MaxPermSize=128m -Xmx1024M -Xdebug -Xnoagent -Djava.compiler=NONE -Xrunjdwp:transport=dt_socket,suspend=n,server=y,address=5115 -Dwflow.home=./wflow/ -javaagent:./wflow/aspectjweaver-1.8.5.jar -javaagent:./wflow/glowroot/glowroot.jar
    ECHO == Starting Tomcat from %CATALINA_HOME% ==
    %CATALINA_HOME%\bin\catalina.bat run

    Note: If your Joget server runs as Windows service, then you will need to launch tomcat8w.exe to configure JAVA_OPTS variable accordingly.

  4. Create a new datasource profile file inside the "wflow" folder.
    Here's sample content.

    Note: The value in "workflowUser" is not being used but it is a required field. You can key in any value here.

  5. Start Joget server and test.

  • No labels