I want to read db with jdbc input.
Logstash wants to connect with windows authentication but i dont want this. Because windows authentication is not permitted. But logstash do this and crashes.
How can i solve this problem?
Error: Java::ComMicrosoftSqlserverJdbc::SQLServerException: Login failed for user 'TEST-DB\sgslogdb'.
My Conf:
input {
jdbc {
jdbc_connection_string => "jdbc:sqlserver://127.0.0.1:1433;instanceName=TEST-DB,databaseName=db_log;integratedSecurity=true;"
jdbc_driver_library => "C:\sqljdbc_4.2\enu\jre8\sqljdbc42.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_user => "sa"
jdbc_password => ".."
statement =>
This config worked on my test machine!