Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
 
1 ACCEPTED SOLUTION

avatar

@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

avatar
Master 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.

avatar
Master Mentor

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

avatar
Contributor

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

avatar

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

avatar
Contributor

Has anyone got this working from Linux to Windows?

avatar
Contributor

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.