I am trying to run Sqoop command to get data from RDBMS it is working fine in local environment where there is no anti virus installed but the same code is throwing error in Prod as there we are having Symantec Antivirus installed. I don't know how to resolve this. Below is my Sqoop command.
sqoop list-databases --connect "jdbc:sqlserver://x.xx.xx.xx\\S167;database=DMF;username=test;password=test";
i am getting below error.
ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user
Please help.
After doing a lot of trial and error i finally found the solution. I removed double quotes (" ") and added single quote (' ') and i removed one forward slash ()then it worked for me. Below is the modified code:
sqoop list-databases --connect 'jdbc:sqlserver://x.xx.xx.xx\S167;database=DMF;username=test;password=test';
i feel because the address in an instance we have to use single quote otherwise double quotes. Can someone please help with actual reason.