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

senthil veeramani 1

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.

Cris Zhan-MSFT 6,636 Reputation points

2020-08-17T01:00:37.807+00:00

Hi,
Is there any update on this case?
Please feel free to drop us a note if there is any update.

1 answer

Cris Zhan-MSFT 6,636 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.
Please sign in to rate this answer.
senthil veeramani 1 Reputation point

2020-08-18T03:53:25.403+00:00

i did add that in the URL but throw an error as the authenicationscheme Javakerbros is not valid. What need to do

Cris Zhan-MSFT 6,636 Reputation points

2020-08-18T06:17:43.82+00:00

Hi,
According the second link in my answer:
"you will need to make sure that the Kerberos Configuration file (krb5.ini or krb5.conf) is configured properly on your platform. "
Check the link and Using Kerberos integrated authentication to connect to SQL Server for more information.

senthil veeramani 1 Reputation point

2020-08-19T08:02:41.107+00:00

Hi,

our sql server reside under diff domain and our linux reside at diff domain so does it(Kerbros Configuration) work with different domain scenario.

Cris Zhan-MSFT 6,636 Reputation points

2020-08-20T07:23:07.11+00:00

Yes it supports. If client and server are in different domain, these two domains must be configured as two-way trust.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

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

1 answer

Your answer