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 获取 sqljdbc_auth.dll 
  2. 根据您使用的

    Depending on your

    JDK/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
  3. Edit the datasource properties file. Modify the workflowUrl attribute.
    Add in the

    编辑数据库配置文件. 修改 workflowUrl 属性.
    添加 "integratedSecurity=true"

    attribute

    属性.

    Example

    例如:-

    Code Block
    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.

  1. 您可以设 workflowPassword 属性为空. workflowUser 属性必须设一个值,但可以任意设置.
  2. Joget启动时将使用与Windows相同的身份凭证连接 MS SQL 数据库.
Note
title注意

请确保启动Joget的Windows用户有数据库权限.

Warning
title警告

本文仅适用于数据库运行在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