HI I'm using SQOOP import command for SQL Server. I want to use windows authentication instead of SQL authentication. Will it work?

[#1]

I tried using sqoop command for a windows authentication and i got the following exception :This driver is not configured for integrated authentication. java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication linux sqoop

[#2]

Hi @Mayank Pandey,

Please check - https://community.hortonworks.com/questions/20719/sqoop-to-sql-server-with-integrated-security.html

Also the JIRA SQOOP-795 covers Kerberos authentication for JDBC clients to Sqoop.

/Best regards, Mats