Using User Name And Password

This authentication mechanism requires a user name and a password.

This authentication mechanism is available only for Hive Server 2 on non-HDInsight distributions.

To configure User Name And Password authentication:

1. Choose one:
• To access authentication options for a DSN, open the ODBC Data Source Administrator where you created the DSN, then select the DSN, and then click Configure.
• Or, to access authentication options for a DSN-less connection, open the Simba Hive ODBC Driver Configuration tool.
2. From the Mechanism drop-down list, select User Name And Password.
3. In the User Name field, type an appropriate user name for accessing the Hive server.
4. In the Password field, type the password corresponding to the user name you typed above.
5. To save the password, select the Save Password (Encrypted) check box.
Important:

Important:

The password is obscured, that is, not saved in plain text. However, it is still possible for the encrypted password to be copied and used.

6. From the Thrift Transport drop-down list, select the transport protocol to use in the Thrift layer.
7. If the Hive server is configured to use SSL, then click SSL Options to configure SSL for the connection. For more information, see Configuring SSL Verification.
8. To save your settings and close the dialog box, click OK.

Related topics

• Configuring Authentication
• Authentication Mechanisms
• Using No Authentication
• Using Kerberos
• Using User Name
• Using Windows Azure HDInsight Service
• Creating a Data Source Name
• Authentication Driver Configuration Options on page 1