Purview access postgresql Error: (3912) Connector Exception

Eduardo Evangelista 1 Reputation point
2022-09-30T14:40:30.497+00:00

I try to scan a Azure Postgresql database in Azure purview but receive this message:

"Error: (3912) Connector Exception: Unable to access the with the given credentials."

The Purview account have the get and list in secret permission.

The same credention and secret works fine in Data Factory connection.

Is there something I'm doing wrong?

Azure Database for PostgreSQL
Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
960 questions
{count} votes

2 answers

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 27,892 Reputation points Microsoft Employee
    2022-09-30T19:37:20.127+00:00

    Hi, @Eduardo Evangelista I tried to reproduce the issue from my end and it was a successful connection.
    I hope you are trying to connect to Postgres single server and using SQL authentication

    Please follow this document and prerequisites also do share the error screenshot and the steps you followed.

    Make sure you add the IP address under the connection settings firewall rule.
    246585-image.png

    246611-image.png

    Regards
    Geetha

    0 comments No comments

  2. Eduardo Evangelista 1 Reputation point
    2022-09-30T19:50:39.017+00:00

    The credentials has connected successfully but, gave me the same error in purview scan.

    These are the steps below:
    246553-capture1.png
    246505-capture2.png
    246554-capture3.png
    246622-capture4.png
    246506-capture5.png
    246586-capture6.png
    246595-capture7.png
    246604-capture8.png