# connect to ms sql server by windows authentication

**URL:** <https://forum.knime.com/t/connect-to-ms-sql-server-by-windows-authentication/7788>\
**Category:** KNIME Analytics Platform\
**Created:** [May 4, 2015, 6:51am UTC](https://forum.knime.com/t/connect-to-ms-sql-server-by-windows-authentication/7788 "2015-05-04T06:51:35Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![rhumecky](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/7cd45c/32.png) [@rhumecky](https://forum.knime.com/u/rhumecky)\
**Post date:** [September 12, 2018, 8:35pm UTC](https://forum.knime.com/t/connect-to-ms-sql-server-by-windows-authentication/7788/6 "2018-09-12T20:35:03Z")

</div>

**Install JDBC Driver inside of KNIME (if not already done)**

In KNIME go to File \> Install Extensions. Search for SQL Server. Select the JDBC Driver for SQL Server, then install it.

**Download Microsoft SQL SERVER JDBC Driver**

Here is current download link (if it doesn’t work just Google “Download Microsoft SQL SERVER JDBC Driver”)

[https://www.microsoft.com/en-us/download/details.aspx?id=57175](https://www.microsoft.com/en-us/download/details.aspx?id=57175)

Choose the .exe file which will self extract the drivers to the location you choose.

In the extracted files copy the **sqljdbc\_auth.dll** file from one of 2 locations:

- **On 64bit windows use** : **sqljdbc\_7.0\ enu\auth\x64**
- **On 32bit Windows use: sqljdbc\_7.0\enu\auth\x86**

**Copy sqljdbc\_auth.dll into KNIME Java directories (3 Locations)**

Paste the same sqljdbc\_auth.dll into 3 locations in the jre directory in the KNIME installation:

- jre folder (My jre folder is located at **: C:\Program Files\KNIME\plugins\org.knime.binary.jre.win32.x86\_64\_1.8.0.152-01\jre.** The version number in your install is probably different. )
- bin folder (off the jre folder above)
- lib folder (off the jre folder above)

**Restart KNIME** (will not work without restart)

**Connection String in KNIME**

To use the integrated security bring in a SQLServer node in KNIME workflow, then select com.microsoft.sqlserver.jdbc.SQLServerDriver.

For the Database URL use:

**jdbc:sqlserver://SERVERNAME;Database=DBNAME;integratedSecurity=true**

---

_[View the full topic](https://forum.knime.com/t/connect-to-ms-sql-server-by-windows-authentication/7788)._