Forum Discussion
PostgreSQL Invalid credentials
Hi magnetic_north,
Hope you are doing well.
For your query once double-check the Basic Authentication credentials, ensuring the password is correctly passed and matches the AWS RDS configuration.
We can follow these procedures to connect without using the gateway.
- If the PostgreSQL instance has a public IP and the security group allows access, connect directly over the internet.
- If not, set up a VPC Peering or VPN connection for secure access without a Gateway.
Hope these steps should resolve the "Invalid credentials" issue and establish a stable connection to your PostgreSQL database in AWS RDS.
your query was resolved! If our response addressed your question, please mark it as 'Accept Answer' and click 'Yes' if you found it helpful.
Thankyou for your understanding!
Regards,
Sahasra.
Not really. It doesn't explain why the connector cannot handle Basic auth correctly, and using ODBC requires a Microsoft Gateway which this box doesn't have rather than just being natted to the internet. One thing of concern is that the upsertConnection2 request when creating the connection returns password as null. Hopefully that is simply a security step, and not actually passing a null password to the database for auth...
Hi magnetic_north,
Hope you are doing well.
For your query once double-check the Basic Authentication credentials, ensuring the password is correctly passed and matches the AWS RDS configuration.
We can follow these procedures to connect without using the gateway.
- If the PostgreSQL instance has a public IP and the security group allows access, connect directly over the internet.
- If not, set up a VPC Peering or VPN connection for secure access without a Gateway.
Hope these steps should resolve the "Invalid credentials" issue and establish a stable connection to your PostgreSQL database in AWS RDS.
your query was resolved! If our response addressed your question, please mark it as 'Accept Answer' and click 'Yes' if you found it helpful.
Thankyou for your understanding!
Regards,
Sahasra.Hi magnetic_north,
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.
If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.
Thank you for your cooperation. Have a great day.Hi magnetic_north,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thanks for using Microsoft Fabric Community Forum.