Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  1. Obtain sqljdbc_auth.dll from http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774
  2. Depending on your JDK/Java used, select the correct bit architecture (x86 or x64), make a reference to it under the variable named -Djava.library.path from your joget-start.bat file. Example:-
    Code Block
    set JAVA_OPTS=-XX:MaxPermSize=128m -Xmx512M -Dwflow.home=./wflow/ -Djava.library.path=E:/Downloads/sqljdbc_4.0.2206.100_enu/sqljdbc_4.0/enu\/auth/x86
  3. Edit the datasource properties file. Modify the workflowUrl attribute.
    Add in the "integratedSecurity=true" attribute. Example:-
    Code Block
    workflowUrl=jdbc\:sqlserver\://192.168.2.213\:1433;DatabaseName\=jwdb;integratedSecurity\=true
  4.  You You may now empty the workflowPassword attribute. workflowUser attribute must still contain a string but it can be anything.
  5. Joget will now start up using the MS SQL Database using the same Windows credential it started up with.
Note

Make sure that the Windows account used to start up Joget has privilege to access the specified database.

Warning

This article is only valid for server running on Windows environment and not on others.

Read on why you can't run this on Linux at https://connect.microsoft.com/SQLServer/feedback/details/275681/sql-jdbc-integrated-security-with-domain-account-from-linux