# Sequel::DatabaseConnectionError

**URL:** <https://discuss.elastic.co/t/sequel-databaseconnectionerror/221882>\
**Category:** Logstash\
**Created:** [March 3, 2020, 12:28pm UTC](https://discuss.elastic.co/t/sequel-databaseconnectionerror/221882 "2020-03-03T12:28:15Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Raguvarthan](https://avatars.discourse-cdn.com/v4/letter/r/57b2e6/32.png) [@Raguvarthan](https://discuss.elastic.co/u/Raguvarthan)\
**Post date:** [March 3, 2020, 12:28pm UTC](https://discuss.elastic.co/t/sequel-databaseconnectionerror/221882/1 "2020-03-03T12:28:15Z")

</div>

I am trying to configure my SQL server with elastic search using logstash. I have completed configuring elastic search and logstash. But when I trigger logstash.bat to connect my pipeline file below is the error captured.

[https://pifora-my.sharepoint.com/:u:/r/personal/ragu\_symprio\_com/Documents/logstash-plain.log?csf=1&e=4tR6ia](https://pifora-my.sharepoint.com/:u:/r/personal/ragu_symprio_com/Documents/logstash-plain.log?csf=1&e=4tR6ia)

Also here is my pipeline file

[https://pifora-my.sharepoint.com/:u:/r/personal/ragu\_symprio\_com/Documents/load-ot.conf?csf=1&e=ZFl8DE](https://pifora-my.sharepoint.com/:u:/r/personal/ragu_symprio_com/Documents/load-ot.conf?csf=1&e=ZFl8DE)

---

<div class="post-metadata">

**Author:** ![Wolfram\_Haussig](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wolfram_haussig/32/70528_2.png) [@Wolfram\_Haussig](https://discuss.elastic.co/u/Wolfram_Haussig)\
**Post date:** [March 3, 2020, 1:40pm UTC](https://discuss.elastic.co/t/sequel-databaseconnectionerror/221882/2 "2020-03-03T13:40:40Z")

</div>

Hi,

I could not access your files. Is it possible to upload them anywhere else/copy the contents to the thread here?

Best regards  
Wolfram

---

<div class="post-metadata">

**Author:** ![Raguvarthan](https://avatars.discourse-cdn.com/v4/letter/r/57b2e6/32.png) [@Raguvarthan](https://discuss.elastic.co/u/Raguvarthan)\
**Post date:** [March 4, 2020, 2:48am UTC](https://discuss.elastic.co/t/sequel-databaseconnectionerror/221882/3 "2020-03-04T02:48:33Z")

</div>

Hi @Wolfram_Haussig,

Please find the file in below link.

Logstash plain log : [https://drive.google.com/file/d/1TPeIOpXlMZkshyg8u8zWwNiJQfHWgMQk/view?usp=sharing](https://drive.google.com/file/d/1TPeIOpXlMZkshyg8u8zWwNiJQfHWgMQk/view?usp=sharing)

Logstash pipeline conf : [https://drive.google.com/open?id=1uuP9A\_\_xqG97LVC2HmFwTKp8BN2t9dCe](https://drive.google.com/open?id=1uuP9A__xqG97LVC2HmFwTKp8BN2t9dCe)

Kindly help me using these files.

---

<div class="post-metadata">

**Author:** ![Wolfram\_Haussig](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wolfram_haussig/32/70528_2.png) [@Wolfram\_Haussig](https://discuss.elastic.co/u/Wolfram_Haussig)\
**Post date:** [March 4, 2020, 5:53am UTC](https://discuss.elastic.co/t/sequel-databaseconnectionerror/221882/4 "2020-03-04T05:53:45Z")

</div>

Hi,

There seems to be a connection problem between LogStash and your MS SQL server:  
Error: Java::ComMicrosoftSqlserverJdbc::SQLServerException: The connection to the host localhost, named instance **desktop-l1ir1is\kibanatest** failed. Error: "java.net.SocketTimeoutException: Receive timed out". **Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.**

Did you already check that the mentioned port 1434 and the instance name is correct and that the SQL server browser service is running?

Maybe someone with MS SQL Server experience can help you here as I am only using Oracle.

Best regards  
Wolfram

---

<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:** [April 1, 2020, 5:58am UTC](https://discuss.elastic.co/t/sequel-databaseconnectionerror/221882/5 "2020-04-01T05:58:16Z")

</div>

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