cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
howchoy
New Member

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
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors