question how to import job on sqoop from sql server connection with only on windows authentication in Archives of Support Questions (Read Only)

how to import job on sqoop from sql server connection with only on windows authentication

matheskrishna — Mon, 21 Dec 2015 17:05:50 GMT

Re: how to import job on sqoop from sql server connection with only on windows authentication

aervits — Thu, 24 Dec 2015 10:04:26 GMT

you need run sqoop with integrated security, see examples https://msdn.microsoft.com/en-us/library/ms378428(v=sql.110).aspx, you also need to make sure that your node where sqopo will run has AD integration.

Re: how to import job on sqoop from sql server connection with only on windows authentication

aervits — Tue, 02 Feb 2016 22:33:25 GMT

@Mathes krishna has this been resolved? Can you post your solution or accept best answer?

Re: how to import job on sqoop from sql server connection with only on windows authentication

matheskrishna — Wed, 03 Feb 2016 11:55:56 GMT

@Artem ErvitsThanks for the response..I found out the solution for this problem,the solution is downloading SQLJDBC_AUTH.DLL

and give permission to other users.

please refer the site for downloading jar file:https://www.microsoft.com/en-us/download/details.aspx?id=11774

Please refer this site for how to grant permission for sqoop: http://itproguru.com/expert/2014/09/how-to-fix-login-failed-for-user-microsoft-sql-server-error-18456-step-by-step-add-sql-administrator-to-sql-management-studio/

Re: how to import job on sqoop from sql server connection with only on windows authentication

dgoodhand — Thu, 25 Feb 2016 23:17:31 GMT

Has anyone got this working from Linux to Windows?

Re: how to import job on sqoop from sql server connection with only on windows authentication

mageru — Fri, 10 Feb 2017 02:17:24 GMT

I spent months on this and was told by Cloudera that it is just not possible. The kerberos tokens are lost when the mappers spawn (as the YARN transitions the job to its internal security subsystem).

I think this is something that would have to be added to Sqoop itself, much like HBase mapreduce jobs have to pass job config to mappers in the code Sqoop needs to do the same.

Re: how to import job on sqoop from sql server connection with only on windows authentication

mageru — Fri, 10 Feb 2017 02:39:27 GMT

Definately has not been resolved. It's something Sqoop can't currently do.