On a Windows server, I have a simple Flask app to connect to an Oracle database using kerberos authentication. If I run from command line with Python.exe App.Py, the app successfully connects to Oracle DB using cx_Oracle and runs a simple query and returns the JSON results to the web page.
Next I setup IIS to run Flask apps and I was able to get a simple Hello World Flask app to return a page.
Now I need to run the same Flask app through IIS to connect to the Oracle Database using Kerberos, but the connection fails. Although my ID can establish the connection through Flask command line app or SQLPlus connection, it behaves as if my credentials are not passed through IIS to the Flask app. IIS is setup to use Windows Authentication.
Is there a way to pass through my credentials in IIS so that it establishes the Oracle connection in Flask just like it does when running from the command line?
Copyright Notice：Content Author:「AngusE」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/65890843/how-to-pass-kerberos-authentication-through-iis-to-flask-oracle-connection