SQLExpress Database Connection URL Format Help Request

CloverDX Platform
1

I found this post in the forum, viewtopic.php?f=4&t=2790

I am having issues trying to format the URL. I get “Unacceptable connection url”. Here is the connection url I am trying to use:
jdbc:sqlserver://manwk005:1433\SQLEXPRESS;databaseName=DataWarehouse-Test

I have also tried jdbc:jtds:sqlserver://manwk005:1433\SQLEXPRESS;databaseName=DataWarehouse-Test
but get

Can’t connect to DB: The syntax of the connection URL ‘jdbc:jtds:sqlserver://manwk005:1433\SQLEXPRESS;databaseName=DataWarehouse-Test’ is invalid.

As far as I can tell, the protocols for SQLEXPRESS TCP/IP are enabled. Any ideas on how to fix the url? Thanks in advance.

Jonathan

2

Hi Jonathan,

It seems that for SQL Express it is not allowed to pick instance (as only one is allowed). Try to change your url to:

jdbc:jtds:sqlserver://manwk005:1433/DataWarehouse-Test

In this format it works for me. (if DataWarehouse-Test is db name)

3

Or alternatively it may work: jdbc:jtds:sqlserver://manwk005:1433;databaseName=DataWarehouse-Test;instance=SQLEXPRESS

There is issue https://bug.javlin.eu/browse/CLO-2338 fixed in upcoming 3.5 version.

4

Thank you for the quick information. I was able to enter the recomended URL in the system. Now on to getting it to connect, which I think might be the sql user setup.