Hi Foks, I am not that savy in Linux. I am trying to creat a new connection to SQL Server on my laptop and Cloud. Niether of them working. Here is what I have done: - Using Quickstart VM CDH 4.6 - Usoing VMWare Player for quess session - Installed/copied sqljdbc.jar in /usr/lib/sqoop/lib/ - export CLASSPATH=/usr/lib/sqoop/lib/sqljdbc4.jar in a terminal - run this command on the same terminal... $ sqoop eval --connect jdbc:sqlserver://XXXX.cloudapp.net,1433\\XXXX(instance name) --username <myuser> --password <maypassword> --driver com.microsoft.sqlserver.jdbc.SQLServerDriver --query "SELECT * FROM [ContosoRetailDW].[dbo].[DimAccount]" - I do the same for local machine, the host machine Here is the error i get for both cases: WARN tool.EvalSqlTool: SQL exception executing statement: com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host dssvmprod.cloudapp.net,1433, named instance DSSPRODDB failed. Error: "java.net.UnknownHostException: dssvmprod.cloudapp.net,1433". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host. Info... I can connect to Cloud database from guess VM without any issue Here are my questions: 1- What am I doing wrong connecting from a terminal? 2- When I open another terminal the $CLASSPATH won't be recognized. How can I make the CLASSPATH perminant. 2- What should I do or set that the SQL Server driver can be loaded by Sqoop2 user interface? Does sqoop2 interface uses $CLASSPATH? Many thanks for your help
... View more
