How can I use integrated security with ETL and Microsoft SQL Server

Drivers & Stacks
1

I am using Neo4J desktop on Windows 10 and trying to connect to an SQL server using integrated security. I downloaded the MS ODBC driver and copied sqljdbc_auth.dll into %USERPROFILE%..Neo4jDesktop\distributions\java\zulu8.21.0.1-jdk8.0.131\jre\bin

Connection URL (with server and db set to my server and db)
jdbc:sqlserver://servername:3183;databaseName=db_name;integratedSecurity=true

I get the following error when creating a connection in the ETL app:

Connection failed. SQL state: 08S01, message: This driver is not configured for integrated authentication. ClientConnectionId:09efd0b4-829c-4860-a2de-2ad44e70a092
Picked up _JAVA_OPTIONS: -Djava.net.preferIPv4Stack=true

All the JDBC documentation I find says that is usually due to not having sqljdbc_auth.dll in the java path. Has anyone been able to make this work?

2

Download JDBC Drivers from Microsoft

Microsoft JDBC Driver 7.2 for SQL Server

In ETL, select mssql-jdbc-7.2.1.jre8.jar

An alternative process is to use Talend for ETL.

3

Try copying the sqljdbc_auth.dll into the C:\Windows\SysWOW64 directory.

4

Didn't work. However, I ended up completely removing Neo4J from my laptop and reinstalling. Now, copying it into the JRE path worked.