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"