- 从 http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774 获取 sqljdbc_auth.dll
根据您使用的 JDK/Java, 选择正确的格式 (x86 或 x64), 在 joget-start.bat 文件中配置变量 -Djava.library.path. 例如:-
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
编辑数据库配置文件. 修改 workflowUrl 属性.
添加 "integratedSecurity=true" 属性. 例如:-workflowUrl=jdbc\:sqlserver\://192.168.2.213\:1433;DatabaseName\=jwdb;integratedSecurity\=true
- You may now empty the workflowPassword attribute. workflowUser attribute must still contain a string but it can be anything.
- Joget will now start up using the MS SQL Database using the same Windows credential it started up with.
Make sure that the Windows account used to start up Joget has privilege to access the specified database.
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