You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

  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:- 
    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:- 
    workflowUrl=jdbc\:sqlserver\://192.168.2.213\:1433;DatabaseName\=jwdb;integratedSecurity\=true
  4. 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.

  • No labels