Search code examples
postgresqlazureazure-sql-databasethingworxazure-postgresql

Error Connecting Azure Database from Thingworx

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.

Solution

  • 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.