Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

sqoop sqlserver with windows authentication

avatar
Super Collaborator

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

1 ACCEPTED SOLUTION

avatar

@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/

View solution in original post

5 REPLIES 5

avatar

@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/

avatar

@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

avatar
Super Collaborator

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

avatar
Super Collaborator

thanks for swift response..

avatar
Explorer

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