Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

Sqoop JDBC parameter for Sql Server AD Authentication password

New Contributor

Hi, I am trying to run sqoop list job for a Azure Sql database but getting login failed error. SQL database in question is using Active Directory Password Authentication but unable to find out how to put this parameter in sqoop jdbc command, Can you please help me out, I have used IntegratedSecurity = true but get an error saying this SQL driver is not configured for Integrated Security. Below is the sqoop command in which I want AD authentication parameter to be placed

sqoop list-tables --connect 'jdbc:sqlserver://xxxx:1433;database=xxx' --username "xxx@xx.com" --password 'xxx' --driver com.microsoft.sqlserver.jdbc.SQLServerDriver --connection-manager org.apache.sqoop.manager.SQLServerManager

ERROR manager.CatalogQueryManager: Failed to list tables com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open server "xxx.com" requested by the login. The login failed. ClientConnectionId:xxxx

1 REPLY 1

Expert Contributor

Hi, MSSQL needs another file which has information about how to pass and access the MSSQL+AD (Windows Auth) enabled but this anotherfile is of a dll format so you cannot use that in linux/unix platform. The next best approach is to use a 3rd party driver like DataDirect who provides access to MSSQL using AD or alternatively you can use a free 3rd party driver called jtds - http://jtds.sourceforge.net/ which has option to connect to MSSQL using AD.

something like this -> sqoop import/export --connect "jdbc:jtds:sqlserver://dbname:portnumber;databaseName=dbname;useNTLMv2=true;domain=DOMAINNAME"

http://jtds.sourceforge.net/faq.html