Logstash mssql JDBC connector

Hi,
I'm trying to ingest data from MSSQL to logstash through the JDBC Driver.
Running SQL queries from logstash to MS SQL works fine with SQL account.
Now I need to connect through AD account but it is not working, and don't why.

Logstash log :

[ERROR][logstash.inputs.jdbc ][main][b40ab62582a03954ee8b9930be58d224ef37dfd651f1f810645cad83b0590016] Unable to connect to database. Tried 1 times {:error_message=>"Java::ComMicrosoftSqlserverJdbc::SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:f33a2ec9-ac75-4984-b1ba-5c38e11eb023"}
Oct 12 12:53:24 elastic03 logstash[25329]: [2020-10-12T12:53:24,398][ERROR][logstash.javapipeline ][main][b40ab62582a03954ee8b9930be58d224ef37dfd651f1f810645cad83b0590016] A plugin had an unrecoverable error. Will restart this plugin.

Using mssql-jdbc-8.4.1.jre11.jar in /usr/share/logstash.jar
Using mssql-jdbc_auth-8.4.1.x64.dll in /usr/lib/jvm/java-11-openjdk-amd64/lib/ (java_home)

Versions :
logstash 7.9.1
Java : openjdk version "11.0.8" 2020-07-14

mssql.conf in logstash/conf.d

input {
jdbc {
jdbc_driver_library => "/usr/share/logstash/logstash-core/lib/jars/mssql-jdbc-8.4.1.jre11.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_connection_string => "jdbc:sqlserver://xxx;databaseName=master;integratedSecurity=true;"
jdbc_user => "<user>"
jdbc_password => "xxx"

Any ideas?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.