- Obtain sqljdbc_auth.dll from 从 http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774 获取 sqljdbc_auth.dll
根据您使用的
Depending on yourJDK/Java
used,
select the correct bit architecture选择正确的格式 (x86
or或 x64),
make a reference to it under the variable named在 joget-start.bat 文件中配置变量 -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
- Edit the datasource properties file. Modify the workflowUrl attribute.
Add in the编辑数据库配置文件. 修改 workflowUrl 属性.
attribute
添加 "integratedSecurity=true"属性.
Example例如:-
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 |