Error Message:Error occurred while contacting server: invalid sasl status. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server.

Error Message:Error occurred while contacting server: invalid sasl status. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server.

While connecting to the Cloudera Hive data connector connection, it fails with the below error message:
------------------------------------------
Spotfire.Dxp.Data.Adapters.Internals.Common.Configurations [(null)] - Found 1 matching drivers for Cloudera Hive (Cloudera ODBC Driver for Apache Hive)
2018-10-01T17:14:44,846+02:00 2018-10-01 15:14:44,846 spotfire [15] DEBUG Spotfire.Dxp.Data.Adapters.ClouderaHive.ClouderaHiveAdapterConnection [(null)] - Failed to connect.
System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [Cloudera][ThriftExtension] (5) Error occurred while contacting server: invalid sasl status. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server.
ERROR [HY000] [Cloudera][ThriftExtension] (5) Error occurred while contacting server: invalid sasl status. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server.
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
   at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.Odbc.OdbcConnection.Open()
   at Spotfire.Dxp.Data.Adapters.ClouderaHive.ClouderaHiveAdapterConnection.TryOpenConnection(OdbcConnection connection)
2018-10-01T17:14:44,862+02:00 2018-10-01 15:14:44,862 spotfire [Main Thread] ERROR Spotfire.Dxp.Forms.Data.Access.AsynchronousTaskManager [(null)] - Background task failed.
Could not connect due to an unknown error.
External error:
ERROR [HY000] [Cloudera][ThriftExtension] (5) Error occurred while contacting server: invalid sasl status. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server.
ERROR [HY000] [Cloudera][ThriftExtension] (5) Error occurred while contacting server: invalid sasl status. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server.
-------------------------------------------

This error message clearly shows that SSL has been enabled at the database end. To resolve the issue, use the hortonworks connector connection and then connect to the Cloudera hive server from it.

Note: When connecting with SSL enabled, we had to check "Allow-Self signed server Certificate" in the Advanced tab. If issue still persists, check the check-box -> "Allow common name host name mismatch" and then test the behavior.