- 从 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. 例如:-
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
编辑数据库配置文件. 修改 workflowUrl 属性.
添加 "integratedSecurity=true" 属性. 例如:-Code Block 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.
| Note |
|---|
Make sure that the Windows account used to start up Joget has privilege to access the specified database. |
- 您可以设 workflowPassword 属性为空. workflowUser 属性必须设一个值，但可以任意设置.
- Joget启动时将使用与Windows相同的身份凭证连接 MS SQL 数据库.
| Note | ||
|---|---|---|
| ||
请确保启动Joget的Windows用户有数据库权限. |
| Warning | ||
|---|---|---|
| ||
本文仅适用于数据库运行在Windows环境. 你可查看为何不能运行在Linux | ||
| 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 |