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 sqljdbc_auth.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).
  • If you are running a 32-bit JVM, use the x86 folder, even if your operating system is the x64 version.
  • 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

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, click the Integrated Security checkbox
   
   
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.