Version

    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
    Figure 190. Connecting to MS SQL with Windows authentication.

    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-8.4.1.x64.dll) and perform some additional settings.

    Getting the Native Library

    CloverDX bundles Microsoft SQL Server JDBC driver v. 8.4.1.. To download the driver follow these instructions:

    1. Get the dist package.

    2. Extract the contents and go to folder sqljdbc_8.4\enu\auth\x64\.

    3. Copy the mssql-jdbc_auth-8.4.1.x64.dll file to a folder, e.g. C:\mssql_dll.

    If you are running on the x86 architecture then extract the *x86.ddl version from the ..\x86 directory. Otherwise, the driver will not work properly.
    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.

    1. Add the absolute path to the dll file (C:\mssql_dll) to the Windows PATH variable. Alternatively, you can put the dll file to some folder which is already included in PATH, e.g C:\WINDOWS\system32.

    2. 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.
        AuthenticMSSQL javaPath
        Figure 191. Adding path to the native dll to VM parameters.

      • CloverDX Server

        In the script that starts Tomcat, add the -Djava.library.path=C:\mssql_dll option to JAVA_OPTS. For example, add the following line at the beginning of catalina.bat:

        set JAVA_OPTS=%JAVA_OPTS% -Djava.library.path=C:\mssql_dll

    3. MS SQL Server - make sure you have:

      • TCP/IP Enabled in SQL Server Network Configuration  Protocols

      • TCP Port set to 1433 in TCP/IP Properties  IP Addresses  IPAll

    4. 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;