Setup a scene here. It is bit long. apology

Three independent postgresql DBs in a highly secured enterprise environment in terms of data privacy and DB access.

1. Test Postgresql DB can be accessed from my local PC. DB is hosted in AWS and access is provided by user name and password.
2. Production Postgresql DB1 can only be accessed from a cloud PC. (in fact, it is a remote desktop). The cloud PC is accessed using SSPI or known as SSO which is windows credential integrated.
3. Production Postgresql DB2 can only be accessed from a cloud PC. Again, the cloud PC is accessed using SSPI or known as SSO which is windows credential integrated.
4. Once you logged onto Cloud PC/RDT, you can access production DB1 and DB2 by user name and password. (DB1 and DB2 user name and password are not using windows credentials. in other words, they are not using SSPI)
5. Python connects to Test DB which I use psycopg2.

     connecion = psycopg2.connect(database="XXXX", 
                                 user="XXXXX", 
                                 password="XXXXXXX", 
                                 host="XXXXXXXXXXXXXXXXXXXXX.aws.XXXXXX",                             
                                 port=8432)
   
   

Returns data as expected so all is good.

However, when I try to do the exact same thing for Production DB1 and DB2, it produced an error. "SSPI continuation error: The specified target is unknown or unreachable" is the error message.

My thoughts.

1. this has to do with the fact that DB1/DB2 are accessed from RDT/Cloud PC which is subject to SSPI authentication.

2. Interesting fact.

   a). I can connect to Test DB both on my local PC and from RDT/cloud PC using DBeaver and Python.

   b). I can't connect to production DB1/DB2 on my local PC. Prod DB can only be accessed from RDT/Cloud PC.

Question: What do I need to do to connect production DB in RDT/Cloud PC environment using Python? probably the real question is that how I can bypass cloud PC windows credential check or set up differently in config to avoid SSPI error in Python. I still suspect the error is due to the fact that Python connection string does not have a authentication chain which can provide first authentication for cloud PC environment and then authenticate Production DB access.