Network error IOException: Network is unreachable

Franz_1
Padawan

Dear experts!

I'm trying to import data from MS SQL Server 2019 to my Exasol Community Edition database. But when I'm trying to connect Exasol to MS SQL, I receive this message:

Franz_1_0-1628854340168.png

[Code: 0, SQL State: ETL-5] JDBC-Client-Error: Connecting to 'jdbc:jtds:sqlserver://192.168.245.1:1433;databaseName=Library' as user='sa' failed: Network error IOException: Network is unreachable (connect failed) (Session: 1707982512736829440)

I have followed your method to use JTDS Driver or Microsoft's JDBC driver to connect without success.What are the possible reasons for this situation? How can I successfully connect to my MSSQL?

Thank you,

Franz

2 REPLIES 2

mwellbro
Xpert

Hi @Franz_1 ,

are you running the community as an OVA ( i.e. virtual ) ? Might have something to do with the network config, as the error states the target network is unreachable - maybe this is worth checking out: https://community.exasol.com/t5/discussion-forum/mysql-communication-link-failure-the-driver-has-not... (it´s MySql and a different error message but the underlying problem might be the same ).

Or do you have a "full fledged" on premise install ? Or running on cloud ?

Cheers,
Malte

exa-Chris
Community Manager
Community Manager

Hi, if you want to test, this might be a solution: https://github.com/exasol/database-migration

Connecting Customers, Partners, Prospects and Exasolians is my passion. Apart from that I cycle, listen to music, and try to understand what all those technical discussions really mean...