Connection Fails Through SSH Tunnel

Error Summary

Hevo is unable to connect to the configured Azure SQL Server Source through the SSH tunnel.

Potential Causes

When connecting to Azure SQL Server through an SSH tunnel, Hevo first connects to the SSH tunnel host, which then forwards the connection request to the database. The Azure gateway that processes this request requires the server name to identify the correct database. As SSH connection requests use localhost IP address as the server name, the gateway cannot route the request to the correct server, causing the connection to fail.

Suggested Action(s)

While configuring the Azure SQL Server Source in the Hevo Pipeline, specify the Database User by combining the database username and server name with the @ symbol using the format <database_username>@<server_name>.

For example, if your database username is hevo and your server name is azuresqlserver.database.windows.net, specify the Database User as hevo@azuresqlserver.database.windows.net.

This ensures that the SSH connection request includes the correct server name so the gateway can route it successfully to your database.

After applying the suggested action, if the issue persists, connection policy on your Azure SQL Server might be set to Redirect. To connect to the database, you must allowlist Hevo’s IP addresses for your region. If you do not want your database to be publicly accessible, change the connection policy to Proxy or Default, which allows Hevo to connect through the SSH tunnel instead of connecting directly to your Azure SQL Server host.