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

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

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.

Mentor

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

Explorer

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

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

Explorer

Has anyone got this working from Linux to Windows?

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.