I've installed and configured MIT Kerberos for Windows Hive ODBC connection.
I could not create Kerberos ticket for more than one user, the new ticket created overwrites the existing ticket. Hence multiple user accessing that Windows machine could not obtain a valid ticket to connect to Hive ODBC connections.
I've set krbs.conf from the Hive server and KRB5CCNAME is set to C:\temp\krb5cache.
Please let me know how to configure this to have more valid tickets for each user.
Set up the Kerberos credential cache file. On the Windows system, set the environment variableKRB5CCNAMEto specify the file system location of the cache file. The file must be namedkrb5cache. This location identifies a file, not a directory, and should be unique to each login on the server. When you setKRB5CCNAME, you can specify the value in either a local user environment or within a session. For example, the following command setsKRB5CCNAMEin the session: