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

sqoop sqlserver with windows authentication

Expert Contributor

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

Accepted Solutions

Re: sqoop sqlserver with windows authentication

@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

Re: sqoop sqlserver with windows authentication

@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

Re: sqoop sqlserver with windows authentication

@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

Re: sqoop sqlserver with windows authentication

Expert Contributor

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

Re: sqoop sqlserver with windows authentication

Expert Contributor

thanks for swift response..

Re: sqoop sqlserver with windows authentication

New Contributor

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