Showing results for 
Search instead for 
Did you mean: 

Head's Up! Site migration is underway. Pause, resolving how to handle anonymous content

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

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)

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:

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?


Graph Fellow

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.

Graph Maven

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

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