community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

ERROR [HY000] [Microsoft][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct

MarkelioH
Alteryx
Alteryx
Created

‎08-23-2021 08:44 AM - edited ‎08-23-2021 08:46 AM

Environment Details

The following error is seen when users run a workflow that connects to a Hadoop Impala instance with Kerberos enabled.

 ERROR [HY000] [Microsoft][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct. 

 

image.png

  • Alteryx Designer

    • Version All 

  • Impala with Windows Kerberos Authentication

    • Database Version: 2.11.0-cdh6.0.0, ODBC Client Version: 2.06.07.1007

  • Simba Driver 

    • Apache Impala Simba 2.6.7.10



Cause


The reason why the error occurs is that SSPI is not enabled.



Resolution


If you are using Windows Kerberos authentication (via SSPI), you must select the "Use Only SSPI - Enable for this DSN" option within the Simba Impala ODBC driver Advanced Options.


 

Additional Resources

Labels