Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

If you are using Microsoft SQLServer with Datical DB, you can use Integrated Security to authenticate the database connection. 

Setting Up Windows


Info

If you are using a version of Datical DB prior to 7.9 use the sqljdbc_auth.dll in place of  mssql-jdbc_auth-<version>.<arch>.dll


Integrated Security requires access to mssql-jdbc_auth-<version>.<arch>.dll This file needs to be accessible in the Windows System path.

...

  • Go to <datical-install>\DaticalDB\plugins\
  • Copy com.datical.db.drivers.mssql_1.x.x.jar to a temporary directory and unzip it (<unzip directory>). 

    Tip

    On Windows systems you can:

    o Use <java-install-path>\JAVA\jar.exe xf <name>.jar

    o Change the extension of the file from .jar to .zip and then unzip it. 


  • Go to <unzip directory>\auth\, then go to the folder for your version of the Java Virtual Machine (JVM).
  • Copy the appropriate dll to the C:\Windows\System32\ directory
    • If you are running a 32-bit JVM, use mssql-jdbc_auth-8.4.1.x86.dll
    • If you are running a 64-bit JVM  use mssql-jdbc_auth-8.4.1.x64.dll

      Info

      Datical DB is installed with a 64-bit JVM that is used by default.




Enabling Integrated Security for the Database Connection

...