Home > database >  Connecting to Oracle with Kerberos Authentification in Qlik Sense
Connecting to Oracle with Kerberos Authentification in Qlik Sense

Time:10-20

I have a problem for creating an Oracle Database Connection.

This database is using an Kerberos Authentification.

I had no problem with sqlplus client on the qlik sense server to connect to the database, I just have to generate a ticket with an okinit command before.

But when I tried to connect inside Qlik Sense with the Oracle Connection (Simba ODBC connection), it failed.

I think that odbc SIMBA driver tried to connect to the database with a login and password and not with a Kerb ticket.

How can I make understand to Qlik to use a Kerberos ticket to connect the Oracle Database please ?

For the moment, I obtained this error in reply : ORA-01017 Invalid Username/Password.

I'm running on Qlik Sense Enterprise August 2021.

CodePudding user response:

A Service Principal Name may be registered using the following command:

setspn -A http/HOST serviceaccount

where

• HOST is the name of the server hosting Qlik Sense.

• serviceaccount is the account running Qlik Sense services.

Steps:

  1. Open a command prompt with administrative privileges and type :

    Windows Server 2008 / R2 and Windows Server 2012

    setspn -U -S http/QlikServer1 COMPANYX\serviceAccount

    setspn -U -S http/QlikServer1.companyx.local COMPANYX\serviceAccount

  2. Go to the QMC > Proxy > Edit

Check the 'Enable Kerberos' checkbox.

  • Related