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

Using windows authentication for SQL Server JDBC with pyspark

Highlighted

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 ?

Don't have an account?