Importing Data from TLS enabled Microsoft SQL Server in sqoop

nitesh_rentam — Fri, 10 Feb 2017 04:00:10 GMT

Cannot connect to SQL Server after database is upgraded from SSL to TLS 1.2. Same without HADOOP_OPTS was working fine with no issues earlier with SSL

Environmnent:

Sqoop version: 1.4.6.2.3.4.23-3 java 1.7

> export SQOOP_USER_CLASSPATH=/data1/jar/sqljdbc4.jar
> export HADOOP_OPTS="-Ddeployment.security.SSLv2Hello=false -Ddeployment.security.SSLv3=false -Ddeployment.security.TLSv1=false -Ddeployment.security.TLSv1.1=true -Ddeployment.security.TLSv1.2=true -Dhttps.protocols=TLSv1,TLSv1.1,TLSv1.2"

>sqoop import --libjars /data1/jar --connect jdbc:sqlserver://<hostname>:<portname> --username <user_id> --password ***** --query "SELECT <columns> FROM <table>  \$CONDITIONS"  --split-by <column1> --target-dir /data/external/survey --fields-terminated-by '|' --verbose

Error Message:

ERROR manager.SqlManager: Error executing statement: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secr: "SQL Server did not return a response. The connection has been closed. ClientConnectionId:cbed7e62-1f12-42cf-956d-1a3548b44aa8".

Re: Importing Data from TLS enabled Microsoft SQL Server in sqoop

nitesh_rentam — Tue, 14 Feb 2017 05:59:32 GMT

solution offered by HW: use https://sourceforge.net/projects/jtds/?source=typ_redirect drivers.

question Importing Data from TLS enabled Microsoft SQL Server in sqoop in Archives of Support Questions (Read Only)

Importing Data from TLS enabled Microsoft SQL Server in sqoop

Re: Importing Data from TLS enabled Microsoft SQL Server in sqoop