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
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"