sqoop sqlserver with windows authentication

[#1]

i'm trying to sqoop (Linux server) data from Sql server...i was able to do it with local account on sql server, but i want to try with Windows authentication

[#2 · Accepted solution]

@Raja Sekhar Chintalapati You need to have an account with SQL Server Authentication to sqoop from SQL Server to Hadoop. I don't think Sqoop would work with windows authentication account in SQL Server. It definitely not used to work earlier, haven't tried in past 6 months. Please refer below.

http://hortonworks.com/hadoop-tutorial/import-microsoft-sql-server-hortonworks-sandbox-using-sqoop/

[#3]

@Pardeep is correct. You can only use a local SQL Server account for a Sqoop import. You may want to secure the connection by using the "password-file" hint. https://sqoop.apache.org/docs/1.4.5/SqoopUserGuide.html#_connecting_to_a_database_server

[#4]

thanks Scott..but this is sad that it doesn't support AD...

[#5]

thanks for swift response..

[#6]

In 2017, HDP v2.5+ you can connect sqoop to Microsoft SQL Server with AD.