Error Connecting Azure Database from Thingworx

Question

I am trying to connect my thingworx to azure postgres database. I have two azure accounts. When I am creating my postgresql database in one of the accounts and connecting then it is working fine.

But when I am trying to connect to the azure postgres database present in the second account , the connection is failing and I am getting the error as follows:

Unable to Invoke Service GetStudentData on Database_Functions : FATAL: Client from Azure Virtual Networks is not allowed to access the server. Please make sure your Virtual Network is correctly configured.

Answer 1

Apparently, the postgresql is part of a Virtual Network service endpoint and a service endpoint tag was enabled.

To solve the problem disable the service endpoint and add the public IP to the Connection Security section.

Answer 2

It seems a firewall rule problem, not at all related to TW itself.