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.

score 0 · Accepted Answer · answered Jun 25 '18 at 11:37

0

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.

answered Jun 25 '18 at 11:37

Alberto Morillo

13,893
2
24
30

1

Hi .. can you please tell in bit more detail how can I fix this. – Tarun Jun 25 '18 at 12:02
Remove or disable the VNET rule https://learn.microsoft.com/en-us/azure/postgresql/howto-manage-vnet-using-portal – Alberto Morillo Jun 25 '18 at 12:21

score -1 · Answer 2 · answered Jun 25 '18 at 10:44

-1

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

answered Jun 25 '18 at 10:44

Carles Coll

112
3

Error Connecting Azure Database from Thingworx

2 Answers2