# JDBC - This driver is not configured for integrated authentication

**URL:** <https://discuss.elastic.co/t/jdbc-this-driver-is-not-configured-for-integrated-authentication/377225>\
**Category:** Logstash\
**Tags:** jdbc\
**Created:** [April 16, 2025, 9:40pm UTC](https://discuss.elastic.co/t/jdbc-this-driver-is-not-configured-for-integrated-authentication/377225 "2025-04-16T21:40:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Francesco\_Esposito](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/francesco_esposito/32/141865_2.png) [@Francesco\_Esposito](https://discuss.elastic.co/u/Francesco_Esposito)\
**Post date:** [April 16, 2025, 9:40pm UTC](https://discuss.elastic.co/t/jdbc-this-driver-is-not-configured-for-integrated-authentication/377225/1 "2025-04-16T21:40:30Z")

</div>

Trying to connect to my Sql Server Instance thru Windows Authentication using the following configuration:

```auto
input {
	udp {
		port => 517
	}
}
filter {
	mutate { gsub => ["message", "\u0000", "[0x00]" ] }
	mutate { gsub => ["message", "\r\n", "[0x01]" ] }
	mutate { gsub => ["message", "\r", "[0x02]" ] }
	mutate { gsub => ["message", "\n", "[0x03]" ] }
	xml {
		force_array => false
		source => "message"
		target => "myxml"
	}
    ruby {
        code => '
            event.get("myxml").each { |k, v|
                event.set(k,v)
            }
        '
    }
	mutate {
		remove_field => "host"
		remove_field => "event"
		remove_field => "message"
		remove_field => "@version"
		remove_field => "myxml"
		remove_field => "LINENO"
		copy => { "@timestamp" => "event.ingested" }
		rename =>{ "GENID" => "[@metadata][altuuid]" }
		rename =>{ "HOST" => "apphost" }
		rename =>{ "APPLICATION" => "exename" }
		rename =>{ "APPVERSION" => "exeversion" }
		rename =>{ "EVENTSEQNO" => "eventseqno" }
		rename =>{ "EVENTNAME" => "eventname" }
		rename =>{ "EVENTINFO" => "eventinfo" }
		rename =>{ "SEVERITY" => "severity" }
		rename =>{ "EVENTDATETIME" => "logeventdate" }
		rename =>{ "THREADID" => "threadid" }
		rename =>{ "INSTANCEID" => "instanceid" }
		gsub => ["logeventdate", "(\d{2}):(\d{3})$", "\1.\2"] 
	}
	jdbc_static {
		id => "udplogstash"
		jdbc_driver_library => "D:\\sqljdbc_12.10\\enu\\jars\\mssql-jdbc-12.10.0.jre11.jar"
		jdbc_connection_string => "jdbc:sqlserver://;serverName=mysqlserverhost;databaseName=mydatabasename;integratedSecurity=true;authenticationScheme=NativeAuthentication;encrypt=false;"
		jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
		loader_schedule => "*/30 * * * *"
		local_db_objects => [
			{
				name => "localstore"
				index_columns => ["RNID"]
				columns => [
					["RNID", "int"],
					["ChainCode", "int"],
					["ServiceName", "varchar(100)"],
					["ProcessorPartner", "varchar(100)"]
				]
			}
		]
		loaders => [
			{
				id => "dbquery"
				query => "usp_GetLoggerRNIDInfo_1_10_100"
				local_table => "localvars"
			}
		]
		local_lookups => [
			{
				id => "loadingdata"
				query => "select ChainCode from localstore where RNID = :RNID"
				parameters => { RNID => "1"}
				target => "[metadata][ChainCode]"
				default_hash => {
					ChainCode => ""
				}
			}
		]
	}
}
output {
	file {
		path => "/log_streaming/my_app/records/log-%{+yyyy-MM-dd_HH.mm.ss.SSS}.log"
	}
	elasticsearch {
		hosts => "https://myelasticistance:9200"
		user => "username"
		password => "password"
		ssl_certificate_verification => "false"
		index => "delphi-processlog_write"
		document_id => "%{[@metadata][altuuid]}"
		doc_as_upsert => "true"		
	}
}

```

I receive this error:

```auto
Pipeline error {:pipeline_id=>"test", :exception=>#<LogStash::Filters::Jdbc::ConnectionJdbcException: Java::ComMicrosoftSqlserverJdbc::SQLServerException: This driver is not configured for integrated authentication.

```

I have read that I am missing the mssql-jdbc\_auth-xx.xx.x.x64/86.dll somewhere I cannot figure out where having them in the downloaded folder D:\sqljdbc\_12.10\enu\auth\x64/86.

I have downloaded the drivers from

> **[Download - JDBC Driver for SQL Server](https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16)**
>
> Download the Microsoft JDBC Driver for SQL Server to develop Java applications that connect to SQL Server and Azure SQL Database.

Could you help me?

---

<div class="post-metadata">

**Author:** ![Alex\_Salgado-Elastic](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alex_salgado-elastic/32/103081_2.png) [@Alex\_Salgado-Elastic](https://discuss.elastic.co/u/Alex_Salgado-Elastic)\
**Post date:** [April 17, 2025, 12:48pm UTC](https://discuss.elastic.co/t/jdbc-this-driver-is-not-configured-for-integrated-authentication/377225/2 "2025-04-17T12:48:47Z")

</div>

Hi @Francesco_Esposito ,

I found this Microsoft documentation that might help:

> **[Building the connection URL with the Microsoft JDBC Driver for SQL Server -...](https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver16)**
>
> Learn about formatting the connection string used by the Microsoft JDBC Driver for SQL Server. Samples of connection strings are included in the examples section.

If you're seeing the error **"This driver is not configured for integrated authentication"** when using SQL Server with Logstash, you need to make the native authentication DLL file (`mssql-jdbc_auth-12.10.0.x64.dll` or `x86.dll`) available to Java.

There are two ways to do this:

1. Copy the `.dll` file to a directory that is included in the Windows `PATH`.
2. Or, set the `java.library.path` property to point to the directory where the file is located.

---

<div class="post-metadata">

**Author:** ![Francesco\_Esposito](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/francesco_esposito/32/141865_2.png) [@Francesco\_Esposito](https://discuss.elastic.co/u/Francesco_Esposito)\
**Post date:** [April 17, 2025, 2:03pm UTC](https://discuss.elastic.co/t/jdbc-this-driver-is-not-configured-for-integrated-authentication/377225/3 "2025-04-17T14:03:21Z")

</div>

Yeah, not really being familiar with jdk, I can't understand where to put it. Like in my  
D:\logstash-8.17.3\jdk\lib? D:\logstash-8.17.3\jdk\bin?