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