# Could not connect to SQL DB using JDBC in Logstash

**URL:** <https://discuss.elastic.co/t/could-not-connect-to-sql-db-using-jdbc-in-logstash/302990>\
**Category:** Logstash\
**Created:** [April 22, 2022, 7:33am UTC](https://discuss.elastic.co/t/could-not-connect-to-sql-db-using-jdbc-in-logstash/302990 "2022-04-22T07:33:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sakshi.Clover](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@Sakshi.Clover](https://discuss.elastic.co/u/Sakshi.Clover)\
**Post date:** [April 22, 2022, 7:33am UTC](https://discuss.elastic.co/t/could-not-connect-to-sql-db-using-jdbc-in-logstash/302990/1 "2022-04-22T07:33:12Z")

</div>

Hi All,

I am trying to connect SQL DB with Logstash. Getting exception please refer attachment

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/1/515a20d9846431c9bd357af7ccb42ada0e638433.png)

Below is the Logstash code

input {

```
jdbc {

           jdbc_connection_string => "jdbc:sqlserver://server;databaseName=EmployeeDB,integratedSecurity=true;"

            jdbc_user => "sa"

    jdbc_password => "sa"

    

    jdbc_driver_library => "C:/ELk/sqljdbc_4.2/enu/jre8/sqljdbc42.jar"

    # The name of the driver class for SqlServer

    jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"

    # Query for testing purpos

    statement => "SELECT * from details"

}

```

}

output {

```
elasticsearch{

         hosts => ["http://127.0.0.1:9200"]

         index => "indexsql"

    }

    stdout{ codec => rubydebug}

```

}

---

<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:** [May 20, 2022, 7:34am UTC](https://discuss.elastic.co/t/could-not-connect-to-sql-db-using-jdbc-in-logstash/302990/2 "2022-05-20T07:34:03Z")

</div>

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