Logstash jdbc input for sql express


Does anyone know a good example showing how to configure input for jdbc driver with sqlexpress.

input {
  jdbc {
	jdbc_driver_library => "C:\JDBC8.4\sqljdbc_8.4\enu\mssql-jdbc-8.4.1.jre14.jar"
	jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    jdbc_connection_string => "jdbc:sqlserver:.\\SQLEXPRESS;database=mydb;"
	jdbc_user => "user"
	jdbc_password => "password"
    statement => "SELECT * from mydbTable"  

In the logs, I keep getting unable to connect to database


I think you should show the logs. There is lot of reasons of that.

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