In this article, how to resolve the This error might be due to the server has been configured to use SASL in the Big Data / Hadoop cluster for all users or developers.

Big Data ERROR:

(Source code )ErrorCode=UserErrorFailedToConnectOdbcSource,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,(Exception)Message=ERROR [HY000] [Microsoft][ThriftExtension] (4) Error occurred while contacting server: SSL_read: error code: 0. The connection has been configured to not use SASL for authentication. This error might be due to the server has been configured to use SASL (Simple Authentication Security Layer) for authentication. ERROR [HY000] [Microsoft][ThriftExtension] (4) Error occurred while contacting server: SSL_read: error code: 0. The connection has been configured to not use SASL for authentication. This error might be due to the server has been configured to use SASL for authentication.,Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][ThriftExtension] (4) Error occurred while contacting server: SSL_read: error code: 0. The connection has been configured to not use (Simple Authentication Security Layer)SASL for authentication. This error might be due to the server has been configured to use SASL(Simple Authentication Security Layer) for authentication. ERROR [HY000] [Microsoft][ThriftExtension] (4) Error occurred while contacting server: SSL_read: error code: 0. The connection has been configured to not use SASL for authentication. This error might be due to the server has been configured to use SASL for authentication.

Solution

1. Login into Ambari cluster
2.Restart “Hive” Service
3.Re-run the respective application




The above resolution is simple to resolve the SASL error in the Big Data cluster for end users. Basically, this error I faced in the Hive service. If you get this type of error in any services. Try to re-start that service and check it once.