How we can connect ELK stack With MSSQL server

Question

I am using MSSQL 2014 latest JDK Latest ELK stack logstash.conf file But getting this issue when I make a connection with the SQL server

[main][e9c4db4e3f1cd9e5b60e74315884750f1c29dac2dc7868d0280893eb5f8b6983] Exception when executing JDBC query {:exception=>"Java::ComMicrosoftSqlserverJdbc::SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: \"The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]\"

Does [this](https://stackoverflow.com/questions/67246010/the-server-selected-protocol-version-tls10-is-not-accepted-by-client-preferences) or [this](https://stackoverflow.com/questions/68126780/how-to-fix-the-server-selected-protocol-version-tls10-is-not-accepted-by-client) help? — Val, Nov 23 '21 at 17:22
no i install JDK Firsts means that JRE install automatically in JDK but java.security file does not found — Mian Muhammad Ramzan, Nov 24 '21 at 08:26

score 1 · Answer 1 · edited Sep 26 '22 at 09:33

1

Add this to your connection string:

encrypt=true; trustServerCertificate=true;

edited Sep 26 '22 at 09:33

Ethan

876
8
18
34

answered Sep 19 '22 at 07:22

ezeldin hussein

31
5

score 0 · Answer 2 · answered Feb 20 '22 at 13:33

0

u should enable SSL connection in SQL SERVER

answered Feb 20 '22 at 13:33

Chaimaa Hraka

1

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Feb 20 '22 at 20:44
ok understand then how can I enable SSL for MSSQL – Mian Muhammad Ramzan Feb 21 '22 at 17:33
generate a SSL certificate for SQL SERVER connection – Chaimaa Hraka Feb 22 '22 at 18:34
u will find how u can generate it on google or youtube – Chaimaa Hraka Feb 22 '22 at 18:35

How we can connect ELK stack With MSSQL server

2 Answers2