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

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

New Contributor
 
1 ACCEPTED SOLUTION

Accepted Solutions

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

New Contributor

@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-1845...

View solution in original post

6 REPLIES 6

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

Mentor

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

Mentor

@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

Explorer

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

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

New Contributor

@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-1845...

View solution in original post

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

Explorer

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

Explorer

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.