Forum Discussion
ADF connection issue with Cassandra
Hi,
I am trying to connect a cassandra DB hosted in azure cosmos db. I created the linked service but getting below error on test connection.
Already checked the cassandra DB and its public network access is set to all networks.
Google suggested enabling SSL but there is no such option in linked service.
Please help.
Failed to connect to the connector. Error code: 'Unknown', message: 'Failed to connect to Cassandra server due to, ErrorCode: InternalError'
Failed to connect to the connector. Error code: 'InternalError', message: 'Failed to connect to Cassandra server due to, ErrorCode: InternalError'
Failed to connect to Cassandra server due to, ErrorCode: InternalError
All hosts tried for query failed (tried 51.107.58.67:10350: SocketException 'A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied')
1 Reply
This usually happens because Azure Cosmos DB Cassandra API requires a secure connection (TLS/SSL) and the correct port. In ADF, the linked service doesn’t expose a simple “Enable SSL” toggle, but you can work around it:
Make sure you’re using the right port – Cosmos DB Cassandra API expects 10350 (not the default 9042).
In the linked service, the connection string needs to specify EnableSsl=true (sometimes you have to include it in the “additional connection properties” field).
Double-check that you’re using the username and password from Cosmos DB Keys (not a local Cassandra login).
Ensure your firewall/network rules allow outbound traffic on that port. Even though “All networks” is enabled, ADF still needs outbound reachability.
A lot of people hit this when ADF defaults to plain Cassandra settings. Adding SSL and the correct port usually fixes it.
