...
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 sqljdbcmssql-jdbc_auth-<version>.<arch>.dll
. This This file needs to be accessible in the Windows System path.
...
- 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 the
x86
folder, even if your operating system is the x64 version.usemssql-jdbc_auth-8.4.1.x86.dll
- If you are running a 64-bit JVM on an x64 processor, use the
x64
folder.
sqljdbc_auth.dll
toC:\Windows\System32\sqljdbc_auth.dll
- JVM use
mssql-jdbc_auth-8.4.1.x64.dll
- If you are running a 32-bit JVM, use the
Info |
---|
Enabling Integrated Security for the Database Connection
...