# Logstash connection to Azure mssql

**URL:** <https://discuss.elastic.co/t/logstash-connection-to-azure-mssql/260722>\
**Category:** Logstash\
**Tags:** docker\
**Created:** [January 11, 2021, 12:56pm UTC](https://discuss.elastic.co/t/logstash-connection-to-azure-mssql/260722 "2021-01-11T12:56:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![vikram\_singh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vikram_singh/32/66490_2.png) [@vikram\_singh](https://discuss.elastic.co/u/vikram_singh)\
**Post date:** [January 11, 2021, 12:56pm UTC](https://discuss.elastic.co/t/logstash-connection-to-azure-mssql/260722/1 "2021-01-11T12:56:58Z")

</div>

Hi,  
I am trying to connect logstash to azure mssql db. But is is showing

```auto
 Error: unable to load /tmp/mssql-jdbc-8.4.1.jre8.jar from :jdbc_driver_library, file not readable (please check user and group permissions for the path)
logstash_1 | Exception: LogStash::PluginLoadingError
logstash_1 | Stack: /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.6/lib/logstash/plugin_mixins/jdbc/common.rb:47:in `block in load_driver_jars

```

I checked all permissions but not solved. If I delete `mssql-jdbc-8.4.1.jre8.jar` file and start logstash again, it is showing same error.  
Here is my logstash.conf file

```auto
input {
        jdbc {
    jdbc_connection_string => "jdbc:sqlserver://MYDB.database.windows.net:1433;database=DBNAME;user=USERNAME;password=PASSWORD;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;"
    jdbc_user => "root"
    jdbc_password => "root_password"
    jdbc_driver_library => "/tmp/mssql-jdbc-8.4.1.jre8.jar"
    jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    statement => "SELECT * FROM xyz"

}

}

## Add your filters / logstash plugins configuration here

output {
stdout { codec => json_lines}
        elasticsearch {
                hosts => "http://localhost:9200"
                index => "xyz"
        }
}

```

---

<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:** [February 8, 2021, 12:57pm UTC](https://discuss.elastic.co/t/logstash-connection-to-azure-mssql/260722/2 "2021-02-08T12:57:09Z")

</div>

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