0

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

enter image description here

[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]\"
Improve this question
2
  • Does this or this help?
    – Val
    Commented Nov 23, 2021 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
    Commented Nov 24, 2021 at 8:26

2 Answers 2

Reset to default
1

Add this to your connection string:

encrypt=true; trustServerCertificate=true;
Improve this answer
0

u should enable SSL connection in SQL SERVER

Improve this answer
4
  • 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.
    – Community Bot
    Commented Feb 20, 2022 at 20:44
  • ok understand then how can I enable SSL for MSSQL
    – Mian Muhammad Ramzan
    Commented Feb 21, 2022 at 17:33
  • generate a SSL certificate for SQL SERVER connection
    – Chaimaa Hraka
    Commented Feb 22, 2022 at 18:34
  • u will find how u can generate it on google or youtube
    – Chaimaa Hraka
    Commented Feb 22, 2022 at 18:35

Not the answer you're looking for? Browse other questions tagged or ask your own question.