Jdbc Input error cause : no sqljdbc_auth in java.library.path

Elastic Stack Logstash
1

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

2

I pasted the sqljdbc_auth.dll file in java_home/lib and it worked