Support Questions
Find answers, ask questions, and share your expertise

Connection issue between Microsoft SQL Server Management Studio (Remote machine) and kerberos Hive using Hortonworks ODBC Driver

Connection issue between Microsoft SQL Server Management Studio (Remote machine) and kerberos Hive using Hortonworks ODBC Driver

New Contributor

Hi Team,

 

I'm able to query Kerberos hive using SQL server management studio (SSMS) when I logged in to the "SQL server 2012" machine. I created a linked server say "Link1" which uses the DSN of Hortonworks ODBC driver using the Kerberos method. I also installed/configured MIT 32 bit on the "SQL server 2012" machine. All good till now.

 

When I log into my personal machine and opens SSMS and tries to use linked server "Link1" to access the same Kerberos Hive, I am getting Error "SQL Server Cannot initialize the data source object of OLE DB provider MSDASQL for linked server"

 

My Local machine also has an MIT Kerberos setup.

 

Need someone's help.