MSSQL Connection error

Greeting,

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.

Kamlesh

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 

jdbc:sqlserver://192.168.1.63:1433;databaseName=<D000Admin>

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

 

Any Help

Thanks

Kamlesh

It works now. 

Thanks Thor

Kamlesh