Support Questions
Find answers, ask questions, and share your expertise

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

Highlighted

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

Explorer

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

1 REPLY 1

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

Expert Contributor

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