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?