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:
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 ?