I'm trying to connect to a SQL Server database using a JDBC connection from Logstash installed on a Linux server. I'm running into issues with the security portion of it. This is my current connection string:
jdbc_connection_string => "jdbc:sqlserver://servername:1433;databasename=dbname;integratedSecurity=true;authenticationScheme=JavaKerberos"
jdbc_ucser => "user"
jdbc_password => "pass"
When I try to run logstash using this, I get a SQLServer error: Integrated authentication failed. I've tried a couple different configurations using/not using integrated, using/not using authenticationScheme, and I can't get it to work at all. Any ideas for me?