# Logstash mssql JDBC connector

**URL:** <https://discuss.elastic.co/t/logstash-mssql-jdbc-connector/251769>\
**Category:** Logstash\
**Created:** [October 12, 2020, 1:29pm UTC](https://discuss.elastic.co/t/logstash-mssql-jdbc-connector/251769 "2020-10-12T13:29:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![thomas7467](https://avatars.discourse-cdn.com/v4/letter/t/c0e974/32.png) [@thomas7467](https://discuss.elastic.co/u/thomas7467)\
**Post date:** [October 12, 2020, 1:29pm UTC](https://discuss.elastic.co/t/logstash-mssql-jdbc-connector/251769/1 "2020-10-12T13:29:40Z")

</div>

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?

---

<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:** [November 9, 2020, 1:30pm UTC](https://discuss.elastic.co/t/logstash-mssql-jdbc-connector/251769/2 "2020-11-09T13:30:09Z")

</div>

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