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:
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
Go to the
QMC > Proxy > Edit
Check the 'Enable Kerberos' checkbox.