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 ?