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

Integrated Security requires access to sqljdbcmssql-jdbc_auth-<version>.<arch>.dll. This  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 the x86 folder, even if your operating system is the x64 version.use mssql-jdbc_auth-8.4.1.x86.dll
    • If you are running a 64-bit JVM on an x64 processor, use the x64 folder.
    Copy sqljdbc_auth.dll to C:\Windows\System32\sqljdbc_auth.dll
    • JVM  use mssql-jdbc_auth-8.4.1.x64.dll


Info


Enabling Integrated Security for the Database Connection

...