JDBC Connection to SQL Server Express - URI

Running Denodo Express VDP on my laptop. Got SQL Express installed and loaded with AdventureWorks DW 2014 data. What would be the URI if this is the case? I am trying to connect via JDBC using the following URI: jdbc:jtds:sqlserver://IA-EME/SQLEXPRESS/AdventureWorksDW2014 Where server name = /IA-EME/SQLEXPRESS Where database name = AdventureWorksDW2014 It is generating an Error > "Unable to establish connection: connection error: Connection timed out: connect" Appreciate the help. Thanks in advance
15-04-2019 10:44:27 -0400

1 Answer

Hi, Generally when I am creating a JDBC connection to connect a SQL server, the Database URI looks like this: jdbc:jtds:sqlserver://host:port/database, where the host is localhost, port is 1433. According to me, you don’t need to specify SQLEXPRESS in the host name. Your error message, > connection error: connection timed out: connect looks like a network issue to me, for more information on this, please refer to the previously answered question [here.](https://community.denodo.com/answers/question/details?questionId=9060g000000XdOhAAK&title=Getting+Connection+TimeOut) Hope this helps!
Denodo Team
16-04-2019 19:04:55 -0400
You must sign in to add an answer. If you do not have an account, you can register here