如何将ELK堆栈与MSSQL服务器连接

hzbexzde  于 2022-09-20  发布在  ElasticSearch
关注(0)|答案(2)|浏览(141)

我使用的是MSSQL 2014最新的JDK最新的ELK堆栈logstash.conf文件,但在与SQL服务器建立连接时遇到此问题

[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]"
daolsyd0

daolsyd01#

您应该在SQL Server中启用SSL连接

ergxz8rk

ergxz8rk2#

将此添加到您的连接字符串中

ENCRYPT=TRUE;trustServer证书=TRUE;

相关问题