- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
how to import job on sqoop from sql server connection with only on windows authentication
- Labels:
-
Apache Sqoop
Created 12-21-2015 09:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Created 02-03-2016 03:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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...
Created 12-24-2015 02:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 02-02-2016 02:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Mathes krishna has this been resolved? Can you post your solution or accept best answer?
Created 02-09-2017 06:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Definately has not been resolved. It's something Sqoop can't currently do.
Created 02-03-2016 03:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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...
Created 02-25-2016 03:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Has anyone got this working from Linux to Windows?
Created 02-09-2017 06:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
