I am getting error trying to connect to MSSQL Database. Below is my error message
WARN Database Reader java.sql.SQLException: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: The port number 1433/ABC_123 is not valid.
I have check SQL configration Manager and made sure that it's 1433 Port. Downloaded sqljdbc_3.0.1301.101_enu.tar.gz --> unzip it to a folder and have tried using sqljdbc.jar and sqljdbc4.jar file.
Any help please.
Looks like your connection string is invalid, the driver believes "1433/ABC_123" is the port number.
I have attached the screenshot to my Database Reader Configure. Could you please let me know what is wrong in it.
I changed Data URL to
Now I am getting this error
WARN DBReaderDialogPane Error during fetching metadata from database, reason: java.util.concurrent.TimeoutException
ERROR Database Reader Execute failed: java.sql.SQLException: java.util.concurrent.TimeoutException