# JDBC connection not working

**URL:** https://discuss.elastic.co/t/jdbc-connection-not-working/198175
**Category:** Elasticsearch
**Created:** [September 5, 2019, 6:54am UTC](https://discuss.elastic.co/t/jdbc-connection-not-working/198175 "2019-09-05T06:54:37Z")
**Posts on this page:** 1
**Showing post:** 8

<div class="post-metadata">

### Author: ![zbawio](https://avatars.discourse-cdn.com/v4/letter/z/d07c76/32.png) [@zbawio](https://discuss.elastic.co/u/zbawio)
#### Post date: [September 5, 2019, 1:27pm UTC](https://discuss.elastic.co/t/jdbc-connection-not-working/198175/8 "2019-09-05T13:27:07Z")

</div>

> [@Jdbc for sqlserver](https://discuss.elastic.co/t/jdbc-for-sqlserver/198058/1):
>
> Error: com.microsoft.sqlserver.jdbc.SQLServerDriver not loaded. Are you sure you've included the correct jdbc driver in :jdbc\_driver\_library?

it cannot find your jdbc  
did you add your jdk and your sqljdbc to system environment path ?

> [@Jdbc for sqlserver](https://discuss.elastic.co/t/jdbc-for-sqlserver/198058/1):
>
> jdbc\_driver\_library =\> "/root/sqljdbc\_7.4/enu/mssql-jdbc-7.4.1.jre12.jar" jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"

this may be a version problem i mean i do not know elasticsearch is supporting jre12

btw if you write

```
jdbc_validate_connection => true

```

on your connectionstring sql might try a windows authentication + sql authentication so it should be a problem after fix your version problem

---

_[View the full topic](https://discuss.elastic.co/t/jdbc-connection-not-working/198175)._