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 mssql-jdbc_auth-<version>.<arch>.dll This file needs to be accessible in the Windows System path.

If it is not already on your system, you can get it from the Datical DB installation directory.

• 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>). 

  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


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

Enabling Integrated Security for the Database Connection

1. In the Datical DB GUI, select the Edit Connection link under the Status button for a database.
   
   
   
   
2. In the SQL Server section, select Security: Integrated Security (screenshot a below). Or for DaticalDB versions 7.8 and below, click the Integrated Security checkbox (screenshot b below).
   
   
   1. 
   2. 
3. Click Test Connection and verify that you successfully connect to the database
4. Click OK when done

Integrated Security DbDef Setting Effect on Runtime Credentials Project Setting

If you have Integrated Security enabled for a DbDef, the setting overrides the project setting to enable runtime credentials for any DbDef where it is set.