Unexpected response from server during a HTTP connection: authorize: cannot authorize peer.

[valefar]

Hi all,

When attempting to connect to Databricks with Spark ODBC using the regular host ip and port, everything is successful. However, we need to send the connection through an internal proxy service that re-maps the server's endpoint to a local port number (essentially, the host property is replaced with 'localhost' and the port number is replaced with the proxy port). When we do this, we get the error as per the subject. What could be the way to resolve this problem?

Thanks, Valerio

[Kaniz_Fatma]

Hi @valefar, Firstly, ensure your connection settings correctly map the server's endpoint to 'localhost' and the appropriate port number through the proxy service. Double-check your connection string or configuration to align with Databricks workspace details. If connecting to a SQL Server database, confirm you're using the correct JDBC URL format with the port set to 1433. Validate that the proxy service is forwarding requests correctly and handling any required authentication or authorization. Verify ODBC driver settings, ensuring the hostname and port are correctly configured. Enable detailed logging to review any specific error messages or unexpected server responses. Test each adjustment carefully, and if issues persist, let me know.