Versions Compared

Key

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

...

Info

If you are using a version of Liquibase Enterprise version 8.5+ use version mssql-jdbc_auth-12.4.0.<arch>.dll

Files are located here. Place these files directly in the C:\Windows\System32\ directory. You do not need to pull them from the .jar file as described in the steps below.


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

...

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

  • Go to <datical-install>\LiquibaseDesktop\plugins\ (for older versions <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.


...

  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. Image Added
    2. Image Modified
  3. Click Test Connection and verify that you successfully connect to the database
  4. Click OK when done

...