# Jdbc Input error cause : no sqljdbc\_auth in java.library.path

**URL:** <https://discuss.elastic.co/t/jdbc-input-error-cause-no-sqljdbc-auth-in-java-library-path/49698>\
**Category:** Logstash\
**Created:** [May 10, 2016, 6:15pm UTC](https://discuss.elastic.co/t/jdbc-input-error-cause-no-sqljdbc-auth-in-java-library-path/49698 "2016-05-10T18:15:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alejandro\_Valdes\_Arc](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@Alejandro\_Valdes\_Arc](https://discuss.elastic.co/u/Alejandro_Valdes_Arc)\
**Post date:** [May 10, 2016, 6:15pm UTC](https://discuss.elastic.co/t/jdbc-input-error-cause-no-sqljdbc-auth-in-java-library-path/49698/1 "2016-05-10T18:15:55Z")

</div>

Hello everyone

Im trying to connect to a Sql Server database with integrated authentication, i tried with 3 differents drivers sqljdbc4.jar, sqljdbc.jar, sqljdbc41.jar and differents conections strings

jdbc\_connection\_string =\> "jdbc:sqlserver://server\_name:1433;databaseName=database\_name;integratedSecurity=true;authenticationScheme=NativeAuthentication;"

jdbc\_connection\_string =\> "jdbc:sqlserver://server\_name:1433;databaseName=database\_name;integratedSecurity=true;"

and i got this error

WARNING: Failed to load the sqljdbc\_auth.dll cause : no sqljdbc\_auth in java.lib  
rary.path  
The error reported is:  
Java::ComMicrosoftSqlserverJdbc::SQLServerException: This driver is not config  
ured for integrated authentication. ClientConnectionId:e1b9b8f3-6654-4a08-8e0e-a  
c8f75d03bc5

The driver that i am using is  
jdbc\_driver\_library =\> "D:\Software\logstash-all-plugins-2.1.0\logstash-2.1.0\drivers\sqljdbc4.jar"

I also have the sqljdbc\_auth.dll but i dont know how to reference it

PD: the OS is Windows Server 2008 R2

Help please

Regards

---

<div class="post-metadata">

**Author:** ![Alejandro\_Valdes\_Arc](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@Alejandro\_Valdes\_Arc](https://discuss.elastic.co/u/Alejandro_Valdes_Arc)\
**Post date:** [May 11, 2016, 9:51pm UTC](https://discuss.elastic.co/t/jdbc-input-error-cause-no-sqljdbc-auth-in-java-library-path/49698/2 "2016-05-11T21:51:35Z")

</div>

I pasted the sqljdbc\_auth.dll file in java\_home/lib and it worked

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 4:58am UTC](https://discuss.elastic.co/t/jdbc-input-error-cause-no-sqljdbc-auth-in-java-library-path/49698/3 "2017-07-06T04:58:03Z")

</div>