Home | Table of Contents | Windows Authentication on Microsoft SQL Server | CloverETL 4.6.1
--- | --- | ---
Prev | Database Connections | Next

### Windows Authentication on Microsoft SQL Server

Windows authentication means creating a database connection to Microsoft SQL Server while leaving User and Password blank (see figure below). Accessing the MS SQL database, the JTDS driver uses your Windows account to log in. The JTDS driver depends on native libraries you have to install. To enable this all, follow the steps described in this section.

Figure 33.9. Connecting to MS SQL with Windows authentication.

Clover comes with a JDBC driver from JDTS. However, it does not provide native libraries which are required for JDTS to work with Windows authentication on Microsoft SQL Server. Thus, it is necessary to download that native dll (`ntlmauth.dll`) and perform some additional settings.

#### Getting the Native Library

Clover supports JTDS v. 1.2.8. The download instructions are:

1. Get the dist package.

2. Extract the contents and go to folder `x64\SSO`, or `x86\SSO`.

3. `ntlmauth.dll` is located there. Copy the file (for 64b or 32b version of Clover, respectively) to a folder, e.g. `C:\jtds_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.

1. Add the absolute path to the dll file (`C:\jtds_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 CloverETL Family of products:

   - Designer

     Modify VM Parameters in the graph's Chapter 14, Runtime Configuration screen (see figure below). Add this line to VM parameters:

     `-Djava.library.path=C:\jtds_dll`

     | Note
     The runtime configuration is valid for all graph within the same workspace.

     Figure 33.10. Adding path to the native dll to VM parameters.

   - Clover Server

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

     `set JAVA_OPTS=%JAVA_OPTS% -Djava.library.path=C:\jtds_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

Prev | Up | Next
Browsing Database and Extracting Metadata from Database Tables | Home | Table of Contents | Hive Connection