# OpenSearch SQL ODBC Driver Connection Error

**URL:** <https://forum.opensearch.org/t/opensearch-sql-odbc-driver-connection-error/12257>\
**Category:** SQL\
**Tags:** troubleshoot, configure\
**Created:** [January 24, 2023, 3:17pm UTC](https://forum.opensearch.org/t/opensearch-sql-odbc-driver-connection-error/12257 "2023-01-24T15:17:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![smcgovern](https://avatars.discourse-cdn.com/v4/letter/s/919ad9/32.png) [@smcgovern](https://forum.opensearch.org/u/smcgovern)\
**Post date:** [January 24, 2023, 3:17pm UTC](https://forum.opensearch.org/t/opensearch-sql-odbc-driver-connection-error/12257/1 "2023-01-24T15:17:07Z")

</div>

**Versions** (relevant - OpenSearch/Dashboard/Server OS/Browser):

opensearch-sql-odbc-win64-1.4.0.0

**Describe the issue** :

After I install the ODBC driver, I get an error when testing my connection:

“[OpenSearch][SQL ODBC Driver][SQL Plugin] Connection Error: SQL plugin is not available, please install the SQL plugin to use this driver.”

**Configuration** :

Host and port fields are correct, with basic authentication configured. “Enable SSL” is also checked in Advanced Options.

**Relevant Logs or Screenshots** :

![image](https://us1.discourse-cdn.com/flex019/uploads/mauve_hedgehog/original/2X/c/cfccb4b7a2dbe880d5e555da5da799eaa921af28.png)

---

<div class="post-metadata">

**Author:** ![yuryf-bq](https://avatars.discourse-cdn.com/v4/letter/y/c4cdca/32.png) [@yuryf-bq](https://forum.opensearch.org/u/yuryf-bq)\
**Post date:** [January 27, 2023, 6:23pm UTC](https://forum.opensearch.org/t/opensearch-sql-odbc-driver-connection-error/12257/2 "2023-01-27T18:23:06Z")

</div>

Hi  
Can you try prepend URL by `https://` prefix? Does this work?  
Can you disable SSL on your server and try connecting? Consider changing your password after that.  
To disable SSL add or edit the following line in `config/opensearch.yml`:

```auto
plugins.security.ssl.http.enabled: false

```

---

<div class="post-metadata">

**Author:** ![smcgovern](https://avatars.discourse-cdn.com/v4/letter/s/919ad9/32.png) [@smcgovern](https://forum.opensearch.org/u/smcgovern)\
**Post date:** [February 3, 2023, 9:42pm UTC](https://forum.opensearch.org/t/opensearch-sql-odbc-driver-connection-error/12257/3 "2023-02-03T21:42:29Z")

</div>

Changing the IP in opensearch.yml to the host IP worked.