Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop from a SQL Sever Named Instance

Highlighted

Sqoop from a SQL Sever Named Instance

Contributor

This code works.

sqoop list-databases --connect jdbc:sqlserver://myserver:1433 --username test --password test


How do I add the named instance to it? I tried the following code but failed.

sqoop list-databases --connect jdbc:sqlserver://myserver:1433\testsql --username test --password test
1 REPLY 1

Re: Sqoop from a SQL Sever Named Instance

Contributor

The correct code should be

sqoop list-databases --connect jdbc:sqlserver://myserver\\sql1:12345 --username test --password test

12345 is the dynamic port for the named instance