Hi,
I have corrected the command like below.but still same issue.
command:
$bin/sqoop list-databases --connect
"jdbc:sqlserver://MT-TRNGSQL\SQLEXPRESS:1433;username=abc;password=xyz"
sqoop-1.4.1-incubating__hadoop-0.20# bin/sqoop list-databases --connect
"jdbc:sqlserver://MT-TRNGSQL\SQLEXPRESS:1433;username=abc;password=xyz"
Warning: /usr/lib/hbase does not exist! HBase imports will fail.
Please set $HBASE_HOME to the root of your HBase installation.
Warning: $HADOOP_HOME is deprecated.
12/07/18 17:34:22 INFO manager.SqlManager: Using default fetchSize of 1000
12/07/18 17:34:22 ERROR manager.CatalogQueryManager: Failed to list
databases
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user
'sqlserver'. ClientConnectionId:bb5ea97e-ea07-4e69-89b9-4c675fbe6d64
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
Please help me on this issue.
Thanks,
Prabhu.
On Wed, Jul 18, 2012 at 1:51 PM, Jarek Jarcec Cecho <[email protected]>wrote:
> Hi Prabhu,
> I believe that your connection URL is not valid. Please consider following
> Microsoft guide:
>
> http://msdn.microsoft.com/en-us/library/ms378428(v=sql.90).aspx
>
> The correct form seems to be:
>
>
> jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]
>
> I believe that you used normal slash between server name and instance name
> instead of the backslash, right? You can specify the instance name in the
> property as instanceName=instance1 if you do not want to fight with proper
> escaping of the backslash.
>
> Are you also able to ping MT-TRNGSQL from the box where you're running
> sqoop?
>
> Jarcec
>
> On Wed, Jul 18, 2012 at 01:41:54PM +0530, prabhu k wrote:
> > Thanks for the reply.
> >
> > I have run the below command as per your suggestion.
> >
> > bin/sqoop list-databases --connect
> > "jdbc:sqlserver://MT-TRNGSQL/SQLEXPRESS:1433;username=abc;password=xyz"
> >
> > I am getting following error.
> >
> > sqoop-1.4.1-incubating__hadoop-0.20# bin/sqoop list-databases --connect
> > "jdbc:sqlserver://MT-TRNGSQL/SQLEXPRESS:1433;username=abc;password=xyz"
> > Warning: /usr/lib/hbase does not exist! HBase imports will fail.
> > Please set $HBASE_HOME to the root of your HBase installation.
> > Warning: $HADOOP_HOME is deprecated.
> > 12/07/18 13:33:00 INFO manager.SqlManager: Using default fetchSize of
> 1000
> > 12/07/18 13:33:15 ERROR manager.CatalogQueryManager: Failed to list
> > databases
> > com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to
> > the host MT-TRNGSQL/SQLEXPRESS, port 1433 has failed. Error: "null.
> Verify
> > the connection properties. Make sure that an instance of SQL Server is
> > running on the host and accepting TCP/IP connections at the port. Make
> sure
> > that TCP connections to the port are not blocked by a firewall.".
> >
> > and verified the port 1433 is open.
> >
> > Please suggest and help me.
> >
> > Thanks,
> > Prabhu.
> > On Wed, Jul 18, 2012 at 12:19 AM, Chalcy <[email protected]> wrote:
> >
> > > Hi,
> > >
> > > This is one of the very frustrating errors I got about 10 months ago
> when
> > > I set up swoop first.
> > >
> > > Try just list databases, if this works, then everything will work. I
> am
> > > assuming that you could connect to the instance thru' your sqlserver
> > > manager. I would make sure of that first.
> > >
> > > sqoop list-databases --connect
> > > "jdbc:sqlserver://instance:port;username=userid;password=mypassword"
> > >
> > > Also port 1433, make sure it is open. You will know that, by using
> the
> > > following command,
> > > nmap -p 1433 -sT localhost
> > >
> > > Hope this helps,
> > > Chalcy
> > >
> > >
> > > On Tue, Jul 17, 2012 at 12:26 PM, prabhu k <[email protected]>
> wrote:
> > >
> > >> Hi Users,
> > >>
> > >> When i am trying to import sqlserver database table to hive, getting
> > >> following error.
> > >>
> > >> command:
> > >> ==============
> > >>
> > >> $bin/sqoop import --driver
> 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
> > >> --connect 'jdbc:sqlserver://localhost:1433;database=abc;username=sa'
> > >> --hive-overwrite --direct --table slide4_test --hive-import
> > >> --create-hive-table --hive-table slide4_test --fields-terminated-by
> '\t'
> > >> --lines-terminated-by '\n' --append
> > >>
> > >>
> > >> Error:
> > >> ======
> > >>
> > >> sqoop-1.4.1-incubating__hadoop-0.20# bin/sqoop import --driver
> > >> 'com.microsoft.sqlserver.jdbc.SQLServerDriver' --connect
> > >> 'jdbc:sqlserver://localhost:1433;database=abc;username=sa'
> --hive-overwrite
> > >> --direct --table slide4_test --hive-import --create-hive-table
> > >> --hive-table slide4_test --fields-terminated-by '\t'
> --lines-terminated-by
> > >> '\n' --append
> > >>
> > >> Warning: /usr/lib/hbase does not exist! HBase imports will fail.
> > >>
> > >> Please set $HBASE_HOME to the root of your HBase installation.
> > >>
> > >> Warning: $HADOOP_HOME is deprecated.
> > >>
> > >>
> > >>
> > >> 12/07/17 16:56:45 INFO manager.SqlManager: Using default fetchSize of
> 1000
> > >>
> > >> 12/07/17 16:56:45 INFO tool.CodeGenTool: Beginning code generation
> > >>
> > >> 12/07/17 16:56:59 ERROR manager.SqlManager: Error executing statement:
> > >> com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP
> connection to
> > >> the host localhost, port 1433 has failed. Error: "Connection refused.
> > >> Verify the connection properties. Make sure that an instance of SQL
> Server
> > >> is running on the host and accepting TCP/IP connections at the port.
> Make
> > >> sure that TCP connections to the port are not blocked by a firewall.".
> > >>
> > >> com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP
> connection to
> > >> the host localhost, port 1433 has failed. Error: "Connection refused.
> > >> Verify the connection properties. Make sure that an instance of SQL
> Server
> > >> is running on the host and accepting TCP/IP connections at the port.
> Make
> > >> sure that TCP connections to the port are not blocked by a firewall.".
> > >>
> > >> Here, i have one question
> > >>
> > >> 1. How can i test sqlserver is up and running on sqoop import command
> > >> executing machine.
> > >>
> > >> Please suggest and help me.
> > >>
> > >> Thanks,
> > >> Prabhu.
> > >>
> > >>
> > >>
> > >
> > >
>
