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

senthil veeramani 1 Reputation point
2020-08-13T12:21:45.863+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,830 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cris Zhan-MSFT 6,606 Reputation points
    2020-08-14T06:13:14.697+00:00

    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.