anusha created RANGER-1142:
------------------------------

             Summary: Sqoop import error
                 Key: RANGER-1142
                 URL: https://issues.apache.org/jira/browse/RANGER-1142
             Project: Ranger
          Issue Type: Improvement
            Reporter: anusha


Trying to import data in Sqoop from MS SQL Server database which has Windows 
Authentication. 

Trying to run the following command on the hive command prompt. 

sqoop import --driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" 
--connect="jdbc:microsoft:sqlserver://**.**.**.** :1433/DB_Schema;Integrated 
Security=TRUE" 
 --table dbo.TABLE_NAME

Error Received : 
Error 1:
--driver is set to an explicit driver however appropriate connection manager is 
not being set (via --connection-manager). Sqoop is going to fall back to 
org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which 
connection manager should be used next time.

Error 2 : 
Got exception running Sqoop: java.lang.RuntimeException: Could not load db 
driver class: com.microsoft.jdbc.sqlserver.SQLServerDriver
java.lang.RuntimeException: Could not load db driver class: 
com.microsoft.jdbc.sqlserver.SQLServerDriver


Could some one guide me . 

versions : 
Sqoop 1.4.6

     



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to