Hi all, I have a database on my MSSQL 2012 server and i am trying to get my database to elasticsearch with logstash. I did I installed jdk 8 I installed sqljdbc 4.2 I Added the java and jdbc to Environment path Iam using ELK 7.3 and my config file like this : input { jdbc { jdbc_conn…

Sorry i add jdbc_driver_library => "C:\Users\user\Desktop\sqljdbc_4.2\enu\jre8\sqljdbc42.jar" and worked. :slight_smile: BTW if you have windows authentication on your MSSQL add integratedSecurity=false; to your connection string for those who will look this page. :slight_smile:

JDBC connection not working

Elastic Stack Elasticsearch

elasticforme (Sachin) September 5, 2019, 1:20pm 7

Logstash is working on linux.

I have a post for my problem

https://discuss.elastic.co/t/jdbc-for-sqlserver/198058

Topic		Replies	Views
Logstash JDBC importer MSSQL2012 is not working Logstash	4	2352	July 6, 2017
Trouble connecting to Microsoft SQL Server in Logstash via jdbc Logstash	1	506	September 5, 2020
Cannot able to get the SQLSERVER data into elasticsearch Logstash	2	288	August 9, 2019
Connection sqlserver to elasticsearch Discussions en français	12	833	July 13, 2022
SQL Server data to Elasticsearch using LogStash Logstash	31	6127	September 17, 2020

JDBC connection not working

Related topics