Thank you for the response. Sqoop used to run fine until we changed service id password. New password is also reflected in the scripts. But, sqoop fails about 2 out of 10 runs with authentication error. If at all I give wrong credentials it should fail all the times. I'm wondering if the job process uses the old credentials from some where in the cache on the sql server side or cluster side ?? Tried running the below sqoop from command line and ended up with same windows authentication error intermittently. PS-- sqoop eval --driver net.sourceforge.jtds.jdbc.Driver --connect "jdbc:jtds:sqlserver://URL:port;DOMAIN:****;username=***;password=****" --username --password --query ""
... View more
