Sequel::DatabaseConnectionError

[Raguvarthan]

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

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

[Wolfram_Haussig]

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

[Raguvarthan]

Hi @Wolfram_Haussig,

Please find the file in below link.

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

Logstash pipeline conf : https://drive.google.com/open?id=1uuP9A__xqG97LVC2HmFwTKp8BN2t9dCe

Kindly help me using these files.

[Wolfram_Haussig]

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