https://community.cloudera.com/t5/Support-Questions/sqoop-sqlserver-with-windows-authentication/m-p/100861#M63855 <P>thanks Scott..but this is sad that it doesn't support AD...</P> Tue, 29 Dec 2015 00:06:46 GMT chrsvarma 2015-12-29T00:06:46Z https://community.cloudera.com/t5/Support-Questions/sqoop-sqlserver-with-windows-authentication/m-p/100857#M63851 <P>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</P> Mon, 28 Dec 2015 22:31:46 GMT https://community.cloudera.com/t5/Support-Questions/sqoop-sqlserver-with-windows-authentication/m-p/100857#M63851 chrsvarma 2015-12-28T22:31:46Z https://community.cloudera.com/t5/Support-Questions/sqoop-sqlserver-with-windows-authentication/m-p/100858#M63852 <P><A rel="user" href="https://community.cloudera.com/users/968/chrsvarma.html" nodeid="968">@Raja Sekhar Chintalapati</A> 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.</P><P><A href="http://hortonworks.com/hadoop-tutorial/import-microsoft-sql-server-hortonworks-sandbox-using-sqoop/" target="_blank">http://hortonworks.com/hadoop-tutorial/import-microsoft-sql-server-hortonworks-sandbox-using-sqoop/</A> </P> Mon, 28 Dec 2015 22:36:57 GMT https://community.cloudera.com/t5/Support-Questions/sqoop-sqlserver-with-windows-authentication/m-p/100858#M63852 pardeep_kumar 2015-12-28T22:36:57Z https://community.cloudera.com/t5/Support-Questions/sqoop-sqlserver-with-windows-authentication/m-p/100859#M63853 <P><A rel="user" href="https://community.cloudera.com/users/139/pardeepkumar.html" nodeid="139">@Pardeep</A> 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. <A href="https://sqoop.apache.org/docs/1.4.5/SqoopUserGuide.html#_connecting_to_a_database_server" target="_blank">https://sqoop.apache.org/docs/1.4.5/SqoopUserGuide.html#_connecting_to_a_database_server</A></P> Mon, 28 Dec 2015 22:45:40 GMT https://community.cloudera.com/t5/Support-Questions/sqoop-sqlserver-with-windows-authentication/m-p/100859#M63853 SQLShaw 2015-12-28T22:45:40Z https://community.cloudera.com/t5/Support-Questions/sqoop-sqlserver-with-windows-authentication/m-p/100860#M63854 <P>thanks for swift response..</P> Tue, 29 Dec 2015 00:06:14 GMT https://community.cloudera.com/t5/Support-Questions/sqoop-sqlserver-with-windows-authentication/m-p/100860#M63854 chrsvarma 2015-12-29T00:06:14Z https://community.cloudera.com/t5/Support-Questions/sqoop-sqlserver-with-windows-authentication/m-p/100861#M63855 <P>thanks Scott..but this is sad that it doesn't support AD...</P> Tue, 29 Dec 2015 00:06:46 GMT https://community.cloudera.com/t5/Support-Questions/sqoop-sqlserver-with-windows-authentication/m-p/100861#M63855 chrsvarma 2015-12-29T00:06:46Z https://community.cloudera.com/t5/Support-Questions/sqoop-sqlserver-with-windows-authentication/m-p/100862#M63856 <P>In 2017, HDP v2.5+ you can connect sqoop to Microsoft SQL Server with AD.</P> Wed, 01 Nov 2017 23:38:45 GMT https://community.cloudera.com/t5/Support-Questions/sqoop-sqlserver-with-windows-authentication/m-p/100862#M63856 ing_cma 2017-11-01T23:38:45Z