Issue getting "Unknown host" in creating new connection using Progress Data Direct jdbc driver for SQL Server.

[manalid668]

Trying to configure a sql server jdbc driver for splunk, configured DataDirect SQL Server JDBC in Splunk DB Connect successfully.
But unable to connect to SQL SErver.

[renjith_nair · Accepted solution]

@manalid668, are you able to resolve the hostname from the server where DBConnect is installed?

Try a ping or nslookup yourhostname from the server. If the server is not able to resolve, then add the hostname/ip

[manalid668]

Thanks.. Resolved by adding hostname in db_connection_types.conf entry.

[renjith_nair]

@manalid668 , if it helped you, please accept it as answer so that someone else could use it