...
If you are using Microsoft SQLServer with Datical DB, you can use Integrated Security to authenticate the database connection.
Setting Up Windows
| Info |
|---|
If you are using a version of Liquibase Enterprise version 8.5+ use version Files are located here. Place these files directly in the |
| Info |
|---|
If you are using a version of Datical DB prior to 7.9 use the |
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>\LiquibaseDesktop\plugins\(for older versions<datical-install>\DaticalDB\plugins\) Copy
com.datical.db.drivers.mssql_1.x.x.jarto 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
.jarto.zipand 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.dllInfo Datical DB is installed with a 64-bit JVM that is used by default.
- If you are running a 32-bit JVM, use
Enabling Integrated Security for the Database Connection
- In the Datical DB GUI, select the Edit Connection link under the Status button for a database.
- 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).
- Click Test Connection and verify that you successfully connect to the database
- Click OK when done
...