...

• 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

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

...