I'm trying to create a linked service on Azure Data Factory V2 (from my personal subscription) to an Azure PostgreSQL database hosted by company A (on a different active directory and subscription).
- I have already made sure that the "Allow access to Azure Services" is enabled on the Company A's server (as mentioned in the threads here)
- I have also whitelisted the IP address of the Azure Integration Runtime on Company A's server.
- I can already successfully make SQL queries to Company A's DB using my DB query software + PostgreSQL 13.5 driver (on local machine ofcourse)
- It is important to use the linked service type of "Azure Database for PostgreSQL" because the connection will be used as a source in Data Flows feature. list of linked services tried
- The linked service type of a generic "PostgreSQL" also works!!! But not usable as a source in Data Flows which is my objective.
- This is the error I receive when testing the connection, even though the exact same credentials work on all other ways of making sql queries. Error window on testing connection
- btw SSL encryption without verification is what is supposed to work according the db admin.
Suggestions and further questions are more than welcome! It's my first time asking a question, so tips on better describing problems are also welcome :)
Thanks!
Did you try "validate server cert"? What's your connection string look link in Azure Portal?