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
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
5 REPLIES 5

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

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.