Support Questions
Find answers, ask questions, and share your expertise

Using windows authentication for SQL Server JDBC with pyspark

Using windows authentication for SQL Server JDBC with pyspark

Explorer

Hi,

I am trying to pull SQL Server data into a Data Frame using pyspark. I'd like to use windows authentication to establish the connection.

Here is my connection string:

jdbc:sqlserver://servername;databasename=Test;schema=dbo;integratedSecurity=true;

However, I am getting an error not able to find sqljdbc_auth.dll

"An error occurred while calling o63.jdbc. : com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication."


Is there any workaround so I can connect to SQL server with windows authentication within pyspark ?