JDBC want to connect to db as windows user

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!

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