[Solved] Impala ODBC SASL Authentication Error

Attempting connection
Failed to establish connection
SQLSTATE: HY000[Cloudera][ThriftExtension] (3) Error occurred while contacting server: ETIMEDOUT. The connection has been configured to use a SASL mechanism for authentication. Please check to see whether the server has been configured to use SASL for authentication

We came across this ODBC connectivity error while trying to connect to an Impala Data Source.

Cause: This cause of this error is that SASL Authentication has not been configured in the Impala Server. 

Resolution: This can be resolved easily by clicking Ok on the error and at the connection Information window uncheck the 'Use Simple Authentication and Security Layer(SASL)' option. 

Now Retest the connection and it will be working fine, provided you have given the correct credentials and connection details to Impala Server.

Copy Virtualbox VDI Image with new UUID

Scenario: We need a new Virtual Box image for OBIEE. We had an already setup VM with Windows 2008 Server and Oracle database installed. So instead of setting up a new Virtual Machine we went ahead with making a copy of the existing Virtual Box.

Resolution Steps:

• Make a copy of the VDI file.

• Find path where VirtualBox file VBoxManage.exe is located.

• Open CMD go the path

• and run the following command,

VBoxManage internalcommands sethduuid PATH/nameofvdifile.vdi

for example: 

VBoxManage internalcommands sethduuid D:/server2008.vdi