SQLExpress Database Connection URL Format Help Request

jdelfraisse

• January 09, 2014 00:00

• Answered

Follow

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

• 

  admin

  • January 10, 2014 12:33

  0

  Comment actions Permalink

  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)
• 

  admin

  • January 10, 2014 14:58

  0

  Comment actions Permalink

  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.
• 

  jdelfraisse

  • January 17, 2014 19:22

  0

  Comment actions Permalink

  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.

Please sign in to leave a comment.