Support Questions

Find answers, ask questions, and share your expertise

Sqoop from a SQL Sever Named Instance

Expert 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

Expert 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