Page History

...

1. We will need to first obtain the dll file needed for integrated authentication. Go to https://github.com/microsoft/mssql-jdbc, scroll down to "Download the DLLs" to obtain the link to Microsoft Download Center. At the point of writing, the link is https://docs.microsoft.com/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server. 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.

   Code Block
   language bash title joget-start.bat linenumbers true
   @ECHO OFF REM Start MariaDB ECHO == Starting MariaDB == ECHO. CALL .\mariadb-start.bat ECHO. 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% == ECHO. %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.

   Code Block
   language bash title app_datasource-mssql.properties linenumbers true
   workflowDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver workflowUrl=jdbc\:sqlserver\://localhost\:1433;SelectMethod\=direct;DatabaseName\=jwdb;integratedSecurity\=true workflowPassword= workflowUser=sa

   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.

...