sqoop Connecting Sqoop to other databases/datastores Validate the connection
Example
To check that the connection to the server is valid:
sqoop list-tables --connect "jdbc:sqlserver://<server_ip>:1433;database=<database_name>"
--username <user_name>
--password <password>
Before doing this it is recommended to check if SqlServer's configuration allows remote access to 1433 port.
Open Configuration Manager => SQL Server Network configuration => Protocols for MSSQLSERVER and check that Protocol is enabled and the needed IP and port is enabled and is active.
