![AuthenticMSSQL settingDB](../figures/AuthenticMSSQL-settingDB.png)
Windows Authentication on Microsoft SQL Server
Windows authentication means creating a database connection to Microsoft SQL Server using your Windows account, instead of User and Password fields (see figure below). The Microsoft SQL Server JDBC driver depends on native libraries you have to install. To enable this all, follow the steps described in this section.
![AuthenticMSSQL settingDB](../figures/AuthenticMSSQL-settingDB.png)
CloverDX comes with a bundled Microsoft SQL Server JDBC driver.
However, it does not contain native libraries required for Windows authentication on Microsoft SQL Server.
Thus, it is necessary to download the native dll
(mssql-jdbc_auth-12.4.2.x64.dll
) and perform some additional settings.
Getting the Native Library
CloverDX bundles Microsoft SQL Server JDBC driver v. 12.4.2.. To download the driver follow these instructions:
-
Get the dist package.
-
Extract the contents and go to folder
sqljdbc_12.4\enu\auth\x64\
. -
Copy the
mssql-jdbc_auth-12.4.2.x64.dll
file to a folder, e.g.C:\mssql_dll
.
Installation
Now there are two ways how to make the dll
work.
The first one involves changing Windows PATH
variables.
If you do not want to do that, go for the second option.
-
Add the absolute path to the
dll
file (C:\mssql_dll
) to the WindowsPATH
variable. Alternatively, you can put thedll
file to some folder which is already included inPATH
, e.gC:\WINDOWS\system32
. -
Modify the
java.library.path
property for all members of the CloverDX Family of products:-
Designer
Modify VM Parameters in the graph’s Runtime Configuration screen (see figure below). Add this line to VM parameters:
-Djava.library.path=C:\mssql_dll
The runtime configuration is valid for all graph within the same workspace.
Figure 198. Adding path to the nativedll
to VM parameters. -
CloverDX Server
In the script that starts Tomcat, add the
-Djava.library.path=C:\mssql_dll
option toJAVA_OPTS
. For example, add the following line at the beginning ofcatalina.bat
:set JAVA_OPTS=%JAVA_OPTS% -Djava.library.path=C:\mssql_dll
-
-
MS SQL Server - make sure you have:
-
TCP/IP
Enabled
in -
TCP Port set to 1433 in TCP/IP
-
-
Enable Windows Authentication in the URL
Add the integratedSecurity=true parameter to the JDBC URL, e.g.
jdbc:sqlserver://hostname:1433;databaseName=databaseName;integratedSecurity=true;