unable to connect ms sql server via jdbc 8.2.0 on linex through spark with windows authentication

Question

i am trying to connect MS SQL server via jdbc 8.2.0 using spark with windows authentication from linux server but it throw error message as sqljdbc_auth not found in java library path.

Answer 1

Hi,

You may need to add the following to the jdbc connection string:

integratedSecurity=true;authenticationScheme=JavaKerberos  

Please check:
https://stackoverflow.com/questions/30914061/connect-to-sql-server-from-linux-via-jdbc-using-integratedsecurity-windows-auth

https://learn.microsoft.com/en-us/archive/blogs/psssql/jdbc-this-driver-is-not-configured-for-integrated-authentication

Best regards,
Cris

===============================================

If the response helped, do "Accept Answer" and upvote it.