Using windows authentication for SQL Server JDBC with pyspark

[#1]

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 ?