# Elastic Search River for SQL Server- No Suitable Driver

**URL:** https://discuss.elastic.co/t/elastic-search-river-for-sql-server-no-suitable-driver/59225
**Category:** Elasticsearch
**Created:** [August 29, 2016, 7:03pm UTC](https://discuss.elastic.co/t/elastic-search-river-for-sql-server-no-suitable-driver/59225 "2016-08-29T19:03:13Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![code\_blue](https://avatars.discourse-cdn.com/v4/letter/c/7ea924/32.png) [@code\_blue](https://discuss.elastic.co/u/code_blue)
#### Post date: [August 29, 2016, 7:03pm UTC](https://discuss.elastic.co/t/elastic-search-river-for-sql-server-no-suitable-driver/59225/1 "2016-08-29T19:03:13Z")

</div>

I am trying to fetch data in ES from SQL Server using Microsoft JDBC Driver. I have placed the files

- sqljdbc4.jar

- sqljdbc4.1  
in the lib folder of Elastic Search.

However when i run the river i get the following error.  
No suitable driver found for jdbc:sqlserver://databaserserver;databaseName=DB\_NAME

What am i missing here.

---

<div class="post-metadata">

### Author: ![nik9000](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nik9000/32/44947_2.png) [@nik9000](https://discuss.elastic.co/u/nik9000)
#### Post date: [August 29, 2016, 7:20pm UTC](https://discuss.elastic.co/t/elastic-search-river-for-sql-server-no-suitable-driver/59225/2 "2016-08-29T19:20:02Z")

</div>

Rivers have been deprecated for a long time so I'm not sure it is worth trying to figure this out.... Maybe look at logstash's jdbc?

---

<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: [July 5, 2017, 10:24pm UTC](https://discuss.elastic.co/t/elastic-search-river-for-sql-server-no-suitable-driver/59225/3 "2017-07-05T22:24:22Z")

</div>