Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Using windows authentication for SQL Server JDBC with pyspark

Highlighted

Using windows authentication for SQL Server JDBC with pyspark

New Contributor

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 ?