cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
howchoy Occasional Visitor
Occasional Visitor

Microsoft Kerberos Hive ODBC Error: "No authority could be contacted for authentication"

I encountered below error in my laptop while using the ODBC to Get Data in Power BI Desktop. 

 

My environment:

Hadoop

  • Cloudera quickstart VM 5.13
  • Kerberized with MIT

Laptop

  • Windows 10 64 Bit:
  • Microsoft Hive ODBC 64 bit 2.1
  • MIT Kerberos Ticket Manager installed

 

/etc/krb5.conf
[libdefaults]
default_realm = CLOUDERA
dns_lookup_kdc = false
dns_lookup_realm = false
ticket_lifetime = 86400
renew_lifetime = 604800
forwardable = true
default_tgs_enctypes = rc4-hmac
default_tkt_enctypes = rc4-hmac
permitted_enctypes = rc4-hmac
udp_preference_limit = 1
kdc_timeout = 3000
[realms]
CLOUDERA = {
kdc = quickstart.cloudera
admin_server = quickstart.cloudera
}
[domain_realm]

 

Connect to Kerberized Hive thru Microsoft Hive ODBC:

From Power BI, Get Data -> ODBC -> select my ODBC

I entered username and password in Database tab:

username: cloudera

password: cloudera

 

Error in Power BI while connecting to Hive through the ODBC:

Details: "ODBC: ERROR [HY000] [Microsoft][Hardy] (34) Error from server: SASL(-1): generic failure: Failed to initialize security context: No authority could be contacted for authentication.
.
ERROR [HY000] [Microsoft][Hardy] (34) Error from server: SASL(-1): generic failure: Failed to initialize security context: No authority could be contacted for authentication.

 

I tested the ODBC in 64 Bit ODBC Admin without any errors. In addition, I am able to use the ODBC in DBeaver. 

 

Please shed some light on this error. 

 

Thank you.

1 REPLY 1
Microsoft v-yulgu-msft
Microsoft

Re: Microsoft Kerberos Hive ODBC Error: "No authority could be contacted for authentication&quo

Hi @howchoy ,

 

Here is a similar thread for your reference:

Getting errors "No authority could be contacted for authentication." while testing hiveserver2 conne...

 

Besides, please refer to below link to configure Kerberos correctlly.

http://hortonworks.com/wp-content/uploads/2014/05/Product-Guide-HDP-2.1-v1.01.pdf

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors