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.

Also here is my pipeline file


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

Best regards

Hi @Wolfram_Haussig,

Please find the file in below link.

Logstash plain log :

Logstash pipeline conf :

Kindly help me using these files.


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: " 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

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