SQL server connection error on Edge

Question

I am trying to connect to the SQL server for ingestion and I am getting following error .

Throwable: SQLException: System error: UnknownHostException - ***REDACTED-Server-PROPERTY***

I used the username and password JDBC connection, and I used same username that is on the jobserver . The username/password is working on the jobserver but its throwing error on the edge. Has anyone faced this kind of error before on SQL server connection ?

sweetiranjit · Answer

I am getting the same error message " by: java.lang.Throwable: SQLException: System error: UnknownHostException - ***REDACTED-Server-PROPERTY*** at XcoreXsqlX220X8462.ekc.a(Unknown Source) at XcoreXsqlX220X8462.ekc.b(Unknown Source) at cdata.jdbc.sql.SQLDriver.connect(Unknown Source) at edge.com.collibra.jdbc.connection.DefaultConnectionProvider.getConnection(DefaultConnectionProvider.java:28) at"

Please provide a recommendation to resolve the issue. Edge server version 2024.02.77-7

1	Grant Rollerson SUNCORP CORPORATE SERVICES PTY LTD
2	Tom Friesen Algonquin College
3	SB S Benson Plus3 IT
4	S stefan_busch
5	Brian Lloyd USA TODAY Co.
6	D daverichard